Hi I have created a paramenter with the following options to select from Handled Calls
AHT, SL, Waiting Time. And what I want to see then in my table are exactly those names, so I was doing something like this, but it does not work, any hints on what I´m doing wrong?
ifelse(${KPI}=‘Handled Calls’,‘Handled Calls’,
${KPI}=‘AHT’, ‘AHT’,
${KPI}=‘SL’,‘SL’,
${KPI}=‘Waiting Time’, ‘Waiting Time’,
‘Other’
)
Hi @Filipa
Since you say the user can select multiple values from the parameter use the IN function
ifelse(IN(“AHT”, ${KPI} = "AHT … and so on
If user selects more than one value in your parameter you get “Other”
Regards,
Giri
Can you tell me exactly how the formula would work?
ifelse(in(‘AHT’, ${KPI} = ‘AHT’),
in(‘Handled Calls’, ${KPI} = ‘Handled Calls’),
‘Other’)
This is not working
Thanks
Hi @Filipa
Handling the initial value for the multi-value parameter is a bit tricky.
I created the parameter and included a dummy value All
When I added the Parameter Control to the sheet I don’t have the All value
I then created my calculated field as follows
Results
1 Like
This does not work well for me because it only allows me to choose one at the time, and I need to select multiple, this is not possible in quicksight? I would like to be able to select all for instance and get the handled calls, SL, waiting time, AHT or to select handled calls and waiting time, at the moment only 1 is allowed
Hi @Filipa
I am not sure what you are trying to achieve. Let us say you selected Handled Calls and Waiting Time what is the result expected and what you will do with it in your visualization?
Can you elaborate a bit?
Regards,
Giri
Hi @Giridhar.Prabhu my end goal will be to get a table where I have:
Actuals Budget Deviation
handled calls
waiting time
AHT
My dataset as each KPI as columns so I don´t manage to create this table unless I first create the KPIs names as a paramenter to add to the column and then I would do something similiar for the values with another paramenter where I would say ifelse KPI=AHT and value=Budget, sum(aht_budget) and so on
Hi @Giridhar.Prabhu I don´t have a column for the KPI value, my dataset is something like this
| Datum | POS | Handled Calls_actuals | Handled Calls_Budget | AHT_Actuals | AHT_Budget | SL_actuals | Waiting Time_actuals |
|---|---|---|---|---|---|---|---|
| 11/2/2025 | DACH | 0.33 | 0.33 | 0.80 | 0.26 | 0.59 | |
| 11/2/2025 | FR | 1.33 | 1.33 | 1.80 | 1.00 | 1.26 | 1.59 |
Hi @Filipa
Ideally you should UNPIVOT this data to get KPI and Scenario (Actual/Budget) as two columns. If you can get that done you can deal with the visualization quite easily.
Otherwise we need to deal with the UNPIVOT using calculated fields
Regards,
Giri
changing the dataset is not possible because multiple people are using it, going with the calculated fields is what I´m trying to do, any suggestion here?
Thanks
Filipa
Hi @Filipa
That is a bit tricky. However, there is some advanced calculation that can probably achieve that.
There is a nice video by @DylanM
- Create a calculated field for KPI (Handled Calls, AHT etc) using the same mechanism as Groups A, B, C etc that the video below talks about. These are dummy values created with no direct links to your dataset
- Then create two calculated fields for the two scenarios Actual and Budget to get the values from the respective columns in your dataset
- You can then filter KPI calculated field based on the Parameter selection
Results
1 Like
Hello @Filipa, since we have not heard back from you with any remaining questions, I will mark the previous response from @Giridhar.Prabhu as the solution. If you require more information, please let us know. Thank you!