Displaying average time passed in line graph

[Hgsilva]

Running into an issue where currently showing the amount of minutes it takes to complete a task. Need to convert the avg minutes want to display as hours and minutes instead. Example 355.15 would display as 5.92 instead. I tried converting column into hh:nn but that doesnt allow me to show as average only as count in graph. 

[djurecicK2 · Accepted solution]

Hi @Hgsilva ,

 You could create a custom column or a measure that divides the value by 60. 

355.15 / 60= 5.92

[danextian · Accepted solution]

Hi @Hgsilva 

Divide your current measure by 60 to get the hours equivalent.

Note: if you intend to show the Y-axis category as time format, that isn't possible. It has to be numeric.

[Hgsilva]

Thank you! Super simple, I did not realize couldnt make it as time format. Thank you for explanation.

[djurecicK2 · Accepted solution]

Hi @Hgsilva ,

 You could create a custom column or a measure that divides the value by 60. 

355.15 / 60= 5.92

[Hgsilva]

This worked perfectly for my situation. Thank you very much!