function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
khaitanskkhaitansk 

How to display two Custom Summary formula fields on Dashboard.

Hi,

 

We have a custom object which has the status field with values Status 1 & Status 2.

We are tracking the total time the record stays in each status. We want to display this result on a dashboard.

So, lets say for the Record1, Status 1 =10 and Status 2 =20

For Record2 , Status 1 = 18 and Status 2 = 25

 

The dashboard should display the Status 1 & Status 2 on the X Axis and for the values should be Status 1 = 28 and Status 2 = 45.

 

I am using the Custom Summary formula field to do this. But the dashboard displays the result only for Status 1 on X axis. Status 2 is never shown on the graph.

 

Can anyone please provide some suggestions.

Thanks. !

Best Answer chosen by Admin (Salesforce Developers) 
khaitanskkhaitansk

I was able to do it using Combination chart. 

To use the combination chart in the Dashboard, use "Use chart as defined in source report' option on Dashboard  Component editor.