Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I'd like to be able to see a chart that counts the number of active employees by time of day, given the employee ID, punch in time, and punch out time (see screenshot below). I have data for multiple weeks, so what I would like to display is the average number of employees working at a given time for each day.
Thanks in advance for the help!
Solved! Go to Solution.
ahh, sorry about that. As I said I had a few problems with the files and I was trying a few different ways to sort it out. Try this.
This is a non trivial problem but can be solved by writing measures that show running totals. It becomes a lot more complex if people can clock out after midnight. I suggest you will need to provide some sample datahat covers all scenarios for anyone to help you.
the sample data doesn't look valid to me. Note below that employee ID 1 is checking in and out multiple times on the same day.
Hi Matt,
If you switch Employee ID from "Count" to "Don't Summarize", you should see the correct IDs. They are 5-digit numbers such as 10085.
Thanks!
Ahh, sorry. That is a bug in Desktop - when you add an ID, it counts rather than shows the number. Not knowing the data I didn't notice it occur
I have had quite a few issues with the test file. For what ever reason I cannot see the data in the data view. There seem to be dates that are blank, but I am guessing. Also the date formats are playing up between US and AU formats. Regardless, this may be close to what you are after.
The calendar table I created is at the minute level - it only needs to be at the granularity you need for reporting.
It seems as though your file is incompatible with my version of PowerBI, although I have the most updated version that is available.
ahh, sorry about that. As I said I had a few problems with the files and I was trying a few different ways to sort it out. Try this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |