Forum Discussion

tiagotas's avatar
tiagotas
Helper I
9 years ago

How to show average hours on graph

I am not able to average the hours shown in the table, nor to show the results of the hours in the chart. How do I create the average hour?     The Production Amount is correct, but the ...
Tips and Tricks
tiagotas's avatar
tiagotas
Helper I
9 years ago

First: I need to display the daily hours of the TEMPO column.

 

Second: And according to the column in the image above, I need to average those hours and present the average on the chart.

 

Sorry if I'm not being clear.

MattAllington's avatar
MattAllington
Community Champion
9 years ago

I am sure you are trying to be clear, but it is not clear to me.  How about you create a chart in Excel using the data you have posted above so it is clear what you want.

  • tiagotas's avatar
    tiagotas
    Helper I
    9 years ago

    Great suggestion!

    I could have thought of it that way before.

    • parry2k's avatar
      parry2k
      Super User
      9 years ago

      Unfortuanltey you cannot use time as measure, to achieve this, convert time to number and then use it. See image below, let me know if you need help on how to do this?

       

      • tiagotas's avatar
        tiagotas
        Helper I
        9 years ago

        Yes! I need to know how!

        I tried to put it as duration but it did not work out.

         

        That way that presented in the image is the form that I need.