From the course: Tableau 10: Mastering Calculations
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Define multilevel conditions using CASE expressions - Tableau Tutorial
From the course: Tableau 10: Mastering Calculations
Define multilevel conditions using CASE expressions
- The if/then keywords, especially when combined with else and else if let you create a set of conditional calculations based on rules you define. Some analysts prefer another format for creating conditional expressions and that is the case structure. In this movie, I will show you how to define multiple level conditions using the case keyword which some analysts think allows for a cleaner easier to read construction. My sample file is the case workbook, and you can find it in the chapter five folder of your exercise files collection. This workbook contains a single sheet and on it I have a visualization that displays order ID, and then product category. The scenario that I imagine for this movie is that you want to perform some sort of a regression analysis on the value of orders based on product category. The problem is that if you're going to do regression you can't have a text or a string value such as furnishings, maintenance and so on. Instead, you need to have those values as…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.