Skip to Content
0

Hourly Census Calculation

Aug 14, 2017 at 01:57 PM

58

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

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

0
Former Member

see below.

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

2 Answers

Kuldeep Ghosh Aug 16, 2017 at 11:46 AM
0

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.

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

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.

0
avatar image
Former Member Feb 12 at 06:37 PM
0

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)
Share
10 |10000 characters needed characters left characters exceeded