Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is it possible to change the way the dates are formatted on a line chart right the chart goes back 365 days and is sorted numerically.
the only problem is that the current year weeks 1-12 are listed first but i would like them listed last i would want it to go week 51,51,1,2 and so on is there any way that i can fix this.
May be change the sort order on the week dimension to numeric/descending?
Check this out.
how did you gt it to sort by 2 calendar years
goto sorting tab --> click 'Week' --> Add expression 'num(WeekName(Date)) ' - this is for your case.
if this doesnt work for you, please see the doc that i've attached in my last reply.
Or change the week sort to expression and choose your date field in there