Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Occupance by datetime

Hi all,   I am trying to create a calculation based on the amount of persons that are in a room based on two datetime field. I have a date table and another table that looks like this: ID In ...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    When you create measures you have to think about filter context and the type of visual you want to use. A good measure works in one scenario. A great measure works in multiple scenarios, including Totals.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi lbendlin ,


I don't need to filter on the ID, I use a slicer for this. I need to filter on de time, please take a look at my picture that I have posted in the previous post. I want to recreate the right table, in the image, with the data that is on the left. 

lbendlin's avatar
lbendlin
Super User
6 years ago

When you create measures you have to think about filter context and the type of visual you want to use. A good measure works in one scenario. A great measure works in multiple scenarios, including Totals.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, I have managed to create the table that I would like to have with a filter. Stupid of me to not think about that.