sorting of graphs


Im making a few dashboards, using jasperserver pro (probably switching to aws service, but using this just to test out) and in the ad-hoc views, whenever I make a graph where the x axis is not numerical, it automatically sets it as alphabetical. Is there a way to change this? It creates some weird graphs like this


daniel_17's picture
Joined: Apr 30 2014 - 12:03pm
Last seen: 5 years 2 months ago

1 Answer:


I've done this by constructing the display names for the day field with a numeric suffix: "5 Friday,  1 Monday", etc. Another tactic is to get the sorting you want correct in a crosstab and then switch the Ad Hoc view to a chart.

djohnson53's picture
Joined: May 25 2012 - 11:10am
Last seen: 10 hours 26 min ago

Thank you, setting it to crosstab, adjusting the order and switching it back worked.

daniel_17 - 5 years 6 months ago