Question on Dashboards
![Mike Egenlauf](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to create a graph on my dashboard that shows a month by month historical trend line graph. When I try and graph out the info it sorts the months by alphabetical order rather than in the correct order. I have 2 columns on my source sheet pulled into a report one that shows the date an item was entered and I have a formula for another column to convert that date to a month only. Any advice on how to do this would be great.
Answers
-
Have you tried sorting the report on the date column?
-
Yes I had it sorted on the date and then grouped by the month field it seems like that month field is not able to be sorted since it's not really a date just the month.
-
My suggestion then would be to adjust your formula that outputs the month name so that it is
01 - January
02 - February
03 - March
or something to that effect.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives