I'm trying to build an automation chart in Data Studio from a scheduled query that I wrote in BigQuery.
When I try to export the table to data I get the next error when I change the column:
Here my query: The query
Someone has this problem before? Thanks
It looks like field count has data type as DATE or DATETIME, and you are including it as a measure, then you need to apply some measures on data on this field.
Once some transformation logic is applied it will work for you.
As by default these logics are automatically applied on measure filed, but looks like it's not.
