1 Reply Latest reply on Apr 15, 2017 10:06 AM by giles.somers.1

    Rank diff in 3 month avg between periods, selecting top and bottom

    giles.somers.1

      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?

       

      Thanks