Best Of

Re: Magic ETL Dynamic Pivot

Is there already somewhere to upvote a dynamic pivot tile in magic ETL?? I would love to upvote that bad boy :)

RyanHartquist

5

Re: IncreasingTooltip Fields Number

You’re limited to 3 tooltips however you can create new beast modes and combine several fields together with a CONCAT and then use that beast mode as a tooltip.

GrantSmith

1

Re: Filter Rows in Magic ETL based on Text

I have found that filtering on TEXT fields in ETL Data Flows is unreliable. My work around is to use the VALUE MAPPER to create a NEW COLUMN with a NUMBER in it for those text fields I want to filter on. I then use COLUMN TYPE to set the column type to WHOLE NUMBER (it defaulted to a text field when I created the new column in Value Mapper.) Then I FILTER to include only those rows with the number I identified in the new column created in Value Mapper. Additionally, I have found one other unreliable responses with FILTER: Multiple filter values in one FILTER sometimes don't work, so I do one FILTER step for each field I want to Filter on. I discovered all this attempting to create a MaxDate field. I also found in the GROUP BY feature using large file with many rows, the process stopped after processing only part of the file. So I added a filter to further reduce my row count to get an accurate result for MaxDate.

Asydnor

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

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: Month Over Month % Change of Total Number

It's irritating that NULL values tend to break math

trafalger

1

Re: Beast mode to only show matching creative types in grouped bar chart?

So do the same logic, but use @GrantSmith's post here on how to calculate rolling averages:

https://community-forums.domo.com/main/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages

trafalger

1

Re: DOMO QA Dashboard

Hi @Pellogat A couple of thoughts:

Define the Data Quality (breakage) and think about how you would want to identify this and be alerted to it. What does this look like? A dashboard? A card? A set of alerts? If you have historical breakages or data quality issues you could draw from, think about the methods which you used to identify those before acting on them.

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.

JasonAltenburg

1

Re: Can you use Magic ETL to 'explode' table of transactions to all days?

@M_Gonzalez The Calendar dataset from the Domo Dimensions Connector contains a list of all possible dates. I suggest joining Table A to the Calendar dataset then filtering to remove duplicate statuses

MichelleH

1

Re: Table with bars

You might want to look into the faceted bar chart.

https://domo-support.domo.com/s/article/7508982399767?language=en_US

MarkSnodgrass

2