Forum Discussion

tiagotas's avatar
tiagotas
Icon for Helper I rankHelper 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
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

I ma happy to help you but you need to provide more Information. I'm sure you know what you need but it is not obvious from the information you have provided. What is the tempo column?  Is it time of day or total hours?  Given there is only 1 record per day, what is the average supposed to be?  Please provide a sample of the result you need. 

tiagotas's avatar
tiagotas
Icon for Helper I rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper I rankHelper I
      9 years ago

      Great suggestion!

      I could have thought of it that way before.

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