Hi.
I have an analysis where I created a calculated field with a max(date). Then another calculated field ifelse (max(date) >= X, 0, 1). I need to apply a filter with the result of the ifelse, but it returns the error “Unable to refresh filter values.”. Is it because of the max(date)? How can I do this?
Hello @Jessica_Soares, welcome to the QuickSight community! I would say to apply the filter differently. The calculated field you have that contains the ifelse statement, should be the field you are using in your visual. I’ll use some generic field names to try and explain this.
If your calculated field is meant to display the Sales for the most recent date, you can check if the current date equals max date, if so return Sales else NULL.
Then when you build your filter for this field, you will use Does not include, then you can leave the text field blank or include an impossible value. The most important part is to use the exclude nulls value in the last dropdown to ensure only values related to the last date are displayed.
I will mark this as a solution, but if you have follow-up questions on this topic, please let me know!