Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi,
kindly find the attached updated file.
i hope it will help you.
Thanks,
Mukram
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:
Date(MakeDate(RIGHT(YOURDATEFIELD,4),LEFT(YOURDATEFIELD,3)),'MMM-YYYY')
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?
Regards
Sushanta
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 .
Regards
Sushanta
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
you can create and load a mapping table like this
and then sort by "SortMonth"
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 .
Regards
Sushanta
What if we go using auto Sort?