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