Introduction
This week we will continue working on our dashboard from last week. We’ll improve the design a little bit and work on the interactivity to provide more information and guide the user through the dashboard.
Requirements
- Make the header a solid white box with a a solid line below (same colour as the first bar chart)
- Change the year filter to allow the user to select only one year at a time
- The data in the dashboard should default to 2029
- Instead of absolute discount, calculate the percent discount for each chart
- (List Price – Sale Price) / List Price
- Add a viz in tooltip for each chart, showing the Total List Price and Total Sale Price next to each other
- Change the facetting (filtering) when you click on each chart
- When clicking on a country in the first chart, the 2nd and 3rd chart should be filtered
- When clicking on a Product Category in the 2nd chart, only the 3rd chart should be filtered
- When clicking on the 3rd chart, nothing should be filtered
The resulting dataset should look something like this:
- The list widgets is used to create a dimensional filter: https://help.salesforce.com/s/articleView?id=sf.bi_dashboard_widgets_filter_list_add_flex.htm&type=5
- Create custom calculations with compare tables: https://trailhead.salesforce.com/content/learn/modules/wave_desktop_exploration/wave_calculating_with_the_compare_table
- You can group elements through the use of a container: https://help.salesforce.com/s/articleView?id=sf.bi_dashboard_widgets_container_add_flex.htm&type=5
- You can adjust how a click on one chart filters another through the use of facets: https://help.salesforce.com/s/articleView?id=sf.bi_dashboard_widgets_facet_flex.htm&type=5
Dataset
This weeks challenge builds up on last week. Either build the recipe in the first challenge or upload this dataset and build the dashboard based on this.
Share
After you finish your workout, share a screenshot of your solutions or interesting insights on Twitter using the hashtags #WOW2023 and #CRMA and tag @genetis, @PreenzJ, @LaGMills and @JaackParry. (Or you can use this handy link to do that)
Also make sure to fill out the Submission Tracker to track your progress and help us judge the difficulty of our challenges.
Solution
Below is a solution by Tim Dries from Biztory (thanks for that!)
If you want an additional challenge, you can try to make the filter a “single select drop down”. That’s what I had in mind when I created the challenge but what Tim did here meets the requirements.
Pingback: 2023 Week 04 | Interactions & Toggles – Workout Wednesday