Forum Discussion

gautampruthi's avatar
gautampruthi
Icon for Helper II rankHelper II
1 year ago
Solved

Auto attendant and Call queue historical reports - Version V3.2.0 - Error

Hi, i want to analyse the teams call and queue data and downloaded Teams Auto Attendant & Call Queue Historical Reports pbit but i when i am opening the report i am getting two errors which are  ...
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi gautampruthi ,

    The problem is in one of the steps in table [fCallQueueAnalytics], ther error is in column text, there's was written AvgCallCuration instead of Duration, so you need to go to power query, and select the table fCallQueueAnalytics, 

     

    now go to Applied Steps - Renamed Columns

     

    Replace D with C to be AvgCallDuration.

     

    At this point the problem wil be resolved now you can close and apply and your report will load with no errors as you can see bellow:

     

    Let me know if this help you.

    Please give a Kudo and if this help you, consider to accept as solution.

     

    Thank you