|Custom sorting on a chart X axis [message #496294]
||Mon, 09 November 2009 15:55
| Missing name Missing name
Registered: November 2009
I have created a chart with Strings as the X axis based on a column called Reporting_Period e.g.
These however are not sorted in the way i'd like due to the fact that alphabetical sorting is used.
There are 3 columns of the format
"W/E 15/11/2009" "W/E 08/11/2009" and "2 weeks old+ ".
The report can also be ran monthly in which case the W/E would be replaced with M/E.
When these are rendered I want them to be "date sorted" so this week/month should be the first column, then 1 week/month ago followed by 2 + weeks/months.
I have another column which is periods_old whose values correspond to the number of weeks/months old i.e. 0, 1 and 2 in the above example - is it possible to display the string value but sort on the integers? The "Sort on" field in the "Grouping and Sorting" menu is always disabled so I cant try to sort on the integer column. See attached screenshot for disabled section.
I can change the dataset to return just the date and use that but then I require some logic as follows, which im not sure where to put it (computed column editor doesnt seem to allow if/else syntax)
thanks for any ideas
[Updated on: Mon, 09 November 2009 15:59]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.01812 seconds