Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Cyberfred95
Frequent Visitor

Report number of opened and closed tickets per month

HI

I am strugling with a very common situation and was not able to found answer in the forum.

I have a table that represents a list of tickets opened in a service center. For each row we have the tichet reference, the opened date and the closed date if the ticket is solved.

Which Power bi model I need to report a graph with opened, closed and still opened tickets ( different between opened and closed) per month ?

 

Thanks for your help

regards

 

here is a minimal simple sheet of inial data

 

SROpened dateClosed Date
T11-Jan-16 
T21-Jan-161-Feb-16
T32-Feb-164-Feb-16
T43-Mar-16 
T54-Apr-16 
T64-Apr-16 
T74-Apr-1601-mai-2016
T81-May-168-May-16

 

Let me know if you need any other clarification.

Regards. 

1 ACCEPTED SOLUTION

Hi @Cyberfred95

 

Check the file at here:

 

https://drive.google.com/file/d/0B26iWnIZh6PSaWdBTXVKcVZIZlU/view?usp=sharing

 

I have created a conditional column for finding still opened and closed tickets and for created tickets, I created measure 

 

Created:=COUNTA(data[SR])

 

 To visualiza monthly data, I have created a data table and imported into powerbi, Created a relationship with opened date column.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

6 REPLIES 6
BhaveshPatel
Community Champion
Community Champion

Need Clarification on this

"Which Power bi model I need to report a graph"

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

HI

Sorry for My English. I just wanted to says : How do I need to do with Power Bi desktop to report a chart where I will have on the same chart the number of  tickets created, solved and still opened per month.

Thanks for your help

regards

 

Hi @Cyberfred95

 

Check the file at here:

 

https://drive.google.com/file/d/0B26iWnIZh6PSaWdBTXVKcVZIZlU/view?usp=sharing

 

I have created a conditional column for finding still opened and closed tickets and for created tickets, I created measure 

 

Created:=COUNTA(data[SR])

 

 To visualiza monthly data, I have created a data table and imported into powerbi, Created a relationship with opened date column.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Anonymous
Not applicable

Hi @Bhavesh

 

Please share the pbix file

Hi Bhavesh,

 

For the same sample data, is there a way to get this output. I am looking for Total Active tickets during that month.

 Total ActiveOpenedClosed
Jan220
Feb312
Mar210
Apr530
May612

Sample Data:

SROpened dateClosed Date
T11-Jan-16 
T21-Jan-161-Feb-16
T32-Feb-164-Feb-16
T43-Mar-16 
T54-Apr-16 
T64-Apr-16 
T74-Apr-161-May-16
T81-May-168-May-16

 

Thanks in Advance,

Kiran.

This looks perfect.

Thanks very much for this

regards

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!