Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

How to develop gauge dashboard component which will tell me how many records have a blank value in a particular field?

E.g., if there is a total of 100 records in a custom object, and one field is empty in 35 records, my gauge dashboard component should be pointing to "35/100".

Currently, whatever approach I take to make my report, the gauge is always pointing to the max, i.e., the record count.

share|improve this question
1  
Do gauge components support a dynamic max value? Reading the docs, and looking at creating one, it appears that the max is a hard coded value, but I could be wrong. –  Peter Jan 29 '13 at 11:22
    
@Peter, yes you are right: Max is a hard coded value and my requirement can not be fulfilled. Please paste your comment as an answer so I can mark as correct. –  Suman Krishna Saha Feb 10 '13 at 17:20
    
I have put my answer in, but including a suggestion to build the component in Visualforce for the more dynamic feature you need. If you like that, thanks for accepting. :-) –  Peter Feb 11 '13 at 15:39

3 Answers 3

up vote 1 down vote accepted

Gauge components do not support a dynamic max value. This is hard coded.

I would suggest looking into a custom Visualforce dashboard component. It should be relatively simple to build, and should give you more flexibility to do what you want.

share|improve this answer

I would create a formula in the object and assign the blank value a value and non-blank values another value, then you can use this formula field in your report to calculate the ratio.

share|improve this answer

While you can't show absolute numbers, you can show a percentage of field population:

  1. Create a formula field, return type percent, formula: IF(ISBLANK(field),0,1).
  2. Create a report that groups by any field, and uses the average of the formula from 1.
  3. Create a gauge that uses the report from 2, with a maximum of 100, and displaying %.

If you did it right, you'll get this:

Image of % Dashboard

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.