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.

     

     

aj1973's avatar
aj1973
Community Champion
6 years ago

Hi Anonymous 

Your Management took the right decision to move to Power BI. it sounds like you have many calculations and modeling to do therefore I agree with ryan_mayu and parry2k on there request.

 

Regards

parry2k's avatar
parry2k
Super User
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.