4

Google Charts allows a horizontal time reservation window:

enter image description here

Is it possible to make this type of visualization in a Google Data Studio Dashboard?

Kassy Coan
  • 233
  • 2
  • 9

2 Answers2

1

I don't think you can do it natively. You may be able to achieve the same effect using stacked charts, calculating the difference between start times to act as blank stacks between the reserved times but depending on you data, it might be convoluted and doesn't look great.

Here's an example which maybe someone else can improve on. Data Studio Report is a stacked bar with all "Free" dimensions coloured white and sorted by Start Hour:

Google Sheets Data Google Sheets Data

Data Studio Data Studio

Bobbylank
  • 1,906
  • 7
  • 15
  • I'm curious how you were able to create this visualization. Made a similar post: https://stackoverflow.com/questions/72915102/how-to-merge-different-event-types-in-google-data-studio-stacked-bar-chart-vis – Ricardo Francois Jul 25 '22 at 05:33
0

You can create a timeline by selecting Area Chart with a string type field. Just select your time field as Dimension and the string field as Breakdown Dimension and Metric. Also set Missing Data to "Line Breaks". Your time field must have a frequency lesser than a minute.

enter image description here

Abutreca
  • 159
  • 1
  • 13
  • I'm curious how you were able to create this visualization. Made a similar post: https://stackoverflow.com/questions/72915102/how-to-merge-different-event-types-in-google-data-studio-stacked-bar-chart-vis – Ricardo Francois Jul 25 '22 at 05:33
  • All I can give you is that explanation, I no longer work with data studio. – Abutreca Jul 27 '22 at 10:08