#B2VB - 2022/W4 - Design Some KPIs

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:

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

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.

How to Show Data for Only Completed Periods

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.

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

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.