1 Reply Latest reply on Dec 2, 2016 2:08 AM by Norbert Maijoor

    Average of Total ...

    Mohammad Al-Ansari

      Hi,

       

      I have a set of data that provides a total of items observed per minute for an entire month. I want to display a graph showing the average of the hourly total.

       

      How do I do that? Is it possible to group the data (or create a temporary subset of totaling them up to the hour, and then run an average on that?)

       

      The only two options in Tableau now are either a sum per hour for the whole month (so all records for 2 PM for all days), or having x-graphs (x = number of days) whether the average is shown per hour.