Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day
i'm having trouble sorting my data on line graph, i cannot drag and drop:
i would like to put my Fiscal Year on top as our Fiscal year start in July:
If I got your request right the behavior of the Line chart is working as expected (meaning that is correct that you cannot drag and drop in that situation). What you can do to sort the Months starting from "July" is to go to the "Sorting" tab, select "MonthName", "Sort by Expression" and set the following expression: =match(YourMonthField,'Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun')
In any case, I would strongly suggest setting this kind of thing directly in the data load editor within your master calendar script 😊
😊😊
If I got your request right the behavior of the Line chart is working as expected (meaning that is correct that you cannot drag and drop in that situation). What you can do to sort the Months starting from "July" is to go to the "Sorting" tab, select "MonthName", "Sort by Expression" and set the following expression: =match(YourMonthField,'Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun')
In any case, I would strongly suggest setting this kind of thing directly in the data load editor within your master calendar script 😊
😊😊