Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i would sort the X-axis data of a line graphic.
It is a date format like DD-MM-YYYY HH:MM:SS, but it is presented on the graphic with this expression "=Month([date])&'/'&Year([date])" --> May/2013.
I tried many function like converting Date to String, but i have never been able to sort.
Could you help me please?
Hi,
Create a new field in your datamodel like
Monthname(Date) as MonthName
Then use thie field in your chart, this will be properly sorted.
The format which this field will have by default is MMM YYYY.
Regards,
Kaushik Solanki
Hi,
Use Date# function.
Date#(Format, Required Format).
Regards,
Khadeer
Hi,
Create a new field in your datamodel like
Monthname(Date) as MonthName
Then use thie field in your chart, this will be properly sorted.
The format which this field will have by default is MMM YYYY.
Regards,
Kaushik Solanki
Properties> Sort--Uncheck All & Check Load Order "Original"
Hope it will work.
regards-bika
This is the right solution!
Great!!