Forum Discussion
Sort by quarter dates
Hi,
I have a master table containing transactional data that I then group by quarter and display in a bar and line chart.
My goal is to display the data having the quarter dates (start/ end) in the x-axis, however even after trying sorting and creating a support table to link with the master for the purpose of sorting, it doesn't seem to work.
Any ideas on why?
Thank you
This is my sorting table
This is the chart I get
- Anonymous4 years ago
Hi joao_costa ,
Add the index column to tooltips field then you could sort the visual by index directly.
Best Regards,
Jay
3 Replies
- amitchandakSuper User
joao_costa , Make sure index is marked as the sort column of Quarter Month
and visual is sort on Quarter Month
How to Create Sort Column and Solve Related Errors: https://www.youtube.com/watch?v=KK1zu4MBb-c
- joao_costaNew Member
Yes that's correct, all sorted as mentioned
- AnonymousNot applicable
Hi joao_costa ,
Add the index column to tooltips field then you could sort the visual by index directly.
Best Regards,
Jay