+ Start a Discussion
Rajesh BhoirRajesh Bhoir 

Superbadge- Reports & Dashboards- Step 2

Hi All,
I am trying to create a dashboard with Title “Number of deals and amount”. I got the below combination chart with all the required details but the only problem is how do I get “# of deals” label. Currently it shows record count on the Y axis at right hand side where as it should be” Number of Deals” as per the trailhead requirement.

User-added image
Now record count is nothing but number of closed won opportunities which are equal to number of deals. I am not sure if I am missing any step or is there any way to change the labels on Y axis.

Any help is really appreciated
Hans LissHans Liss
I didn't have to do that for the superbadge, but it turns out it's pretty easy. Just create a new formula field in the report, call it "# of deals", display on all summary levels and use the formula "RowCount". Then you can use this field in the dashboard.
Rajesh BhoirRajesh Bhoir
Thanks Hans for the guidance.
Hans LissHans Liss
Hope it helped! Please mark the message as "Best answer" if it solved your problem!