This is still a problem. Creating views, today, saw this again with Month calendar periods. For example,
Jan-2015
Feb-2015
Mar-2015
Apr-2015
Sorts/displays as:
Apr-2015
Feb-2015
Jan-2015
Mar-2015
And since Jaspersoft requires date values to be as smaller or smaller than Days AND the DWH smallest calendar value is Weeks, the Time Series charts are not useable, at all. This is not a total loss, as it seems like the only thing the Time Series charts have vs. Line and Area charts is the ability to move the legend.
Really need to have the calendar values rearranged from Mmm-YYYY format to YYYY-Mmm format.
Is there a workaround that I'm missing? Can we change the calendar formats ourselves? Expect we can, worst case, running some SQL Update scripts against the DWH.
At the wall, ready to drink from the waters - anybody out there? Growing numb, comfortably...wish you were here, feels like I'm on the dark side of the moon....