I created a calculated field called ‘Hiring Status’ to review about 5000 lines of data and push out the following outputs:
ifelse(
/if, then/
{Reqs to Review} = 0, ‘2022 Target Met’,
{Reqs to Review} < 0, ‘Gap to Plan’,
/else/
‘Above Plan’
)
Now I want to add a ‘hiring status’ filter to my dashboard with the filter list options of ‘2022 target met’, ‘gap to plan’, and ‘above plan’ so that the user can decide to view any combination of those options. However, I keep getting the error message “Unable to fetch filter values. Refresh later or use the “Custom filter list”.”
Is there any way I can work around this?