2 Replies Latest reply on Nov 19, 2018 2:41 PM by Jessica Reason

    Creating a Metric that is an Average of a Calculated Field

    Jessica Reason

      Hi...

       

      I am trying to get an 'Average' for the attached dashboard....the goal is to understand by year what my month to date average is for the '% Difference by Year'.  I am using Superstore data as an example.Tableau_post.PNG

       

      So on the second line graph above, I'm interested in a reference line for both -13.59% and 67.12% for 2017 and 2018.  What is the calculation for the 'Totals' I have circled above? I know it is (45055-52144)/52144 but what does this look like as a measure (calculated field)?

       

      What does this calculation look like? I thought it was a window_sum, but that wasn't working. See attached workbook using superstore data.

       

      Thanks!