Occupancy

[Simon_J]

Hi All

I have a client that needs to show occupancy levels at different sites on a dashboard. This would be occupancy over time in different intervals.

For example, if site 101 has 100 spaces, the client gets an InDateTime and an OutDateTime for each visit of a customer and would like to see how many spaces are occupied in those intervals.

Does anyone know of the best way to do this?

I have tried calculating 10 minute intervals and using something simple like count(InDateTime) - Count(OutDateTime) but this does not work.

Many Thanks,

Simon

[swuehl]

I think this might be helpful in your case:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

[Simon_J]

Thanks, I will take a look and let you know the outcome

[#4]

try like this hope will helps you

=count(interval(InDateTime-OutDateTime,'MM'))