Hey,
when I select ‘include end date’ in a filter it does include only the first hour of the selected end day when time granularity ‘Hourly’ is defined. Does anybody know a fix for this, to include the whole end day?
Hi @fabian.altendorfer ,
have you checked the filter hour part?
If you see in the screenshot, if you want to include the end date and you have a Hour granularity, just use as Time Granularity “Hour” in the filter, and also set the End Date with hour 11:00 PM (or 23:00).
This should do the trick! 
if you look at the filtered table in the screenshot, you’ll see that in this way all the hours of the last day are included.
Andrea
Thanks, but I have a rolling end date 
Can you show me the how your filter is configured? So I can replicate the same thing!
Thank you!
1 Like
Got it!
In this case, I assume you have the valuetimestamp filed aggregated per hours in your visual, right?
If that is so, you don’t need to use Time Granularity Hour also in the filter, just use time granularity Day in the filter and that should work!
Andrea
1 Like
Thanks a lot for pointing this out. Unfortunately it doesn’t solve our problem because the user should be able to select specific hours in the filter too. So we would like to have an hourly rolling date with the end date fully included in the preselection.
I did, it selects the first hour of the end day, but not all hours of the end day
This seems strange.
Have a look to this example and let’s try to understand it better.
I’ve these fake raw data:
You see that we have data up to tomorrow18th of July. Also I’ve created data for today at midnight, so we have all the combinations.
If I select Today as Rolling, we see data also for Today, but just for the first hour of Today.
If I select End of This Day as Rolling, we see all the data for Today, for all hours.
As you see in both cases I’ve selected Granularity Hour.
And this is how the Visual is configured:
So for OrderDate is still Hour as aggregation.
Can you check these configurations also in your account?
I’m trying to replicate exactly the same thing you are doing, so let me know!
1 Like
This is it! Thank you, I didn’t know I can set “End of this day” and still define it as a rolling date.
Many thanks for detailled help!
1 Like
You’re welcome @fabian.altendorfer !
Have a nice one
1 Like