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 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. 

 

 

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.

4 Replies

  • djurecic's avatar
    djurecic
    Icon for Super User rankSuper 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!

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    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.

    • Hgsilva's avatar
      Hgsilva
      Frequent Visitor
      1 year ago

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