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