I have a run chart with grouped months [month(ENCOUNTER_DATE)] on the X-axis. These months are sorted from January - December, but I would like to sort the X-axis starting with the first month of the fiscal year (July - June). I tried sorting by an expression that explicitly redefined the order but this did not work:
if(month(ENCOUNTER_DATE) = 7, 1,
if(month(ENCOUNTER_DATE) = 8, 2,
if(month(ENCOUNTER_DATE) = 9, 3,
if(month(ENCOUNTER_DATE) = 10, 4,
if(month(ENCOUNTER_DATE) = 11, 5,
if(month(ENCOUNTER_DATE) = 12, 6,
if(month(ENCOUNTER_DATE) = 1, 7,
if(month(ENCOUNTER_DATE) = 2, 8,
if(month(ENCOUNTER_DATE) = 3, 9,
if(month(ENCOUNTER_DATE) = 4, 10,
if(month(ENCOUNTER_DATE) = 5, 11,
if(month(ENCOUNTER_DATE) = 6, 12))))))))))))
