Stack Overflow
Stack Overflow

Questions tagged [looker-studio]

1796 questions
10
votes
1 answer

How to get minutes and seconds in Google Data Studio?

Do anyone know how to convert timestamp data into minutes and seconds in Data Studio? On the screenshot below you can see the possible data types we have in Data Studio, which do not have any seconds and minutes involved.
Indrajeet Gour
  • 4,020
  • 5
  • 43
  • 70
9
votes
1 answer

Invalid date error in custom query in Data Studio

I am trying to prepare a chart using custom query (BigQuery) in Data Studio.However I get invalid date error when using Data Studio Date Parameter @DS_START_DATE and @DS_END_DATE. Here is my query SELECT cat_tbl.*,tag.Category_name FROM …
Prashant Sharma
  • 807
  • 12
  • 17
9
votes
4 answers

Can Google Data Studio do time-series graphs at the hour level?

Every example of a time-series graph I've seen for Google Data Studio has a metric plotted per day. Is there any way to configure the granularity of the time axis (hour, month, etc)? I want to show the count of events per hour throughout one day.…
cmonkey
  • 4,256
  • 1
  • 26
  • 46
9
votes
3 answers

Connect google Datastore to google Data Studio

I want to use google's Data Studio tool to make visualizations for the data I have in the Datastore. But it is not available as a source of data on the interface. How can I approach doing this?
Nicky Feller
  • 3,539
  • 9
  • 37
  • 54
8
votes
0 answers

Dimension and metrics not appearing properly in data studio community connector

Within the getSchema function in my Google Data Studio community connector, I am building up my list of fields and declaring/setting dimensions and metrics…
CB Hoffman
  • 191
  • 6
8
votes
1 answer

Reporting URL of downloads in Data Studio when using Google Analytics 4 automatic enhanced measurement events?

I have setup a new Google Analytics 4 property and have enabled enhanced tracking, which records all downloads automatically. When using Google Data Studio, I can see 'file_download' events (so it's definitely working) and use this data to build my…
Bakala
  • 407
  • 1
  • 6
  • 10
8
votes
1 answer

How to connect Google Data Studio with AWS RDS MySQL behind VPC?

I have a AWS RDS MySQL database hosted inside VPC. I am having problem with connecting Google Data Studio since it's obviously outside the VPC. I have enabled Publicly Accessed option in the RDS but still can't connect, even from MySQL…
Petra Barus
  • 3,815
  • 8
  • 48
  • 87
7
votes
1 answer

Does Google Appscript / UrlFetchApp.fetchAll() function run synchronously?

The problem I'm running into is that I have a number of API requests I want to make, all of which take several seconds to return because the size of the data being returned, and UrlFetchApp.fetchAll(..) is simply returning an array of empty JS…
Stu
  • 119
  • 3
  • 11
7
votes
1 answer

Running Average in Google Data Studio

Monthly Running Average with Daily SUMS on Graph I have data as Follows (SAMPLE): There would be multiple Orders Per Day. Need to Track Number of Orders per Day. In a Graph. (This is Straight for forward with Order Column Defaulting to 1 and then…
Maharshi Raval
  • 168
  • 2
  • 10
7
votes
0 answers

(Google Data Studio) How to Display Percentage Label for Stacked Bar Chart (Workes as Tooltip Though)

You can see below a stacked bar chart I made in Google Data Studio. Let's interpret it and take for example line 1 - Configurator-LCV Configurator. The three colors, blue, orange and yellow, represent three different statuses, In-Flight, TBD and…
Robert Mocanu
  • 97
  • 2
  • 9
7
votes
2 answers

Using the same filter control for two different data sources

I have a Data Studio report containing two graphs. Each graph is associated with a different data source. Each data source has one common field (ex: country) but shouldn't be joined together. Currently I have to set one filter control for each…
Emmanuel Roulleau
  • 71
  • 1
  • 1
  • 2
7
votes
2 answers

Google Data Studio (BigQuery) from 1 to 01

How do I left zero pad numbers in BigQuery, which will produce a string value? For example, the input 8 should produce 08 and so on.
user10208908
7
votes
0 answers

Google data studio connector: "Sorry, we encountered an error and were unable to complete your request."

I'm not sure where to look to get information on what error Google Data Studio is encountering when running a custom Google App Script connector. I created a script, published as a manifest with a new version and copied the ID. In Data Studio I open…
Bart Silverstrim
  • 3,445
  • 6
  • 34
  • 44
7
votes
1 answer

Data Studio Case Function Metric/Dimension Error

I have made use of the Case function in Data Studio to ascertain whether a value is over or under £6,000 and present one of two figures dependent on output. These two figures are calculated fields. First Case statement : (Over or Under) - CASE WHEN…
Hazel Popham
  • 187
  • 1
  • 12
7
votes
2 answers

How can I get the list of all columns in a BigQuery table and dataset

I would like to query all columns and their description in a table/dataset. I'm looking similar metadata tables like __TABLES_SUMMARY__ and __TABLES__. The goal is to build a data dictionary report in Data Studio for the BigQuery tables.
Kiran Kumar
  • 71
  • 1
  • 1
  • 2
1
2
3
…
99 100