I want to create Analytics where the visuals change as per the filter/parameter selected.
Eg - I have an analysis for Bot 1 and Bot 2, where the graph and the KPI type are totally different.
So I will have to design/create different visuals for each bot on same page.
My ask is, if I select Bot 1, the designed visuals show up on the page.
And if I select Bot 2, the designed visuals for bot 2 shows up and the visuals for Bot 1 gets hidden on the same sheet.
I was wondering if this could be possible?
Hi @Biswajit_1993
Apologies for delayed reply.
I might not be able to share the exact dataset.
However, I can give you the idea of what I am looking for.
I have 2 categories of bot namely chat & email. They both have different types of KPI’s to be represented.
For now I was only able to show chat KPI visual on the dashboard, but now I need to show the email KPI’s as well.
So if I try to show both at once that might not be a good visual as the viewer might get confused as to what they are looking for.
I need a formula or a quicksight functionality which I can add in the control panel wherein if the user selects chat only the chat visuals show up and if user select email only the email visuals show up without distorting the template designed for the view.
I believe this might not be the sufficient information. Any help will be useful.
Hi @Mudgal ,
Thanks for providing the details query. No issues on datasets but as per my understanding I prepare one excel file and create the analysis.
PFB the steps to achieving the desired results.
Step -1
Create one string type parameter that is selection category and put the static default value as Bot 1
Step - 2
As per my datasets I created 4 KPIS visual.2 is for Bot 1 & another 2 is for Bot 2
Step - 3
Then create the visual level filter for all 4 KPIS chart.
For Bot 1 you just need to select the Bot 1
For Bot 2 you just need to select the Bot 2
Step - 4
Then you need to add the conditional rules for Bot 1 visual and Bot 2 visual.
For Bot 1 go to format visual the select Rules then select hide this visual by default
Then on the Add Rule sections just add the rule as per below picture.
Please do this same for both the Bot 1 visuals.
Next for Bot 2 follow the same process just go to format visuals then Rules then select hide this visual by default
Then on the Add Rule section just add the rule as per below picture.
Please do this same for both the Bot 2 visuals.
Step -5
Then just drag both the Bot 2 visual into Bot 1 visuals .
This things you can do because of use the space on the analysis and for better visualizations.
Step - 6
Then just published the analysis and check the visual.
If you select Bot 1 then Bot 1 visual will show you and if you select Bot 2 then Bot 2 visuals will show you.
I am taking Bot 1 as default parameter that is the reason, by default the Bot 1 data is showing.
