Forum Discussion
ServiceNow Ticket Analysis
I wanted some help around PowerBI. So there are a bunch of excel sheets which I export on a weekly basis from ServiceNow which are basically Tickets (Tasks, Incidents, Problems) which the Support team works on.
I do the multiple calculations on those excel sheet to calculate say SLA days say to calculate the week which falls into (=INT((6+DAY(J2+1-WEEKDAY(J2-1)))/7)) etc and also create Pivots based on that data (Not PowerPivot).
My management has asked that rather than create these reports in excel we use PowerBi. But I'm finding it very difficult to do some of the calculations I did in excel in PowerBi. Can anyone please help here?
There are multiple reports which I need help with.
Looking forward to help on the same.
Anonymous I don't mind doing goto meeting sessions but a bit busy for a few days, I would still recommend to post it here so that multiple community members can chime in provide the solution.
If you still want to do a goto meeting session, it is something I can do next week or so.
10 Replies
Anonymous
you need to provide detailed info. plesae share the sample data and the expected output.
Anonymous you can surely do a similar calculation in Power BI but it is not straight forward translation. You need to share the sample data and expected output and then someone from the community will provide your relevant DAX formula for that.
A lot of stuff in Power BI goes in data modelling which leads to effective DAX measures to get the result, so there are few moving components.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
I can surely do that.
But I work on multiple sheets to will have to put in one at a time so that I can tell you what is to be done and what needs to be the outputs.
1. Open Vs Resolved tickets (Incidents, Tasks, etc) Created, Resolved and In-Progress
This is just one there almost 6-7 of them that have a different analysis.
I prefer having a go to meeting session to go through the same. Let me know if that works.
Anonymous I don't mind doing goto meeting sessions but a bit busy for a few days, I would still recommend to post it here so that multiple community members can chime in provide the solution.
If you still want to do a goto meeting session, it is something I can do next week or so.
parry2k Early next week works for me. Thanks, Parry, really appreciate your help on this.
Though as you , ryan_mayu and aj1973 mentioned I can post the sheets one by one so that community can benefit as a whole.
parry2k Please let me know a suitable time next week. I will send out a meeting invite according to your availability.
Hello,
I’d like to propose and alternative solution for you for the ServiceNow Ticket Analysis, you might want to try out our app - Power BI Connector for ServiceNow:
- https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
- https://www.alphaservesp.com/products/servicenow/power-bi/
We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at [email protected] if you need any assistance.
Thank you.
Regards,
Anton
===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
