AnalystReps

Tableau practice: Moving windows and time series lookups

Chapter 17 · 5 questions · included in full access

  1. Question 1 · hard

    Three-month moving average

    Create 3 Month Avg: the average of SUM(Sales) over the current month and the two months before it: WINDOW_AVG(SUM([Sales]), -2, 0).

    Solve it in your browser

  2. Question 2 · medium

    Month over month growth

    Create MoM Growth: current month's Sales compared with the previous month: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)).

    Solve it in your browser

  3. Question 3 · easy

    WINDOW offset indexing

    In WINDOW_AVG(SUM([Sales]), start, end), which parameters define a trailing window of the previous month and current month?

    Solve it in your browser

  4. Question 4 · medium

    Rolling two-month sum

    Create Rolling 2M Sum: sum of sales across the previous month and current month: WINDOW_SUM(SUM([Sales]), -1, 0).

    Solve it in your browser

  5. Question 5 · medium

    Prior period sales lookup

    Create Prior Month Sales: fetch the previous mark sales value using LOOKUP(SUM([Sales]), -1).

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing