Best Of

Re: Last 13 Months Using Selected Date Slicers

@hunter_brown Unless you want to set up a variable, you will have to select Between December 1, 2021 and December 31, 2022 in the date filters. The rolling date ranges only work relative to the current date.

MichelleH

1

Re: WE WANT TO HEAR FROM YOU: Where do you go for information for and help with Domo?

Hi Anna, I always start with the knowledge base. :) 9 times out of 10 it answers my question, if I can't find the answer I search the forums to see what the experts have to say.

pauljames

3

Re: How do you separate data in a column

You can use the pivot tile to pivot your engagement type values into individual columns. This KB article will be helpful for you.
https://domo-support.domo.com/s/article/360044951294?language=en_US

MarkSnodgrass

2

Re: How do you separate data in a column

Agree with @MarkSnodgrass, pivoting the data is the way to go, and doing it via ETL when you foresee this being needed for other calculations is preferable. If this is only used for this you can go with Beast Modes, so your Score formula would become something like:

0.5*COUNT(CASE WHEN `engagement_type` = 'OUTGOING_EMAIL' THEN `id` END)
+1.5*COUNT(CASE WHEN `engagement_type` = 'CALL' THEN `id` END)
+COUNT(CASE WHEN `engagement_type` = 'INCOMING_EMAIL' THEN `id` END)

So basically you'll have one entry for each type of engagement that should be accounted for as part of the score.

marcel_luthi

2

Re: How do you separate data in a column

@ScottLeeds Is there actually a column called id in your dataset? If not, you can change those portions of the beast mode to a different field, as long as it does not contain nulls.

MichelleH

1

Re: How do you separate data in a column

As Michelle says, I used Id since it's a column present on most of my tables that I know will never be null, so you can either replace that with a column name that is always provided or if you don't have one, you can update to use the literal number 1 instead of a column name, it'll yield the same result (supposing your dataset is fairly clean). You can also create a separate beastmode for each line without the multiplier to show the number of activities of each kind. I see your formula is using only = 'EMAIL' in the comparison while your sample data contains 'INCOMING_EMAIL' as one of the possible values, so make sure you account for those.

marcel_luthi

1

Re: DOMO QA Dashboard

@JasonAltenburg Data breakage in that, sometimes adobe stops sending data to domo and depending on the dashboards, it might not be caught for days, weeks, even months. I am looking to create a dashboard with a set of cards, that i can say check every week or day to see when there is a data gap between data warehouse, Recurring and Master.

But i see "For data gaps, you could utilize group by and count in MagicETL to ensure that you have matching row counts for the granularity needed between the master and recurring datasets. In other words, you could count previous hour/day in your recurring and compare row count to your master for that hour/day" as a great idea.

Thanks,

Pellogat

1