Best Of

Re: Returning all the same value.

@Liv_Stearns When trying to match multiple patterns, you will need to repeat the LIKE statement each time. So instead of this:

When (`model` LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110

You will need to structure your conditions like this:

When (`model` LIKE '%250%' OR `model` LIKE  '%2500%' OR `model` LIKE '%350%' OR `model` LIKE '%3500%') THEN 110

MichelleH

1

Re: beast mode

@newbie123 You use a case statement to check whether the order date field is null like this:

case when `order date` is null then 'incomplete' else 'complete' end

MichelleH

2

Re: Is there a way to "freeze" data in domo to compare net new information to previous information?

You may not need to store a snapshot to compare old data to new data. Depending upon the data, you can do a trend of Year over Year, Month over Month, Year to Date, etc. Look under chart types for Period over Period.

YTD comparisons can also be done with formulas representing current year, previous year, previous 2 year, etc. I call this a trend dashboard.

CY YTD:

sum(
case when YEAR(date) = YEAR(CURRENT_DATE())
and date <= CURRENT_DATE()
then amount else 0 end
)

PY YTD:

sum(
case when YEAR(date) = YEAR(DATE_ADD(CURRENT_DATE(),-365))
and date <= DATE_ADD(CURRENT_DATE(),-365)
then amount else 0 end
)

P2Y YTD:
sum(
case when YEAR(date) = YEAR(DATE_ADD(CURRENT_DATE(),-730))
and date <= DATE_ADD(CURRENT_DATE(),-730)
then amount else 0 end
)

ArborRose

1

Re: View as user or view as role

Excited to see some traction on this! As I'm developing a better mental model for how permissions on various objects / roles / PDP interact this would be really helpful. And avoid the "Can you share your screen? How about now? now?" conversation :)

nolan

3

Re: Custom Date & Timestamp Formatting in Analyzer View of Cards

Great post! Thanks for documenting this for everyone!

MarkSnodgrass

2

GA4 Sessions & Total Users Ingesting Incorrectly

I am trying to ingest Sessions (Sessions and Engaged Sessions) and Total Users into Domo via the GA 4 Connector.

We can get New Users and Events to ingest into Domo correctly.

I have tried to bring the data in alone (no dimensions) and with additional information (2-9 dimensions). I have also tried each metric separately, again with both no dimensions and multiple dimensions. In addition to those I have tried to bring it in with additional metrics to see the affects (IE Total Users and New Users together). I have also tried both of the above approaches with only 1 day of data to 30 days worth of data.

At all variations of ingestion I have never gotten a correct number. The number ingested by Domo ranges from 6 - 16 times higher than the number displayed in GA. The multiplier is also not consistent (one day will be 10.5 times higher and the next will be 15.8 times higher), so I can't just divide every value by a multiplier.

Has anyone found a solution or work around to get these metrics into Domo accurately?

Thanks in advance.

Carolyn_S

1

Re: Clear all fields option in Analyser

An option to select the defult vizualization type would also be nice!

TC111

1

Re: Set up schedule and automatically refresh Google Sheet add-on

@noza_IMJ

I looked into this and it does not appear there is an auto-refresh option for the Google Sheets add-on. Since this product is in the beta stages, I would recommend using the Feedback button from within your instance to let the product team know this is something you'd like to see with this.

You can also search our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea exists then vote it up, otherwise submit your idea so others can vote it up.