Filter is not updated

[Jesus]

“Filter values cannot be retrieved. Please update later or use the “Custom Filter List”.”

Why does this message appear in the filter? it is with a calculated field, and with the other fields it does not happen. How can I solve it?

[jojeanna]

Hi Jesus, could you provide the calculated field expression?

[Jesus]

@jojeanna,
ifelse(minOver(PublishDate,[{CONVERSATION_ID},Direction=“outbound”],PRE_AGG)=PublishDate,{agent_name},NULL)

this is the calculation, it comes from a previous answer to a query, and the calculation is fine because it returns the information that I require

here is the previous query where more details of the description of the field are given:

How to bring a substring associated with the minimum date and time?

Hello everyone, I need help, I need to know what calculation I must do to register the name of the first person that is registered in a data set, considering date and time, in the example of the image it is a data set that registers messages, I need to calculate the Advisor_S field, where only the name of the advisor who gave the first answer will appear (Jesús David, he replied at 22:37:03) Created At: date and time of the message Conversation ID: Conversation ID Direction: type of message, …

[Max]

What happens when you click refresh?

Also for a filter why are you using this calculated field?

Why don’t you just filter on agent_name?

Or, which is probably the better option, change this field to return a static value instead of agent_name.

filter_field = ifelse(minOver(PublishDate,[{CONVERSATION_ID},Direction=“outbound”],PRE_AGG)=PublishDate,‘Filter’,NULL)

Then in your filter do a custom filter that says it’s equal to ‘Filter’