Advanced | Advanced Calculations
Exercise
- Create a view that demonstrates the different Compute Using options for INDEX(), RANK(), and/or FIRST().
- Demonstrate the difference between a data source filter and a table calculation filter.
- Create a view that uses a KPI calculation (Bonus: alter the calculation using a parameter).
- Create a calculated field that can be use to filter customers to only show customer that begin with the letter 'A'. Create another calculated field to only show customer's that have positive profit.
- Explain what the ZN() function does.
- Create a bullet chart.
- Demonstrate the difference between user filters created manually and automatically.
Recommended Viewing
- Table Calculations: http://www.tableausoftware.com/learn/tutorials/on-demand/table-calculat…
- Logical Calculations: http://www.tableausoftware.com/learn/tutorials/on-demand/logical-calcul…
- Number Calculations: http://www.tableausoftware.com/learn/tutorials/on-demand/number-calcula…
- Type Calculations: http://www.tableausoftware.com/learn/tutorials/on-demand/type-conversion
- User Calculations: http://www.tableausoftware.com/learn/tutorials/on-demand/user-calculati…
- R Integration: http://www.tableausoftware.com/learn/tutorials/on-demand/r-integration
Recommended Reading
- Filtering the View Without Filtering Underlying Data: http://kb.tableausoftware.com/articles/howto/filtering-view-without-fil…
- Populating Empty Cells with Zeros or Existing Data: http://kb.tableausoftware.com/articles/knowledgebase/populating-empty-c…
- User Filtering: http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm…
- User Filters and Row Level Security: http://kb.tableausoftware.com/articles/knowledgebase/row-level-security…
- Securing User Filter for Web Editing and Data Server: http://kb.tableausoftware.com/articles/knowledgebase/securing-user-filt…