Hey folks. I'm having a niche problem
Hey folks. I'm having a niche problem with thoughtspot's query engine.
Basically: we've moved data sources from Google BigQuery to MySQL. Everything is good except for "Weekly" aggregations.
It looks like the MySQL dialect for "weekly" is
while the BQ one is
the mysql one isn't accurate for aggregations, because it keeps the time component, which makes thoughtspot think that same days have multiple values, which results in the error:
Has anyone else encountered this?
Basically: we've moved data sources from Google BigQuery to MySQL. Everything is good except for "Weekly" aggregations.
It looks like the MySQL dialect for "weekly" is
ADDDATE(ta_1.created_at, -WEEKDAY(ta_1.created_at)) AS ca_1, while the BQ one is
DATETIME_TRUNC(CAST(. as DATETIME), ISOWEEK) AS , the mysql one isn't accurate for aggregations, because it keeps the time component, which makes thoughtspot think that same days have multiple values, which results in the error:
Your search needs to have unique y-axis values for each series of data shown on the x-axis.
Has anyone else encountered this?
