Hello,
I need help with displaying information about user assignments.
Does anyone have idea how to tell how many open tickets user had opened each day?
Final data for me would answer:
"In April, user X had maximum of 3 tickets opened at one time, minimum of 1 open per day" all at the same time.
So my time unit is day. And for each day, i would like to know the number of open tickets assigned to user X.
ticket A - opened from 1st to 3rd April
ticket B - opened from 1st to 4th April
ticket C opened from 3th to 5th April
1st April - 2 open tickets (A,B)
2nd April - 2 open tickets (A,B)
3rd April - 3 open tickets (A,B,C)
4th April - 2 open tickets (B,C)
5th April - 1 open ticket(C)
so between 1-5 April, user X had max of 3 open tickets, min of 1.
I have also access to backend Jira database in my organization, can query in SQL via Databricks, or use PowerQuery or DAX in PowerBI.
But i don't have an idea of the approach...
Did someone struggled with similar issue?
Thank you so much,
Best regards
Kasia
