Lead magnet - project 1.png
  • Bernard

Week-over-Week (WoW) Analysis in Tableau


Week over week analysis in tableau

Introduction

Week-over-week (WoW) analysis shows how a given variable increases or decreases from one week to the next. For example, a 4% WoW sales growth would imply that the current week sales increased by 4% percent when compared with the previous week sales

Visually, such data would be presented as shown below.

Visualizing week over week analysis in tableau

(Which shows the daily sales, over the two periods – i.e., current week sales against the previous week sales)

The problem with this presentation is that it doesn’t quantify what this growth is – and therefore in this short article I am going to share three ways to do WoW analysis in Tableau.

A Quick Way

One of the ways you can compute the WoW growth is by using the WTD (Week-to-Date) values and PWTD (Previous Week-to-Date) values.

In a simple calculation, this is how you can compute the WoW growth, assuming you’ve already computed WTD and PWTD values.

WoW Growth = ((WTD Value – PWTD Value)/PWTD Value) *100

Useful: Learn how to compute WTD vs PWTD values in Tableau

The problem with this approach is that it locks the computation to a single section of the timeline (i.e., current week against the previous week based on the current date), unless you use a parameter to enable dynamic selection of the week you would like to evaluate.

A More General Approach

A more general approach to computing WoW growth, would be by comparing all weeks against the previous weeks for the entire data at ago, rather than evaluating one week at a time.

To do this using the Sample-Superstore dataset.

Add Order Date to the row shelf (change the level of detail to WEEK)

Add Sales to the text/label shelf

(To show the Sales by week – filtered by year)

Next compute previous week sales using the following calculation.

Using lookup function to compute previous week sales in tableau

(This LOOKUP function basically returns the Sales value in the previous row – which is simply the previous week Sales)

Useful: Read more about the LOOKUP function in Tableau

Next drag the above calculation to the view to see.

Now using this calculation, one can compute the week-on-week change using the calculation below.

Week over week change in tableau

Dragging the above calculation to the view, we’ve.

(Which shows how the sales increases or decreases from one week to the other)

A Simpler Approach

A simpler approach would be creating the table first - by.

Adding Order Date to the row shelf (change the level of detail to WEEK)

And Sales to the text/label shelf

(To show the sales by week – filtered by year)

Next add a table calculation ‘Percent Difference’.

table calculation percent difference

(This computes the percent difference table (down), relative to the previous week – which simply put is comparing the week’s sales to that of previous week, returning the same results like in the previous case)

I hope this article was helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

Thank you for reading.