top of page

How to make WTD, MTD, QTD, and YTD calculations dynamic using a parameter in Tableau

Writer's picture: Bernard KilonzoBernard Kilonzo
dynamic change wtd, mtd, qtd, and ytd in tableau using a parameter

In previous articles, I shared different ways to compute WTD vs PWTD, MTD vs PMTD, QTD vs PQTD, and YTD vs PYTD in Tableau.

In this article I would like to explore this subject further, by demonstrating how you can dynamically compute WTD, MTD, QTD and YTD using a parameter – in a single calculation (without writing several calculations for each period).

To do that, let’s first create a parameter named ‘Period’ as shown below.

create parameter in Tableau

(This string parameter contains a list of items namely, ‘week’ displayed as ‘WTD’, ‘month’ displayed as ‘MTD’, ‘quarter’ displayed as ‘QTD’, and ‘year’ displayed as ‘YTD’).

Create a filter calculation

Next create a calculation to filter the period or timeline being evaluated. Using the following calculation.

tableau calculation

(Notice in this calculation I have simply replaced the date part with the parameter - enabling end-users to control which date part is applied in the computation).

Create a view

Create a view, in this case an area chart showing the Sales generated each day.

Add the calculation ‘Period filter’ to the filters shelf and select ‘TRUE’.

area chart

(This view shows the Sales generated each day between the start of the month and the current date (15/12/2022 – the day when this article was drafted) – Notice when you adjust the parameter from the current selection ‘MTD’ to other periods the axis will adjust accordingly).

E.g., See what happens when I adjust the parameter value from MTD to QTD.

area chart

(This view returns all transactions between the start of the current quarter to the current day – 15/12/2022)

Compute Change from Prior Period

To compute the percent change from the prior period. You can use the following calculation.

Change (%) = (Current Period (CP) – Prior Period (PP))/Prior Period (PP)

For quick follow-up – let’s breakdown these computations as follows.

tableau calculation computing the current period
tableau calculation computing the prior period

(Notice in the above two calculations have replaced the date parts with the parameter ‘Period’)

Now let’s compute the percent change as follows.

tableau calculation computing the percent change between current and prior period

(This calculation computes the percent change between the current period selected on the parameter and the prior period)

Now let’s show the percent change as a BAN, by adding ‘Current period (CP)’ and ‘% change’ calculations to the view as shown below.

Add the shape KPI to show the direction of change. Read this guide!

KPI value

Combining the two views to create this dashboard – with which users can compute the performance based on the different periods by simply changing the value on the parameter control.

tableau dashboard

This could also be presented as shown below by leveraging parameter actions to control the parameter.

sample dashboard with which users can dynamically change computations using a parameter

I hope this article was helpful to you. If you wish to receive more 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!

Original.png

We Support You Deliver Business-Focused Solutions That Enable Data-Driven Decision Making.

  • Tableau profile
  • YouTube
  • White LinkedIn Icon
  • Facebook
  • X

QUICK LINKS

CONTACT US

+254 738 307 495

East Gate Mall, Donholm

3rd Floor Suite No. 3i

Nairobi, Kenya

Join our mailing list

bottom of page