Control on Calculated field (grouping)

dataset is having these fields - country, year-month, retention%.
I have a calculated field country% with formula “ifelse(avg({retention%}, [country]) = 1, ‘100%’,‘Below 100%’)”.

Created a control on country% but it is giving error "Unable to fetch filter values. Refresh later or use the “Custom filter list”.

1 Like

Why don’t you create the control with a static value list 100%, Below 100% and filter the country% calculated field based on the parameter control?

1 Like

Hi @lbl,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @lbl

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!