Filter how many open tickets were opened for certain user each date?

Ka Sz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 23, 2024

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 

0 answers

Suggest an answer

Log in or Sign up to answer