Advance with Assist: Filling in Null Records Without Filtering By Dustin Wyers

Want to Get Latest Updates and Tips on Tableau Bites Blogs

Picture 66

Question: I’m using a table calculation comparing the same month last year, and my view shows blanks due to the date range I have applied. Is there a way to fill
in the blanks correctly?I’ve duplicated the user’s view somewhat using Superstore data. You can see that I’ve filtered to 2017 and 2018 in the view and applied a table calculation for 12 months prior:The goal is to get all the months filled in, as we know our data goes back to 2015. The key issue with this is that we’ve “filtered” out years prior to 2017. We need to keep that data in the view but not display it. That’s where the HIDE functionality comes into play for us. Using a calculation, we can create a calculated field that keeps our desired view intact, as well as the data we need for the table calculation.

Share This Post:

001 database

Tableau Training on
Tap Fast Track

data scientist 1

Tableau Advanced Analyst

002 bar chart


003 network

Tableau Training
on Tap

Share :

Leave a Comment

Your email address will not be published. Required fields are marked *