From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Manage null values using IFNULL and ISNULL

Manage null values using IFNULL and ISNULL - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Manage null values using IFNULL and ISNULL

- [Instructor] One thing that almost all data analysts hate is the null value. Unlike a zero, which could indicate zero sales on a day a store is closed or revenue from sending out a free sample, a null value is simply missing. In this movie, I will show you how to manage null values using the If Null and Is Null functions. My sample file is the HandleNulls workbook, and you can find it in the chapter five folder of your exercise files collection. This workbook contains a visualization where I display a list of clients and the number of rooms that they believe that they will need for a conference, and then the room block size. Block size refers to the number of rooms that a client will need to commit to at a time. In other words, we don't want them reserving one room or two rooms at a time. Instead, we want them to commit to 12 or 24, so there's a lot less work for the hotel. Note, however, that we do not have block sizes for INVT or for MFST. So that means that we need to create a…

Contents