Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jul 24, 2020, 2:34 PM

Hi all, I am fairly new to Tableau and I'm trying to use the moving average calculation (14 moving average) on a line graph. The function I am using is WINDOW_AVG(SUM([New Cases]) -13, 0) to calculate this.

Ultimately I am trying to figure out the percent difference between the current 14 day average data point and the data point 14 day previous, but when I do the calculation manually they don't match. Any ideas?

1 answer
  1. Jim Dehner - Tableau Visionary HoF (Market Analytics LLC)
    Jul 24, 2020, 3:00 PM

    well we would really need to see the workbook and all the calculations - but you are using a moving average which is a table calculation - think you would be better off with an lod or some other technique - think about using

     

    {fixed: sum ( if date>=today() and date>= dateadd('day',-13,today()) then [new cases] end } to get the current 14 days somethin similar for the pervious - if you don't want to go that route pleas post your book so we have a starting poiont

    thanks

    Jim

Write an answer...
0/9000