Forum Discussion
Post ProdigyDate hierarchy incorrectly sorted in graph
I have the following calendar table:
The Month column is sorted using the MonthNumber column:
However when plotted as a hierarchy and drilled down to the lowest level, the months do not sort properly in the graph, instead sorted alphabetically:
How can I sort this properly without adding the Date field into the graph?
Hi olimilo
You have to sort the month or date column by using unique column identifier.Try to sort you month by Date column make sure it does not hold duplicate record.
or either sort Month name with Month number.
check this video for better understanding:
https://www.youtube.com/watch?v=wN1ok8JDzrI
https://www.youtube.com/watch?v=Iw5nKghes7M
I hope I answered your question!
2 Replies
- Deku
Super User
In your screenshot it doesn't show you sorting by month number, it has month selected. Also in the graph you have quarters sorted by descending, not ascending
Uzi2019Community Champion
Hi olimilo
You have to sort the month or date column by using unique column identifier.Try to sort you month by Date column make sure it does not hold duplicate record.
or either sort Month name with Month number.
check this video for better understanding:
https://www.youtube.com/watch?v=wN1ok8JDzrI
https://www.youtube.com/watch?v=Iw5nKghes7M
I hope I answered your question!
