Additional resources:
• Tableau Starter Kits https://www.tableau.com/learn/starter-kits
• Free How-To Training Videos https://www.tableau.com/learn/training
• Tableau Product Support https://www.tableau.com/support
• Tableau Product Help https://www.tableau.com/support/help
Tableau Certificate Exam Learning Resources
Tableau Online tips: Extracts, live connections, & cloud data
Read more at https://www.tableau.com/about/blog/2016/4/tableau-online-tips-extracts-live-connections-cloud-data-53351#mBSZbbl3ib5KM0W2.99
How Level of Detail Expressions Work in Tableau https://onlinehelp.tableau.com/current/pro/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])}
Standard deviation 5 built-in stats functions you didn’t know Tableau had
Read more at https://www.tableau.com/about/blog/2017/5/5-built-stats-functions-you-didnt-know-tableau-had-71047#Ie7YC370KgmItK3q.99
Q&A
Which type of connection support Extract ? Select all that apply (all four choices)
1. Join
2. Blend
2. Cross Database Join
4. Union