Just to get a clear picture, When I select 3 hours, I will get a range of 3 hours (e.g. 9AM, 10AM, 11AM) or Just the total for 3 hours or every 3 hours? Your statement "it will show the usage of the whole day for any 3 hour period" is what I need to understand.
Can you do an image of how it would look like. Or create a sample workbook that represents your data and how you want it to appear.
Thank you for your response. So if you select 3 hours, you will get the total usage in all 3 hour periods of the day. Whether it is 11am-2pm or 3pm_6pm. Similarly if you select 2 hours, it will show the usage across all 2hr periods of the day.
E.g it will show the total if x was used between 2-4 and y was used between 6-8. But don't need to see the individual periods.
Does that help?
Thanks again Peter
You might want to use a bin for this purpose or create a calculated field that calculates a "range".
I used Superstore for this.
Instead of hours, I used Days. I created a calculated field called Days = DAY(Order date)
Since Days would be in Measures, I can create a bin from it.
Within Bins, I created an option for it to be controlled by a parameter that will help determine the size (1 Day, 2 Days, 3 Days, 4 Days)
I dragged the Bins to Column and Sales (this can represent consumption) to rows.
Please see attached file.
Hope this helps.
Please mark Answered if this answers your questions and if it helped you
By Hour.twbx 1.1 MB
Thanks Peter. This sounds great. I am just on the way out to a meeting so will check it out later
Kindly mark Answered if it answers your question and if my solution helped.