+ Start a Discussion

Using formulas or apex to monitor performance?

I need to build a dashboard that shows (in traffic lights), where problems in the business lie.


For example, records have key data missing, so on each user record I would want to display using traffic lights whether that user is keeping their own records clean. I would then want this to roll up to each business unit, each country etc etc.


Can this be done using formulas, or do I need Apex because it is so complex?



Samuel JohnsonCBESamuel JohnsonCBE
I have an app that I downloaded called Data Quality Dashboard.  You could use the same concept.  Create a formula field "Quality_Score" that puts a value number for each of the fields.  such as  IF(ISBLANK(field_1),0,10)+ IF(ISPICKVAL(field_2,""),0,10)+ ect.  Then create one more formula field and use IF(Quality_Score = 100,  "/img/samples/light_green.gif", IF(Quality_Score => 50, "/img/samples/light_yellow.gif", IF(IF(Quality_Score => 0, "/img/samples/light_red.gif"))).  Some thing along these lines