Current vs. Previous 4-Week KPIs in Tableau

Overview

In Tableau, comparing Current vs. Previous 4‑Week KPIs is a powerful way to evaluate short‑term performance trends without the noise of daily fluctuations or the long lag of quarterly reporting. The current 4‑week KPI represents the aggregated value of a metric - such as sales, conversions, or service tickets - across the most recent four complete weeks of data. This rolling window updates continuously, giving teams a near‑real‑time snapshot of how the business is performing right now.

The previous 4‑week KPI captures the same metric but for the four‑week period immediately before the current window. By placing these two periods side by side, Tableau enables clear comparisons that highlight momentum: whether performance is accelerating, plateauing, or declining. This comparison becomes especially valuable when paired with percentage change calculations, color‑coded indicators, or sparklines that visually reinforce the direction of movement. Together, these KPIs help organizations quickly identify emerging patterns, validate the impact of recent initiatives, and make timely, data‑driven adjustments.

Computing Current 4-Week Sales

Note you can compute the current 4-week sales using any of the following calculations.

Computing Previous 4-Week Sales

Similarly, you can compute the previous 4-week sales using any of the following calculations.

Calculating Difference & Indicators

Note you can compute the percent difference as follows: (current 4-week sales – previous 4-week sales)/previous 4-week sales.

Next compute the indicators using the following calculation.

Visualizing the KPIs

Lastly, combine the current performance, the prior performance, the percent difference, and the indicator (as a shape or icon) to visualize your KPI as shown below.

Conclusion

The use of current vs. previous 4‑week KPIs in Tableau provides a disciplined way to track momentum, smooth out weekly volatility, and surface meaningful performance shifts earlier. By anchoring calculations to fixed windows, applying consistent date logic, and pairing KPIs with intuitive indicators such as deltas and directional arrows, teams gain a clearer view of whether performance is accelerating, stabilizing, or declining. This approach not only strengthens analytical accuracy but also improves communication - executives see trends at a glance, analysts can diagnose changes faster, and dashboards become more reliable for ongoing operational decisions. Ultimately, rolling 4‑week comparisons turn raw data into a steady narrative of progress, enabling organizations to respond with confidence rather than react to noise.

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!!