7 Replies Latest reply on Aug 9, 2017 6:59 AM by David Goldstone

    Selecting a range of hours

    David Goldstone

      Hi

       

      I have a dataset that is made up of of hours of the day 0hr -24hr. Days of the month, 1 June 2017 - 30 June 2017. Names of people and usage of a service in any given hour on any day,. I have filters that show the hour. So you can see that x many used y at 7am across different days. The requirement I need is to show how much was used during any 2 hr, 3hr, 4 hr, 5hr, 6hr, 7hr window and so on. These windows can be across any time of the day. So if the user selects a 3hr window, it will show the usage of the whole day for any 3 hour period. But I am not sure how to do this.

       

      An ideas?

       

      I cant show a workbook as its confidential info

       

      Thanks