CODEWITHSUNDEEP
looker-studio
saikumar
saikumar

Reputation: 179

I am trying to plot following data in Google Data Studio, but I am unable to

Link for the data to be plotted in excel format

You can access the data from the above link. Basically I am able to plot the above data in excel. But I want to plot them in Data studio. And when I tried I am able to get only this

enter image description here

As you can see, it's nowhere called data visualization and I am suspecting the highlighted average metric of temperature. I want it to be "auto". But there is no option for that

I want something similar to this for each minute

enter image description here

Upvotes: 0

Views: 560

Answers (1)

Bobbylank
Bobbylank

Reputation: 1946

Make sure your ts filed is formatted as "Date Hour minute" and in the style section you've set Missing Data to "Linear interpolation" which essentially joins the dots where you have no data for that minute.

enter image description here

Upvotes: 1

Related Questions