Data is shown with months across X axis. If no order is specified the months appear in random order as expected (well... not as expected because I would expect it to appear in the order it appears in the data, but unordered nonetheless).
However, when adding an order rule to the x axis (which is a numeric field) it doesn't support by the specified field but rather sorts the months from Jan to Dec. I don't want the month to start at Jan... it needs to start at the current month.
I am thinking there must be some logic that identifies the data looks like month names and automatically guesses it should sort them... and maybe this logic is getting mistakenly triggered and ignoring the fact I specified a SeqNo field with number values to sort by?
Data is shown with months across X axis. If no order is specified the months appear in random order as expected (well... not as expected because I would expect it to appear in the order it appears in the data, but unordered nonetheless).
However, when adding an order rule to the x axis (which is a numeric field) it doesn't support by the specified field but rather sorts the months from Jan to Dec. I don't want the month to start at Jan... it needs to start at the current month.
I am thinking there must be some logic that identifies the data looks like month names and automatically guesses it should sort them... and maybe this logic is getting mistakenly triggered and ignoring the fact I specified a SeqNo field with number values to sort by?