Exclude today's data?

#1

Is there a way to exclude today’s data other than by doing so in the data cube?

We have a data source that includes work done today but not today’s hours. We want to remove today’s data for some dashboards and not others.

I was thinking of a formula that said “If $date$==Today then 1 else 0” and then excluding the 1’s. However, I haven’t been able to find a function that identifies “today”.

Thanks!

#2

Hi Thomas,
I was wondering if you have tried setting up viewParameters connected to the date fields in those dashboards where you do not need today and set the default value for the viewParameter to Today token. You can then invert the selection to show everything other than today’s data (as in the below screenshot). Does this suit your requirement?

image
image.png1344×741 59.2 KB

1 Like
#3

That seems to do the trick! Thanks!

1 Like