Hello! On a Dashboard showing contribution history, I am trying to order Campaign Fiscal Year in descending order. I cannot find a filter that does this... am I missing it? Looking at the SQL it shows:{ "explicit": true, "multiSelection": true, "members": [ "2023", "2022" ]}
I tried inserting "order by: DESC" after the closing bracket, but it says it's invalid. Any ideas? Am I way overthinking this? Thanks in advance,
Hi Michael,Looks like you found a good solution! I wanted to throw this idea out as a potential alternative solution although I'm not exactly sure how it would work for contribution.My issue was that in my pivot table I wanted to sort events by date order, but you can only filter by A-Z which wasnt useful. I ended up adding an additional column which had the following formula:
MIN(DDiff([Days in Date],NOW([Days in Date])))
Where days in date" was the date of performance. So basically I ended up with a column that had the number of days between now and the event, which wasn't useful on its own, but could be used to sort the pivot table as you could sort smallest to largest. So you could potentially have a column that is "days between now and the start of the campaign year/date" or something similar and sort by that column. Would need some workshopping but its an idea.I wish there was more useful date sorting!!Cheers, Nicola