Skip to Content

Hourly Census Calculation

Aug 14, 2017 at 01:57 PM


avatar image

I am in webi as an end user and looking to design a graph which shows the number of people in our department by hour.

I have each visitor's arrival and departure time as dimensions. I have been trying to design a creative way to count by hour, but am having a troublesome time. Anyone have an idea on how this could be done?


Arrival: 10AM Departure: 1PM

The graph would show 1 person on the hours of 10am, 11am, 12pm

10 |10000 characters needed characters left characters exceeded

can you share with some sample you have any dimension object which give all hours in a day.


see below.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Aug 16, 2017 at 11:46 AM

This is a nice blog you can refer. Though this is a half hour timestamp, you can convert it to hourly base and then use it.

Also could you share some sample data for reference.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I understand what you are referring to and I am able to come up with the hourly stamp, but my difficulty is figuring out total census by hour and account for the person in bewtween their arrival and departure.

Jason Malia Feb 12 at 06:37 PM

Here is what I have and what I am trying to do.

I have arrival and departure times of people. I would like to graph how many are in our building at any given time. Currently, I do not need to run multiple days at once, so that should make it easier on the ones that cross into another day because I plan to only run this one day at a time.

I have created a dimension to convert these times into hour only and then attempted to created dimensions for each hour of the day to count the number of patients, but I have been unlucky with getting that to work.

This graph is what I am shooting for.

Any help would be great.

capture.jpg (36.3 kB)
capture.jpg (38.9 kB)
10 |10000 characters needed characters left characters exceeded