Happy Easter weekend
As is usually the case, a seemingly simple chart becomes something rather complex.
I'm looking to show the accounts that have made the largest positive and negative contributions between two dates (3 or 6 months apart).
To iron out variability, I'd like to use 3 month averages.
Comparing values from different dates is already surprisingly tricky in Tableau.
Datediff calcs don't seem to work because the moving average is a calc
I have a table of the difference between two periods, but because tableau can't sort on a calculated field, I had to use the discrete data ordering trick
This doesn't though allow top /bottom rankings to be used, because the sorting messes up the index!
One thing after another, which is incredibly frustrating.
Any ideas please?
Figured out a different, but solution with this helpful blog
Many thanks to the author (and the authors of other similarly useful articles!)