One of the first things I do when I use new BI tool is to come up with sets of dashboards that compare the following:
Today vs yeterday up to the same hour+minute
Today vs same day of previous week
This week vs previous week
etc.
So far I can’t find a good way of specifying that kind of filter. Even taking a day of the week index needs workarounds and using multiple functions. I tried using Custom Filter but also can’t find anything that would achieve what I need. There’s no simple day, month, hour function that would just extract the integer from current date.
trunc_hours doesn’t seem to work - is it, in the background, still a different hour if it’s a different day?