Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HEy,
I want to show my values of Day-Month-Year as on X-axis in ascending order. But my dates are coming in descending order.
How to do it ??
Please help.
Thanks.
hi
try in properties -> sort -> your field -> select ascending
HEy,
It does not work.
Can you share sample qvw?
Hey,
Please find the attached sample.
Thanks
Hi,
Instead of using calculated dimension use Date Field as your dimension.
Since you are calculating Day,Month and Year from Date field.
Take Date Field in while loading and add it as dimension
If you want your Date field in DD-MMM-YYYY format then
you can format in while loading like Date(Date,'DD-MMM-YYYY') as NewDate
and take that newDate as your dimension then go to sort property-> Numeric value->descending
Regards,
Sort - > SELECT THE NUMERIC Value -> ASCENDING
or sort by expression in worst case!
num(Datefield)
Sort by expression (Ascending):
=Date#(Day&Month&Year, 'DDMMMYYYY')
However, it is always recommended to create a proper date field in the script to avoid such issues and enhance your app quality.
PFA
@Check attached