How to use HAVING filter in Information Map Studio

[Clash]

Hi!

I have a very simple information map containing 4 tables, relations are defined. 

How do I create a filter for one of my tables, based on HAVING where clause? What I want is a query that only returns the rows with highest number for my column, example "having my_key_sk EQ max(my_key_sk)"

Thanks for any help pointing me in the right directions,

Regards,

Claes Wedberg

[LinusH · Accepted solution]

Aggregate filters can be a performance killer, so I would suggest create a new table using this having clause.

If that's not appropriate:

If you are not able to create it in the UI, you could probably create a view on top of the table, and use that instead.

[Clash]

Hi Linus!

Shure thing, I created a view and it works great!

Thanks a lot, 

Best regards

/Claes