Chapter 5. Adding Flavor – Creating Calculated Fields

In this chapter, we will be covering the following topics:

  • Creating string calculations
  • Creating arithmetic calculations
  • Creating date calculations
  • Creating logic calculations
  • Using Sets in calculations
  • Understanding Table Calculations
  • Understanding Level of Detail (LOD) Calculations
  • Understanding INCLUDE LOD
  • Understanding EXCLUDE LOD
  • Understanding FIXED LOD
  • Understanding how to create and use Parameters

Introduction

In the previous chapter, we saw how to slice and dice our data. In this chapter, we will focus on creating calculated fields in Tableau to give us more flexibility and power. We will also learn how to make use of some predefined calculations and how one can change the scope and direction of these calculations to in turn affect the final result. We will then learn how to empower the end user by giving them the flexibility to pass values, which can then be called in the outcome by creating parameters.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.16.79.65