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 am trying to create a chart (line) to show the average open time of my tickets.
E.g. I have 4 tickets and today is 3/17.
Creation Date |
11.03.2020 22:16 |
12.03.2020 22:16 |
14.03.2020 22:16 |
15.03.2020 22:16 |
Additional, I have a date table with the with all the dates from the earliest to the latest Creation date, so 3/11 to 3/15.
How can I create a line chart to display the Average Active days for each day? So, on 3/11 the Avg Active days was 1 day, on 3/12 it was 1.5 days (one with 2 days and one with 1 day). On 3/13, it was 2.5 days (one with 3 days, one with 2 days). On 3/14, it was 2.66 days (one with 4 days, one with 3 days and one with 1 day). On 3/15 it was 3 days (one with 5 days, one with 4 days, one with 2 days and one with 1 days).
How could I create and display this?
Many thanks for your help.
Joerg
Tough to say, seems like there is missing data. Maybe Open Tickets? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
Otherwise, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
46 | |
28 | |
23 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
45 | |
16 | |
12 |