Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 tea...
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi All,

 

Hope you guys are doing well.

 

I need help on the below data and formulas how to convert them into powerbi.

 

1. =VLOOKUP(DATEDIF(B2,M2,"d"),SLA,2,1) :- how do I perform this in Powerbi 

 

So below is the scenario

 

So I have a tab which captures all the incidents. I have added a row reference and the formula to capture SLA where the above formulation is done. The SLA is captured from a different Tab named configuration. I want to perform this analysis in PowerBi . Thanks in advance for your help. Below are the screenshots for the same.