I hope anybody can help me.
How can I sorting the axis in the Diagramm?
The dimension of the axis consists of the combination of the fields year & month. I want to display the months of each year in the logical order (Starting for example with 2016January,2016 February ..than 2017January...and so on.).
Thank you very much in advance for help.
I suppose that you have Date field, on the sorting options, uncheck all and put this expression on ascending:
PS: Date is your Date field, so if it not called Date, Use your Date field name.
thank you for the Information.
I can use this formula if I only select a date field (Year or Month). But I have two columns (year and month) which I would like to combine (year & month) and then want to show sorted.
I have Change the Diagramm.
Have a nice day.
I have connected year and month as a data field (makeDate). However, sorting with the formula "max (date)" does not work
I used the following Expression (I got an error)