Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
SR | Opened date | Closed Date |
T1 | 1-Jan-16 | |
T2 | 1-Jan-16 | 1-Feb-16 |
T3 | 2-Feb-16 | 4-Feb-16 |
T4 | 3-Mar-16 | |
T5 | 4-Apr-16 | |
T6 | 4-Apr-16 | |
T7 | 4-Apr-16 | 01-mai-2016 |
T8 | 1-May-16 | 8-May-16 |
Let me know if you need any other clarification.
Regards.
Solved! Go to 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.
Need Clarification on this
"Which Power bi model I need to report a graph"
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.
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 Active | Opened | Closed | |
Jan | 2 | 2 | 0 |
Feb | 3 | 1 | 2 |
Mar | 2 | 1 | 0 |
Apr | 5 | 3 | 0 |
May | 6 | 1 | 2 |
Sample Data:
SR | Opened date | Closed Date |
T1 | 1-Jan-16 | |
T2 | 1-Jan-16 | 1-Feb-16 |
T3 | 2-Feb-16 | 4-Feb-16 |
T4 | 3-Mar-16 | |
T5 | 4-Apr-16 | |
T6 | 4-Apr-16 | |
T7 | 4-Apr-16 | 1-May-16 |
T8 | 1-May-16 | 8-May-16 |
Thanks in Advance,
Kiran.
This looks perfect.
Thanks very much for this
regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |