Dimensions from DT empty

[Michaël_S]

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 ^^

[Michaël_S · Accepted 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.