Search code examples
looker-studio

How use correct filter in Timeseries DataStudio ? - BiqQuery

I am playing with Datastudio. I have these data from BigQuery:

Row,country,date,confirmed  
1,Afghanistan,2020-03-16,21
2,Afghanistan,2020-03-17,22
3,Afghanistan,2020-03-18,22
...

TimeSeries Chart is showing OK, but optional Filter is showing wrong "Confirmed Cases"... It shows probably sum of all cases by country, and not the last number of cases by last date. Check my screenshots, or u can check the chart oniine here

https://datastudio.google.com/u/0/reporting/28caf33b-346a-4e5b-b726-175b08f23e95/page/cm3NB

Also there is maybe some options how to create extra filter by date, but my data is updating every day, so is there any options how to deal with this in DataStudio in my case ?

Another issue is that when I create new report, everytime I got this error> User Configuration Error -This data source was improperly configured

enter image description here enter image description here

enter image description here

Thanks for any help

Andrew

Solution

  • OK, finally I fixed tha main issue with this enter image description here>