top of page
  • Bernard K

Week-over-Week (WoW) Analysis in Tableau

Updated: Nov 8, 2022


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

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)

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.

If you like the work we do and would like to work with us, drop us an email on our Contacts page and we’ll reach out!

Thank you for reading!

Comentários


Blog.png
Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!

bottom of page