Apex Code Development You need to sign in to do that
Don't have an account?
jojo10 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?
Thanks
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