looker-studio Questions

2

I'm using Postgres connector from a cloud based server to Google Data Studio, to pull in all my Zoho CRM data so that I can build some dashboards in Google Data Studio. Problem is, for some odd r...
Blanchette asked 29/5, 2019 at 11:47

5

Solved

I'm having troubles to connect an existing heroku database to Google Datastudio. I'm trying to add the connection and I get the following: Access denied, please check your username and password....
Ming asked 22/2, 2017 at 9:4

2

Solved

I'm trying to connect a Heroku Postgres database to Google Looker Studio (former Data Studio). I found an old stack overflow question that suggests I need to use SSL and for that I need to enable c...
Krystinakrystle asked 21/4, 2023 at 18:59

5

I have a dashboard built on Data Studio. The default filter control to search results is case sensitive; is there a way make the search case insensitive? For example, I would like to search for &qu...
Aldrich asked 15/7, 2020 at 20:53

8

A Google Sheets data set is connected to Google Data Studio then explored in chart using data range. For 1 or 2 days, data is visible in chart and we can also set range that period of time but afte...
Vallejo asked 21/1, 2020 at 12:44

3

Any idea how to call bigquery stored proc from Google data studio? I've a recursive query requirement which I've accomplished using Bigquery procedure. However need to pass parameters to this proce...
Purapurblind asked 19/3, 2021 at 13:3

1

I'm trying to connect MongoDB to Google Data Studio. As there isn't an official connector, I tried to connect MongoDB to Google Spreadsheet with the function importdata(url), but the rows that I ca...
Godin asked 22/3, 2018 at 9:12

4

Solved

I know similar questions were asked before, but none of the answers that I found (example here, another example) helped me. What I am trying to do: Create a report in Google Data Studio that sh...
Verbality asked 27/3, 2020 at 3:3

1

Does anyone know how to invoke a Big Query Stored Procedure from GDS? When I try the following, I get an error: CALL mydataset.get_member_value('Hi'); Sorry, we encountered an error and were unable...
Alan asked 3/10, 2022 at 17:13

2

We need help understanding how to generate a specific URL with parameters to direct users to our report. We've been through the Google data studio documentation about direct links here. We're still...
Rooted asked 8/5, 2020 at 13:48

1

Solved

I have a spreadsheet that looks like this: Country Choice Brazil Rock Brazil Rock Brazil Paper Peru Scissors Peru Scissors Peru Rock Cuba Paper In the Data Studio report, ho...
Levulose asked 9/6, 2022 at 18:43

1

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...
Uniocular asked 3/10, 2019 at 15:36

2

Solved

Is there any way to embed a private report (i.e. Link-Sharing set to OFF) in a site where the user does not have to be signed in to a Google account which has view permissions on the report? I unde...
Nikolas asked 2/10, 2018 at 15:56

2

I have a requirement to have date range filter which can be used for two different date columns of the data source(One at a time either through radio button to choose at which column date range sho...
Clinkstone asked 27/2, 2018 at 12:6

1

I've been developing an apps script project for my company that tracks our time/expenses. I've structured the project like so: The company has a paid Gsuite account that owns all the spreadsheets ...
Contagium asked 7/4, 2021 at 15:41

2

I upgraded to Google Analytics 4 and struggle to display event parameters in Google Data Studio. I created an event parameter in Google Tag Manager to track the ID of a link. Now I want to display ...

4

Solved

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 sho...
Zehe asked 5/10, 2017 at 18:12

3

I am trying to test a connector I am building. I have created the manifest file (appsscript.json) and am trying to add this by Deployment ID to DataStudio. I keep getting an error that states: T...
Seanseana asked 7/12, 2017 at 19:22

2

Solved

I have a data set without any data at some days (see example below, data from 23/10/2020 is missing). If I load this data into Google Data Studio and make a time series, it shows the empty dates at...
Glassworks asked 30/10, 2020 at 15:39

1

Solved

When I go to make a new data source in Data Studio, I'm prompted to enter the client/server certificates to make a secure connection. Where can I get this client certificate and key? How can I allo...
Philbo asked 7/1, 2022 at 18:25

2

Solved

Currently, I'm facing an issue with uploading (using python) EMOJI data to the BIG QUERY This is sample code which I'm trying to upload to BQ: {"emojiCharts":{"emoji_icon":"\ud83d\udc4d","repost...
Clavicembalo asked 4/9, 2018 at 15:15

2

I've got an issue similiar to the one described here : Pruning BigQuery partitions with Data studio I want to declare a variable to run a custom query in data studio. For example : DECLARE usd_to_e...
Nalor asked 1/7, 2021 at 17:28

1

I am trying to connect a Data Studio report to a table and to a view from BigQuery. In BigQuery the table receives the data from a GoogleSheet that is located in my Drive, the view is querying this...
Luciennelucier asked 1/4, 2021 at 12:24

2

Solved

I am new to Google Data Studio. I think I have an issue, with turning dimensions into metrics or with correct assignement of values. This is because a colulmn which should display numbers just disp...
Sheply asked 29/6, 2020 at 10:55

1

Solved

I combined these two REGEX rules in a single CASE statement in Google Data Studio, but only the first rule is applied. CASE WHEN REGEXP_MATCH(Seite, "^/amp/.*") THEN REGEXP_REPLACE...
Traver asked 7/6, 2021 at 14:55

© 2022 - 2025 — McMap. All rights reserved.