Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think this might be helpful in your case:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates
Thanks, I will take a look and let you know the outcome
try like this hope will helps you
=count(interval(InDateTime-OutDateTime,'MM'))