Hey there!
I have a question regarding filtering by measure in the explore section (applying an HAVING cause).
What I’d like to do is apply that filter to all of the pivoted values. Meaning that if one of the values doesn’t satisfy the result, then the row would be removed.
This is useful when you ask stuff like “Which users ordered at least 10 times per month in the last 3 months ?”.
Dimensions:
User
Pivot:
Month
Filters:
Month = Last 3 months
Orders >= 10
Typical result I get is:
| User | January | February | March |
|---|---|---|---|
| A | 12 | NULL | NULL |
| B | 12 | 14 | 11 |
| C | 12 | 16 | NULL |
What I want is:
| User | January | February | March |
|---|---|---|---|
| B | 12 | 14 | 11 |
Meaning that if a user doesn’t order 10 times per month in the past 3 months, I don’t want it to appear in the results.
I was wondering if there was a way of doing this (via the query, hiding stuff via calculations or in the visualization …), without having to create a dedicated derived table.
I’m still new at this, if the right way of doing this is creating a derived table then … it’s fine! I just tend to avoid creating too many derived tables to keep the models as compact and maintainable as possible.
