Hi all,
I am relatively new to Looker. i’m able to work with explores, create Looks and dashboard based on basic (custom) filterring. I have little knowledge of LookML and SQL.
I’m trying to create a filter on a dimension which shows the chronological order of transactions. So within this dimension 1 means first transaction, 2 means second transaction etc. The filter must select the latest transaction of the user. I tried the following custom filter: ${sales number} = max(${sales number}), but that doesn’t work.