Forum Discussion

Hgsilva's avatar
Hgsilva
Frequent Visitor
1 year ago
Solved

Displaying average time passed in line graph

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 dis...
Need Help
  • djurecic's avatar
    djurecic
    1 year ago

    Hi Hgsilva ,

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

    355.15 / 60= 5.92

  • danextian's avatar
    danextian
    1 year ago

    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.

djurecic's avatar
djurecic
Super User
1 year ago

Hi Hgsilva ,

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

355.15 / 60= 5.92

Hgsilva's avatar
Hgsilva
Frequent Visitor
1 year ago

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