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
Dec 13, 2022, 4:10 PM

I wanted to calculate WOW with having weekend dates as my date field.

I have weekend dates (every Saturday) in my date field & installs as measure field.

I want to calculate WoW of Installs for latest week only.

Book1.twbx
4 answers
  1. Don Wise
    Dec 13, 2022, 6:39 PM

    This will give you the last week's value (Week-over-Week) for Installs:

    IF MAX(WEEK([Week]))=MAX({FIXED : MAX(WEEK([Week]))})
    THEN (ZN(SUM([Installs])) - LOOKUP(ZN(SUM([Installs])), -1)) / ABS(LOOKUP(ZN(SUM([Installs])), -1)) END

    It doesn't require or use a Date Filter. See the highlighted box below as the result of the above calculation:

    This will give you the last week's value (Week-over-Week) for Installs:IF MAX(WEEK([Week]))=MAX({FIXED : MAX(WEEK([Week]))})THEN (ZN(SUM([Installs])) - LOOKUP(ZN(SUM([Installs])), -1)) / ABS(LOOKUP(ZN

Write an answer...
0/9000