Generally gauge chart components are used to show no of records. But I have a single record with one column count 30. That I want to show using gauge chart so my needle should point to 30. But when I used gauge component then it points towards 1 only. How can I make it to point 30? Any ideas?
3
-
It would help to know how your report is setup and how this field is defined.– Mike ChaleCommented Nov 28, 2012 at 12:10
-
Since you're mentioning the "needle" in your question, I assume you're asking for report/dashboard chart components and not visualforce chart components (salesforce.com/us/developer/docs/pages/…) - you might want to make that explicit in the question.– sorenkrabbeCommented Nov 28, 2012 at 13:03
-
I have a custom object with two fields "Account Name" and "Count". And I have only 1 record in this object which is like "IBM", 30. And yes it is dashboard component.– dogaCommented Nov 29, 2012 at 3:12
Add a comment
|
1 Answer
I was able to make this work with the following setup:
- A custom number column, Account.ColumnCount__c
- Created a Summary Report
- Grouped by Account Name
- Summarize ColumnCount: hover over the column heading and click on the triangle that appears and then select Summarize this Field. Choose Sum from the aggregation options presented
- Create a new Dashboard
- Added a Gauge
- Selected by report as the Data Source
- The widget automatically chose
Sum of ColumnCountand the needle pointed to 30
answered Nov 28, 2012 at 12:10
