Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have pie chart and have ageing in legend which is in assorted manner. i want to sort it in ascending.
Any help would be appreciated
PFA
What about age band? How have you grouped data? By Rank function?, With if condition?
Let me k now
Hi Sruti,
I would say load your age band field as a dual, so that each underlying band has a numerical value you can base your sort on.
Hope that helps
Joe
HI Saccone,
I grouped data with if condition
So use the same if condition in the sort ... if(data>0 and data <30, 1, if(data>xx and data < yy,2 .... )
let me know
Add the following to your load script, then sort the field in legend by "Load order". Just make sure in below, the "AgeBand" corresponds to your field name.
AgeBand_SortOrder:
Load * Inline [
AgeBand
0-30 Days
31-60 Days
61-90 Days
91-120 Days
121-150 Days
151-180 Days
181+ Days];