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
can you share with some sample data.do you have any dimension object which give all hours in a day.
see below.
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.
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.
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.