Hi everyone! I was looking at this older documentation: https://help.gooddata.com/doc/growth/en/dashboards-and-insights/maql-analytical-query[…]ference/filter-expressions/filtering-with-the-having-clause/ which allows filtering a dashboard AFTER aggregation for a use case of mine: I have a table insight, which (among others) has a column / metric, which compares this months value with its value 12 months ago. As long as I show all data, this works fine, but when I only want to show this years data (via insight level filters), it stops working. Is it possible to apply insight level filters at the HAVING step?

Hi Thomas, it is not possible to set a "HAVING" filter at the viz/report level. This function is only done on metrics. What exactly is breaking here? Do you need to lock the aggregation with a by clause?

yes, almost all metrics in my table are using BY and are actually often nested (going from monthly to quarterly level, etc.)

Yes, that would be the best option. I'm not sure your full usecase, but you could possibly create a CASE statement for each variant

thanks, I’ll give it a try! I don’t think CASE will help in my case, but the HAVING on individual metric level sounds like a path forward

I can certainly mark this down for product feedback

🎉 New note created.