Skip to content
Advertisement

Tag: google-data-studio

Date formatting from BigQuery to Data Studio

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 parse_date(‘%Y%m%d’, date) another option is cast(date as DATE format(‘YYYYMMDD’))

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 Datastudio with my goal being to get the “outletcontact_id” field with my first table

Advertisement