Hi All,
I am wondering if there any way to filter on row_number window function in Looker or using LookML. I am using snowflake database and natively, it has QUALIFY clause to filter.
I am creating row_number with partition and need only row_number = 1. Can someone please guide me if there any equivalent function available in Looker?
Thank you.