How to arrange the by "time" column in order of latest date first in chart command?

[abhi04]

index=auto_prod_rmt sourcetype=auto_prod_rmt_healthcheck earliest=-7d |rex field=_raw "Application=(?.)\sTask" |rex field=_raw "Message=(?.)" |sort Application_Name | eval time=strftime(_time, "%d/%m/%Y") |dedup Application_Name,time | eval new_time = time.":".date_wday |sort -time|chart values(Status) over Application_Name by new_time

I want "new_time" to be arranged in order of todays date first and so on.
Please help me in achieving the same.

[cmerriman]

from looking at this, I would redo the time format to be %Y/%m/%d, so that it would sort chronologically.

[abhi04]

Tried below but does not help:

index=auto_prod_rmt sourcetype=auto_prod_rmt_healthcheck earliest=-7d |rex field=_raw "Application=(?.)\sTask" |rex field=_raw "Message=(?.)" |sort Application_Name | eval new_time=strftime(_time, "%Y/%m/%d") | dedup Application_Name, new_time | sort new_time| chart values(Status) over Application_Name by new_time

[cmerriman]

can you share an output?