New to Jaspersoft - training class pending.
In the meantime, in ad-hoc views, pulling in calendar periods (Quarterly) and noticed that they are presented in QQ-YYYY format. Also, noticed that when sorting on quarter, they are sorted alphanumerically, not by time/date. So, when I sort, ascending and expect:
Instead, I get
Expect the underlying quarter data stored in the datamart is text - not date and that it needs to be changed from QQ-YYYY to YYYY-QQ in order to sort properly.
Any suggestions? Or, is sorting "calendar data as if it were calendar data instead of text" an Idea that needs submission?