Looker Data Studio Time Series Graphs in 6 minutes

In this video we look at creating professional Google Data Studio Time Series Charts

The Time Series Chart is used to track the movement of metrics over time. Google Data Studio Time Series Charts allows you to track multiple metrics on the same graph, compare to previous periods and easily switch to the different time horizons using the drilldown functionality .

In this Video on Google Data Studio Time Series Charts you will learn:

1. How to Style a Time Series Chart
2. The different types of time series charts google data studio offers and how to create them
3. How to add drilldowns, additional metrics and comparison functionality to a time series chart.

#DataStudio
#GoogleAnalytics

[oliviahowing]

Do you know how to configure a chart for dynamic L12M? So not for a calendar year of so but for example July 2023 - July 2024, and compare that to the previsous year

[jonassteinberg]

"...because [tables] are the most powerful thing in Looker." Wow -- what an interesting take! Why would a table be the most powerful widget and not something graphical?

[WarrenFabricius]

I am struggling with creating a Time Series graph that is referencing two separate tables. In table one I have "total leads" and in table 2 I have "total opportunities" These are created automatically by a workflow. I want to create a time series graph that overlays opps over leads, broken down by day. How can I achieve this? I've tried using blended data but the date range dimension disappears in Setup, which seems to be the key for providing the range breakdown.

[AnneliesFull]

Hi! Thanks for the video! I want to create a column bar chart that has {total_articles} vs {attention_minutes_average} as statistics. The {attention_minutes_average} is in seconds and has the "duration (sec)" type. When I add it, it will display "duration10", "duration20" next to the bar chart instead of the time written out. What can I do? The variable works correctly in a table view. I couldn't find much about this issue. Hopefully you can help me!

[tmotten]

Great vid. How can you limit the dates in the x axis that the graph shows? Even if I have only date for 3 months of a year compared to previous year. And the sheet date filter is only to show the last month. The graph still shows the full 12 months of the graph's timeline.

[joshcanada]

How would this work if I want to make a one time series chart using 3 different columns that are in the same google sheet (inital target date, ecalibrated target date, actual date)?

[ezequielnudelman]

Great video, thank you!
I created a time series for the last 2 weeks and I would like it to show the day of the week that it was instead of the date. How can I do that?

[rusthamyacoob]

hello great work. can you please help me to create a time series chart with data from different tabs in google sheet? i mean when each dates data are in different sheets?

[Altheana]

I want to compare data for more than 2 weeks, i.e. Week 1 vs. Week 2 vs. Week 3, etc... How do I do that?