cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shariqjoy_New
Helper IV
Helper IV

Created Vs Resolved Monthly tickets

Hi All,

Attached is how my data is shaped and i have also attached an pbix with the same data.

 

In the raw data i have total 136 tickets (100 in aug and 36 in Sep). Out of these 88 were closed in Aug and 26 were closed in Sep, remaining 20 are still in progress.

 

I would like to show ticket Created and Closed tickets in each month for e.g. as per the data for the mont of august i should have 100 as created and 88 tickets as closed. When i am plotting the numbers on the graph i am getting the result as below Created 100 and Closed 90 wherein i should get 88 as closed.

 

Pbix 
Raw Data 

 

 
 
 
 
 
 
 
 
 

Cre vs res.png

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi  @shariqjoy_New ,

 

Your .pbix file and raw data is unreachable,pls modify the access setting and reupload it to us.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

vivran22
Community Champion
Community Champion

Hello @shariqjoy_New 

 

Can't access the file. I guess you need to update the sharing rights.

 

 

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

 

amitchandak
Super User
Super User

@shariqjoy_New , Yet to check Pbix. But refer to this blog that deals with Start/Created, end /Close and Current/open. If this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors