Versions Compared

Old Version 13

changes.mady.by.user Jane Zhao

Saved on

compared with

New Version Current

changes.mady.by.user Jane Zhao

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Additional resources:•

...

...

...

...

Data sources

Tableau Viz Examples

Tableau Certification

  • Desktop Desktop Specialist How Level of Detail Expressions Work in Tableau https://onlinehelpwww.tableau.com/currentlearn/procertification/desktop/en-us/calculations_calculatedfields_lod_overview.htm

    • For example, if you attempt to save the following expression, Tableau displays the error message: “Cannot mix aggregate and non-aggregate arguments with this function”: 

      [Sales] – AVG([Sales]). In this expression, [Sales]  is a row level expression, whereas AVG([Sales]) is an aggregate function. 

      The user’s intent in this case was to compare store sales for each individual store to the average of sales for all stores. This can now be accomplished with a level of detail expression:

      [Sales] - {AVG([Sales])}. So the Table-scoped LOD is a row level expression. 

      This is what is known as a table-scoped level of detail expression. See Table-Scoped. 

      Table-Scoped
      It is possible to define a level of detail expression at the table level without using any of the scoping keywords. For example, the following expression returns the minimum (earliest) order date for the entire table:

      {MIN([Order Date])}

      This is equivalent to a FIXED level of detail expression with no dimension declaration:

      {FIXED : MIN([Order Date])}

       

    -specialist
    • Exam Prep Guide: Download Here
    • The tds_sample_data_all.xlsx file, which can be downloaded here. 
  • Tableau Desktop Associate https://www.tableau.com/learn/certification/desktop-certified-associate
    • Exam Prep Guide: Download Here
    • The dataset Sample-Superstore Subset (Excel), which can be downloaded here.
  • Tableau Desktop Professional https://www.tableau.com/learn/certification/desktop-certified-professional

NLSY sample data 

Access and analyze trusted COVID-19 (Coronavirus) global data with Tableau

Data visualization

Mapping with Tableau

Advanced help tips