Introduction
This week we are going to continue working on our dashboard from last week. We will add some new functionality with interactions and custom queries.
Requirements
- Create a custom query using the dimensions from the dataset you produced in challenge 1. Use the following fields: Product Family, Type and Billing Country.
- Add a Toggle Widget above the Percent Discount charts, and apply the custom query created above.
- Pick initial value and select Product Family on the toggle.
- Within Advanced Editor on the Discount by Product Family Chart, create a selection interaction using the custom query created above. Copy this interaction into the query to allow selections to change the grouping. (Don’t forget about column map!)
- Add this same interaction on the Discount by Product chart to replace the first grouping of Product Family.
- Add a text widget above the discount charts for the chart titles – we want the title of the charts to display what the discount is showing by when a selection on the toggle is made.
- Adding the interactions into the column map is a new feature released with Spring 23. You may still receive a warning message on the chart widgets after applying the interaction. You may need to save and refresh your dashboard to have the interactions to kick in!
- Learn about interactions in CRM Analytics https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_bindings.meta/bi_dev_guide_bindings/bi_dbjson_bindings.htm
- Enrich your data with Dashboard text https://help.salesforce.com/s/articleView?id=sf.bi_dashboard_widgets_text_add_flex.htm&type=5
- Creating a custom query https://help.salesforce.com/s/articleView?id=sf.bi_dashboard_steps_custom_flex.htm&type=5
Dataset
This weeks challenge continues using the recipe and dataset created in our 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 or LinkedIn 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
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Hi, I need a solution to show visualizations when clicking Type or Billing Country on the toggle component. When clicking Product Family on the toggle component, that works as the sample image above. However when clicking Type or Billing Country on the toggle component, that doesn’t work.
P.S. I don’t think it is possible to show visualizations based on the Week 03 output, cuz columnmap, which controls the display of formula of discount percentage, changes to null. That may be why my problems happen.
This question solved by myself, got ideas from this site “https://www.salesforceblogger.com/2023/01/12/bind-to-columnmap/”
This video covers most, but does not cover showing discount percentage but absolute discount, which is out of the requirements here.
https://www.youtube.com/watch?v=Tp9govooAG4