Hi all,
I think it’s a simple question but I do not understand the logic. Please find below the example.
Main view :
Dimension | measure | measure |
Account | min start time | max end time |
User 1 | 01/01/2021 01:00:00 | 01/01/2021 02:00:00 |
So in my main view I have 2 measures for min and max. I would like to calculate a duration so I created a DT with:
Dimension | Dimension | Dimension |
Account | min start time | max end time |
User 1 | 01/01/2021 01:00:00 | 01/01/2021 02:00:00 |
On this DT a create a new dimension with type : duration and Account is the PK.
Now when I’m on my model, and when I call the 3 dimensions of my DT (min, max and duration) they are empty.
Thanks a lot, it drives me crazy ^^
Solved! Go to Solution.
Issue solved.
In my model I added an always_filter condition. So my DT was also using this condition.
But when I’m on the explore and if I change the condition in the filter it’s not updated on the DT which are still using the condition defined in the LookML.