Versions Compared

Old Version 10

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

NLSY sample data 

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

Data visualization

Mapping with Tableau

Advanced help tips

  • Pointing Tableau to a Named Range https://interworks.com/blog/2021/01/26/advance-with-assist-pointing-tableau-to-a-named-range/
  • What is VizQL https://www.tableau.com/drive/what-is-vizql
  • Plan the data source https://help.tableau.com/current/pro/desktop/en-us/datasource_plan.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])}