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
Jeff FriedmanJeff Friedman 

How to define multiple goal amounts in a Custom Summary Formula

I have a report and dashboard that displays the percentage of the goal for that year. I'd like to have three years to compare in the bar graph but I haven't been able to figure out the coding to accomplish that. Currently I am using RowCount / 5000 for 2019 but I'd like to have different goals for the two prior years. Thanks for your help!
Alain CabonAlain Cabon
Hi,

That could be useful to see a snapshot of the current chart and matrix or summary report here.

Show Different Data Sets in One Chart:
A combination chart plots multiple sets of data on a single chart. Each set of data is based on a different field, so values are easy to compare. You can also combine certain chart types to present data in different ways in a single chart.
  • Add up to three more columns to a vertical column chart.
  • Add up to three more bars to a horizontal bar chart.
https://help.salesforce.com/articleView?id=reports_combination_charts_using.htm&type=5
 
Jeff FriedmanJeff Friedman
Here are some pics: [cid:image005.png@01D4784D.68B75FD0] [cid:image006.png@01D4784D.68B75FD0]
Alain CabonAlain Cabon
The images are not shown (useless).
Jeff FriedmanJeff Friedman
User-added imageUser-added image
Ivory TollersIvory Tollers
I also love to achieve my goals. I recently read essays about goals (link here - https://graduateway.com/essay-examples/goals/ ) and was shocked at how many people are like me. But I'm still glad that many people have the right values.
Suraj Tripathi 47Suraj Tripathi 47

Hi Jeff ,

You can also go to the trailhead and understand how we can make it very easily.
step01:Add up to three more columns to a vertical column chart.
step02:Add up to three more bars to a horizontal bar chart.

Here are some steps you can easily make it .

https://www.youtube.com/watch?v=IhlqQ9GcbYM

 
 If you find your Solution then mark this as the best answer.

 

  Thank you!


  Regards,
  Suraj Tripathi