Solved

Dimensions from DT empty

  • 20 April 2021
  • 1 reply
  • 42 views

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

icon

Best answer by Michaël.S 21 April 2021, 16:29

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.

 

View original

1 reply

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.

 

Reply