Tell me more ×
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.
up vote 3 down vote favorite

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 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 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 at 15:39

2 Answers

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
up vote 0 down vote

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

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.