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
ADDDATE(ta_1.created_at, -WEEKDAY(ta_1.created_at)) AS ca_1,
while the BQ one is
DATETIME_TRUNC(CAST(ta_1.start_date as DATETIME), ISOWEEK) AS ca_1,
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?
2 Replies