Forum Discussion

mdejong's avatar
mdejong
New Member
5 years ago
Solved

Average process time issues

Hi there!   I would like to create a visual of the average process time of multiple issues of an organisation. In the screenshot you can see the fields were available.   So, when the Status colum...
Need Help
  • dkaushik's avatar
    dkaushik
    5 years ago

    Ok. I guess I need to see the file to help you better.
    Nonetheless, the custom column that you created earlier, you can still use it and display the Average using a QnA visual or by right clicking on your column name under the Values section of your visual and selecting "Average" from there.

     

    Thanks,

    Dheeraj

     

mdejong's avatar
mdejong
New Member
5 years ago

Thank you dkaushik! What do you mean with 'TableName' in the calculate rule?

 

Currently i use a custom column 'diff = 1.0 * ([LastModified] - [Created])', then the Q&A visual with 'average diff'. When clicking on the slicer the results are visualized.

dkaushik's avatar
dkaushik
Resolver II
5 years ago

Ahh. The actual name of your table which contains the said fields.

  • mdejong's avatar
    mdejong
    New Member
    5 years ago

    Allright dkaushik, my TableName = 'Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'. So i used:

     

    Average Process Time = Calculate(sum('Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'[LastModified]) - sum('Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)'[Created]))
     
    PowerBI says 'A circular dependency has been detected: Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)[Column], 4a291644-1c12-4a82-bda5-e18c995cabd1, Issues (19-00795 - Nb 46 appartementen De Horn Fase 3)[Column].
    • dkaushik's avatar
      dkaushik
      Resolver II
      5 years ago

      Ok. I guess I need to see the file to help you better.
      Nonetheless, the custom column that you created earlier, you can still use it and display the Average using a QnA visual or by right clicking on your column name under the Values section of your visual and selecting "Average" from there.

       

      Thanks,

      Dheeraj