Hi mate ,
I have server build date which has started from MMM-YY to MMM-YY .I have taken this month_year combination in one axis .I want to sort this from Jan-2013 to Jan- 2017.
My Question is :How to sort the values from Jan_2013 to so on ?
Please help me on this .
Solved! Go to Solution.
You need to sort this in Text with Numeric format Ascending order from sort tab of Right preview in QS
I would suggest to convert this to a real date, otherwise sorting won't work.
Do it like this:
Thanks Peter for your resolution,
Do you want me to convert date in data load Editor ?
I have already did some migration in Data load Editor .Pls see below
Month(builddate)&'_'&Year(builddate) as Month_year,
Please suggest do I need to give the code line in Data load Editor?
Hi Anil ,Thanks for your suggestion ,
I did it as you suggested ,I have selected sort Numerically and select Ascending but not worked .
Let me know if you need more explanation .
May be attach application, So that we can work for you
Look to the CPU count Month and Year ,which dimension is not sorted ,As advice I have selected sort Numerically and sort Alphabetically. Please help
Thanks Dave ,
I have data from Jan 2013 to Nov 2017 and it will keep on growing .This is no the static data .
As per my knowledge ,The solution you suggest will work for static data .
What if we go using auto Sort?