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”.