Date sorting on Chart - toggle between ASC and DESC
Afternoon,
I have a chart in a dashboard with YY-MM date (format 2020-Jul) along the x-axis and revenue plotted up the y axis. The sorting for the dates works fine (oldest to newest) as the date dimension is loaded using a DUAL statement.
What I would like to do is to introduce a toggle button which the user can click on in order to sort the dates either oldest to newest OR newest to oldest - I've tried doing this using a custom button and variable, but cannot find a suitable sort expression that gives the desired results.
