I’m trying to connect Google Analytics data from BigQuery for visualization in Data studio; I can’t get the date formatted in a readable format in data studio. I’ve tried using this reg expression: but i still can’t get it to work. The text format is ‘20210921’ Answer Use p…
Tag: google-data-studio
SQL how to select a single value from a table with LEFT JOIN, In Google Datastudio
I have two tables one table called mailing_events and one table called mailing_outletcontact. Examples of my tables are below. The mailing table is very simple with no duplicates: My Second table “mailing_outletcontact” has duplicates in the email field. I am trying to query the database in Datast…
Why am I getting a CASE error when in Data Studio?
I’m trying to convert a four-digit numerical code to a four-digit (one letter + 3 numbers) with a CASE clause in Data Studio. The four-digit numerical code is being pulled out of a Sheets file. I keep …