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

[Ka Sz]

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