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.

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Not clear on the exact question, can you explain more on the requirement?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Fowmy , thank you for your reply.

 

I would like to calculate the occupancy of a room based on the hour on a daily basis. I have created an image, where I have put the dataset in it that I have and the table that I want to create, with the hope that my question become a little bit more clearly.

 


My goal is to calculate the difference of the IN and OUT numbers, based on the datetime so I can create a line graph with it or an Matrix.

With this Image, is my question a little bit more clearly? Otherwise, please explain what part you don't understand and therefor I can try to explain that part a bit more. Sorry, but my english is not really good.