Filip Charikov
11/29/2023, 3:09 PMprevious period
comparisons don't work within headline charts when an additional filter is present (like excluding days by by day of week)?
For example - I set a static date (single day = 11/24) on my headline and enable compare with previous period. This works (pic 1).
When I do the same but with an additional filter that excludes Sun & Sat it stops working. Why does it stop working, considering 11/24 is a Friday, thus previous period is Thursday, which doesn't touch the added filter?Michael Ullock
11/29/2023, 6:11 PMFilip Charikov
11/29/2023, 6:19 PMcomparison
completely in the chart configuration - still getting the error.Michael Ullock
11/29/2023, 6:23 PMMartin Cermak
12/01/2023, 2:06 PMdate
datatype what BigQuery does not support. As a quick fix, you can convert issue_date
to DATETIME
.
Still it is unclear to me why the granularity of date is changed to minutes. Is it possible that you are somewhere working with minutes?Filip Charikov
12/01/2023, 2:07 PMFilip Charikov
12/01/2023, 2:07 PMMartin Cermak
12/01/2023, 2:09 PMgooddata_main_data0.issue_date
but yes, If you put DATETIME everywhere, you should be safe.Filip Charikov
12/04/2023, 7:06 PM"title": "Bad Request",
"status": 400,
"detail": "A result cache error has occurred during the calculation of the result",
"resultId": "2c4c4dda816f1e26e4cca5ca3966d530b0cb256b",
"reason": "Enumerating datetime attributes='[attribute/reviewed_date.day/zentist-main]' is not allowed",
"traceId": "585996d258c9570accd5977eb3c1a5ee"
Martin Cermak
12/05/2023, 10:33 AMFilip Charikov
12/05/2023, 10:38 AMMartin Cermak
12/05/2023, 10:42 AM