Stack Overflow
Stack Overflow

Questions tagged [looker-studio]

1796 questions
36
votes
4 answers

Heroku Postgresql with Google Datastudio

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. Now, I'm 100% sure that I'm correct on those…
nobe4
  • 2,802
  • 3
  • 28
  • 54
24
votes
7 answers

How to make a simple histogram (representing a distribution) in Google Data Studio?

Do you know if it's possible to make a simple histogram representing the frequency of all my values divided by ranges (0-5;5-10;10-15;15-20 ...) ? Exemple:
Olivier
  • 432
  • 1
  • 3
  • 10
23
votes
1 answer

Connect mongodb to google data studio

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 can import are limited. Do you have any suggestions?
Francesco Clementi
  • 1,874
  • 4
  • 13
  • 28
17
votes
1 answer

Why is only the first case statement applied in a Google Data Studio?

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(Seite, "^/amp/", "") WHEN REGEXP_MATCH(Seite, ".*-[0-9]+$")…
user3392296
  • 644
  • 4
  • 16
17
votes
1 answer

Does Google Data Studio have API functionality, and if not, will it in the near future?

I'm trying to automate a workflow using Google Data Studio. Requirements are simple - I need to be able to programatically copy a templated report (from a Python/Java application) and import/set a data source (Google Sheets doc) for that report.…
J-C
  • 173
  • 1
  • 5
16
votes
1 answer

BigQuery Crashlytics - Crash free users / sessions

I've linked my firebase crashlytics data to bigquery and setup the data studio templates provided by google. A lot of great data in there except the most important metrics required for my dashboard: crash free users and crash free sessions as a…
Ollie Jones
  • 437
  • 1
  • 9
  • 16
15
votes
1 answer

Apps Script Activity Reporting/Visualization

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 hosted on the company's google drive. Each employee…
Alex Libengood
  • 510
  • 1
  • 4
  • 11
15
votes
4 answers

Google Data Studio: How to count number of specific events

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 shows me number of Unique Page Views VS Specific Event.…
Bruno Monteiro
  • 4,153
  • 5
  • 29
  • 48
13
votes
2 answers

Display GA4 event parameter in google data studio

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 a table in Google Data Studio to show how many…
Patricks
  • 715
  • 2
  • 12
  • 25
13
votes
1 answer

Google Data Studio & AWS MySQL SSL Connection

I am trying to remotely connect Google Data Studio with our MySQL Database, which is hosted on an AWS instance. To allow for a secure connection, we added SSL access to the AWS's MySQL database user as recommended in the documentation: GRANT USAGE…
d_-
  • 1,391
  • 2
  • 19
  • 37
13
votes
4 answers

MySQL date and datetime formats unrecognised by Data Studio

I've linked Google data studio with a MySQL database using the standard connector. Almost everything works fine except for date and datetime fields. I have these 2 fields in phpmyadmin (field name, field type, output): Validated_date datetime…
Alex Mille
  • 133
  • 1
  • 8
12
votes
2 answers

Connect a Google CloudSQL Postgres database to Data Studio

I am trying to connect a Postgres database hosted in a google Cloud Sql instance to Data Studio. I have followed the instructions (found here https://support.google.com/datastudio/answer/7288010) but to my disappointment, I still cannot connect to…
Thomas Kaliakos
  • 3,274
  • 4
  • 25
  • 39
11
votes
8 answers

Data Set Configuration Error in Google Data Studio

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 after 2 days it shows the screen: The data set is…
Chanchal S
  • 121
  • 1
  • 1
  • 3
10
votes
3 answers

Calling Bigquery Stored Procedure from Google Data studio

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 procedure from datastudio report and get results for the…
user15432774
  • 109
  • 4
10
votes
2 answers

Why can't I create a Google Analytics property view?

I'm trying to use Google Analytics as a data stream for Google Data Studio but it requires me to have a property view. There is no option for me to create a view in my property in the administration page: There is no column named Views: Is there…
Matheus Hemerly Risso
  • 123
  • 1
  • 2
  • 9
1
2 3
…
99 100