Chart properties to sort by Month - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Kelly SanchezKelly Sanchez 

Chart properties to sort by Month

Hello, 

I am trying to get a chart to show performance of each month, compared to that month in previous years. So I want to sort the dates by month, and then show the years. 

This is what I WANT the graph to show: 

User-added image
However, this is what is currently looks like: 
User-added image
I can't seem to separate the month from the year when sorting/grouping that field. 
Best Answer chosen by Kelly Sanchez
Steve MolisSteve Molis
User-added image

All Answers

Steve MolisSteve Molis
What settings and fields are you using in the Report Grouping? 

It looks like you need to group the Report by Month of the Year, and then Group it by Year
ASIF ALIASIF ALI
You need to make changes in your report,
Change it's Group By field to according to your requirement.
Steve MolisSteve Molis
Like this 

User-added image
Steve MolisSteve Molis
User-added image
This was selected as the best answer
Kelly SanchezKelly Sanchez
Thank you! Thats exactly what I needed. I had Calendar Month, but I didn't scroll down to see Calendar month in year. 
Steve MolisSteve Molis
No problem Kelly, glad you wre able to get it sorted out (and thanks for the + Best Answer)