Best Of

Re: Dashboard "Save-As" Dataset Change Option

I'd also love option to choose whether or not to include the “Duplicate of” prefix in the names of copied cards in this step!

MichelleH

1

Re: Dashboard "Save-As" Dataset Change Option

Or an option to only duplicate the layout

ST_Superman

1

Re: Dashboard "Save-As" Dataset Change Option

Yes please!

DataSquirrel

1

Re: GA4 (Google Analytics) in Big Query - unnesting.

@cpbwg

Bigquery query syntax has methods that allow you to access nested data. Here is their documentation with examples: https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays

For example, say you have a column in a row and the value is a string with nested JSON/Object that looks like this:

Your query in the Domo connector settings would include something that looks like this:

SELECT e.key,e.value.string_value , aa.* 
FROM ‘your-table’ as aa,
UNNEST(even_params) as e
WHERE (include whatever condition you want)

And the result would be that those nested values are extracted and become new columns.

rileystahura

1

Re: I wanted to rename few items in a column based on this campaign, in the ETL

@MichelleH That's ok, no worries. Now I got it. My bad! In the campaign column my campaign name was in capital letter and in the formula I was using small letters! That was the problem. Now I changed it and it is working now. Thank you for checking.

Salmas

1

Re: Writing a Case Statement select another field value if primary field value is blank

@Clinton Your logic should work, though for future reference you can simplify it using an “is null” operator like below:

case when Parent Carrier ID is NULL then Carrier Name else Parent Carrier Name end

MichelleH

3