How to get the itens the user selected in the filter?

Question & Answer
, , , , , ,
1

Hey guys,

I have a bar chart with a line that depending on what the user selects in the filter, I need to do a calculation on the line.
If the user selects one filter option, the calculation works, but when he selects two filter items, the calculation does not return the correct value.
How to get the itens the user selected in the filter and put that into a calculated field?
Is there a way to “capture” what the user selected?

Tks!

image
image1046×483 12.2 KB

2

Hi @July
if I see it right you are using a dataset field {user selected filter}. Therefore you are checking row by row.
I assume a row can only be “C” or “R”.

e.g.
grafik

ifelse(
Segment= "SMB", 1,
Segment= "Enterpise", 2,
Segment= "SMB" and Segment = "Enterprise",3,0)

I guess you have to replace {user selected filter} by a parameter where the user can select “C”, “R” or both.

BR

2 Likes