Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all! I need help in plotting our ticket's average resolution time to graph. I am grateful for any ideas on how to execute it properly. First of all, I already have the prerequisites such as calendar and time table. What I need guidance for is to properly visualize it, or step-by-step queries needed inside the graph.
This is what I want to achieve:
And here's a glimpse of my current dataset:
The average resolution time column is already in minutes and I have the week columns indicating the particular week number in a month.
Let me know if you have any ideas on how to execute it. It will mean so much. Thank you!
Solved! Go to Solution.
Hi @jstacruz ,
Is that your excepted result?
For more details, please check the pbix as attached.
Hi @jstacruz ,
Is that your excepted result?
For more details, please check the pbix as attached.