on 08-14-2017 2:57 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.