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
What about age band? How have you grouped data? By Rank function?, With if condition?
Let me k now
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
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
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 [AgeBand0-30 Days31-60 Days61-90 Days91-120 Days121-150 Days151-180 Days181+ Days];
Retrieving data ...