Create calculated field with multiselect parameter

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

  1. 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

  1. Then create two calculated fields for the two scenarios Actual and Budget to get the values from the respective columns in your dataset

  1. You can then filter KPI calculated field based on the Parameter selection

Results

2 Likes