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 effectively have phone call records that have a start and end time on them. Is there anyway to calculate how many calls were active at the same time along a line chart? (If I select the start or end time as the axis and count the ID of the call record, unless more than one record has the exact same timestamp its a straight line.)
Thanks
Lee
Hi,
What do you mean by "At the same time"? Do you mean how many people were talking at 13:42:15? Share some data and also the expected result.
Hi Anish,
Thats exactly what I'm after thank you. I've put a linke for some sample data.
There is a start time, end time and to and from telephone number.
https://www.dropbox.com/s/me91dx6kypplor0/calls.csv?dl=0
Thanks,
Lee
Hi,
I will not be able to help you with this. Sorry.
Hello Lee,
Couldn't think of a direct way to get the count at each instance, but if the number of records is limited try using 'as Timeline' visual to get the following representation from where manually the times of interest can be explored:
Hi,
Thanks for the reply, I'm looking at 1000s of records, so might be a little tricky!
Thanks again.
Lee
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 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |