Skip to Content
avatar image
Former Member

Hourly Census Calculation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Add comment
    10|10000 characters needed 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.

  • avatar image
    Former Member
    Feb 12, 2018 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.

    Add comment
    10|10000 characters needed characters exceeded