This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Using convert_tz: no on my filters didn’t work (or in any combination on
the dimension, filter, or both), though I do have a bit of a unique date
situation. We have a field meant to be a date stored as a datetime, and
because it’s at midnight, things...
Seconded. I’d love to help put something together to show off each
tool’s benefits in one place. It’s pretty clear that there are two
needed use cases - comparing analogous/matching date periods in the past
and comparing potentially “mismatched” date...
There was also another issue that cropped up with date formatting when I
tried a different kind of date range. Both issues have been resolved (at
least enough to keep the report I’m working on from breaking!).
I’ve managed to find an issue already… lol. Working on it now. The
Anchor Date dimension has disappeared. I think I know why, and my fix I
thought would work is making it worse.
I wish I had time to put together some examples for you, but I took a
quick look at Snowflake syntax vs BigQuery, and the translation should
be possible. This is the reference for all BigQuery data functions. I
know it’s extremely icky to parse apart...