If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Line Visualisation - xaxis sort

Started by srmoure, 03 Nov 2020 10:45:54 PM

Previous topic - Next topic

srmoure

Hello,

I'm trying to use a Line visualisation instead of a Line Chart, but I found it hard to sort the months on the x-axis. If I use month name, the sort is April, August, etc. ; when I sort it with the field calendar month number, the sort is 1|January, 10|October, 11|Novemeber.

I cannot find an efficient way to use visualisation.  The Line Chart sorts the calendar month numbers without problem or I can sort the month names using the calendar month number. It seems pretty limited the use of this visualisation in reporting (In Dashboards I can manually sort the months)

It would be faster to use a chart than to create a data item with a CASE statement to sort the months when I already have calendar month number.