Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have the problem if i want see data from the last twelve months that the months are not in the correct "sequence".
it starts in june 2020 and ends in Mai 2020. You can see it in the attachment.
Any idea whats wrong? I tried any things but nothing worked correctly .
in the diagramm for the last 6 months i can see it correct with the same settings?
Thank you!
Roland
I think you missed file attachment , please attach your qvf
Ooops!
Create a field in script by using
Num(Month(DateField)) as MonthNum;
Sort tab:
Expression : MonthNum
or
Expression: match(Month,'Jan','Feb','Mar' ...)
or
wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')
only({1})- with this it wont change the order.