8 Replies Latest reply on Jan 4, 2019 1:08 AM by Selvi velraj

    Selecting a range of hours

    David Goldstone



      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