Launch, grow, and unlock your career in data

April 21, 2022

#B2VB - 2022/W4 - Design Some KPIs

No comments
In this session, I worked on Back to Viz Basics (#B2VB) week 4 and designed as many KPIs as I could in an hour. The video and workbook are below the resources and links.


  1. Back to Viz Basics
  2. Week 4 Challenge
  3. My Workbook

KPI Samples from Tableau Public:

April 19, 2022

How to Calculate YTD vs. Prior YTD Based on a Selected Date

No comments
In this tip, I show you how to calculate year over year change based on a date selected with a parameter. The use case is to calculate YTD sales depending on the date selected and compare it to the prior YTD sales for the same period.

April 12, 2022

How to Show Data for Only Completed Periods

No comments
In this tip, I show you how to filter your data to only completed weeks. This method can be extended to completed months, quarters or years. All you have to do is swap out the word 'week' in the filter calculation.

April 5, 2022

How to Always Sort a Dimension to the Bottom of a Chart

No comments
In this tip, I show you how to use a calculated field to always sort a specific dimension to the bottom of a chart. You can also always have a dimension at the top, you simply change the sort from Descending to Ascending. This also works with column charts that sort left-to-right.