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.