cancel
Showing results for 
Search instead for 
Did you mean: 

Hourly Census Calculation

Former Member
0 Kudos

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?

Ex.

Arrival: 10AM Departure: 1PM

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

amitrathi239
Active Contributor
0 Kudos

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

Former Member
0 Kudos

see below.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

former_member198519
Active Contributor
0 Kudos

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.

https://blogs.sap.com/2016/06/14/halfhourly-timestamps-in-a-chart/

Also could you share some sample data for reference.

Former Member
0 Kudos

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.