Aggregated calculated column values cannot be fetched

[pantelis]

I have created a calculated field as

ifelse(
    max({contains_overtime},[{event_id}]) = 1,
    'Yes',
    'No'
    )

and then I want to have control on top where I can filter ‘Yes’ or ‘No’
But instead I get the below error
”Aggregated calculated column values cannot be fetched”

how I can include the filter?

[Xclipse]

Hi @pantelis

Could you please try the below solution, this might be helpful for you.

Issue adding a calculated field as a filter

Hi Erik! Thanks so much for your response. The calculated field is called “Best Seller?” and is as follows: ifelse({% of vendor revenue}<0.05,“Low Seller”,{% of vendor revenue}<0.3,“Medium Seller”,“Top Seller”) The % of vendor revenue is also a calculated field, as follows: sum({p_rev_t12w})/sumOver(sum({p_rev_t12w}),[{company_vendor_code},{marketplace_id}]) These are normal metrics, not calculated fields. What I want to do is add the “Best Seller?” calculated field as a filter on top of t…

[Xclipse]

Hi @pantelis

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @pantelis

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!