Tableau Challenges #3 Link Tableau Challenges Solutions #3 Link
Join the Vizuators team!
Website: https://vizuators.by/ Telegram: https://t.me/viz_techreview Tableau Public: https://public.tableau.com/app/profile/vizuators.challenges Youtube: https://www.youtube.com/c/Vizuators Instagram: https://instagram.com/vizuators Facebook: https://www.facebook.com/vizuators.by/ Twitter: https://twitter.com/vizuators LinkedIn: https://www.linkedin.com/company/vizuators
Abstract author: Ekaterina Kalabush
Apply the same filter to two data sources with the same Dimension on the dashboard.
Step 1: We have 2 datasources, so we go to Edit Blend Relationships and establish a connection between the Coffee Chain and Superstore by the Market and Region fields (see photo).
Step 2: Drag the Market pill to the Coffee Chain chart and select the Apply to Worksheets = All Using Related Data Sources option and click Show Filter
Step 3: Display the Coffee Chain and Superstore charts on the dashboard, as well as the Market filter.
Done! Now you can filter both graphs using the same filter. The second solution can be found in the video: there Julia demonstrates how to do this task using Actions.
Find out the number of clients who have a higher than average number of records in the dataset. Create a histogram showing this number.
Step 1: Create a Calculated Field Avg per Customer
{SUM([Number of Records])/COUNTD([Customer Name])}
In simple words: we divide [Number of Records] (i.e. how many total orders are made) by the number of unique users. This LOD expression is a fixed number.
Step 2: Create a Calculated Field Number of Records by Client, in which we count how many orders each client has made