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

     

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