The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
I am not an power BI expert, i am handling support and i want to create a daily backlog report for my support tickets (my source is JIRA), can someone help me for this.
I have 2 tables, one Issue table and second Issue History table where i can see the status changes complete history, so far what i done is following
your assistance is much appreciated.
@amitchandak
Thanks for your assitance, the formula what you briefed is bit complex for me but still one thing i would like to highlight with my source is, if i compare my ticket history table to your employee table the major difference would be there is no unique value in my table, the Ticket ID and Ticket No will repeat several time.
If its a just a straight forward Created to Resolved this would work but what i talking is as follows
In the above mock table, for a single ticket over a period of 9 day several transaction happened, if its a single ticket then my date column is the unique key here, but my history table is for everything so there is no unique key at all in my table. The red highlighted ones on 12th and 14th are just mock entries i post to explain there wont be any transaction at all, and finally on 18th is when ticket got closed from that day onward there wont be any transactions.
What i want is to present a line chart indicating backlog bucket for me and customer day wise. In this scenario i only two options here
1. Somehow try to calculate the transistion duration as a measure so that when i include that in chart it will project correct numbers.
2. Create a data table using my history table with the following logic
Now my problem is i know the direction i am heading and the mode i can take but i dont have the tool with me, i dont know the formula for either of this approach. Pls also highlight if my understanding is correct on these 2 approach or if there is a different approach i can try beyond these 2.
@MK_BI , There should be 2 dates created and resolved. If yes, then you can follow HR approach of active employee
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Sorry instead of reply to your comment i reply to the main post can you check that pls.
User | Count |
---|---|
143 | |
121 | |
110 | |
53 | |
46 |
User | Count |
---|---|
220 | |
101 | |
95 | |
94 | |
88 |