ColemenWilson Coach

@jrtomici Yes I re-read your question and realized that my original solution would not work. What I would recommend is self joining the data on itself for every record in A. This way you can compare each row of data in A with every row in B and look for matches. This will temporarily explode your data, but you can then…

Using the remove duplicates tile in magic etl you can choose what fields make a row unique. So in your case you would select just ID and Name to search for the duplicates. EDIT: I re-read your question and the above solution would not get you what you are looking for. You would need to self join the data with itself so…

You need a way to select a single value. This beastmode will have a result for every row of data. I used your same beastmode but limited the card to 1 row of data and then sorted on the date field descending and the card worked as expected. You may have to do some ranking in ETL because you need the most recent of 2…

For a join it is safest to force the entire email to lowercase. ColemenWilson@henryscheinone.com wouldn't join with colemenwilson@henryscheinone.com

I agree with @MichelleH !

In Magic ETL, use the text formatting tile. Select the column containing your email values and then apply All lower case. In a beastmode you would use: LOWER(`Field`)

Many connectors have the option to either replace or append data each time the data updates. For the ones that dont, you can create a recursive dataflow to snapshot the data overtime. Here is a great recording that walks through how to build a recursive dataflow:

That is a good question, our instance uses employee id's so I haven't had to worry about that before. I would definitely test with a small group of test users first.

Ah gotcha! Yeah then you would just add that to your beastmode. CASE WHEN MAX(CASE WHEN `GoalNumber` = 1 THEN `NextMilestoneAmount` END) - SUM(`Measure`) < 0 THEN 0 ELSE MAX(CASE WHEN `GoalNumber` = 1 THEN `NextMilestoneAmount` END) - SUM(`Measure`) END

You can do a bulk import to update the emails. Just download the current user data as shown below. MAKE SURE to download a new version. You can see that next to the button shown below there is another option with a date of the last bulk export. If you accidentally used that and that data was out of date you could be in…

Can you add a column to rank the milestone order?

@MichelleH we posted the exact same screenshot at the exact same time 😂

The above will get your first label. As for the tick mark this cannot be labeled.

For the actual you wouldn't need a beastmode, just a sum of the actual progress. Then for the first stacked bar it would be: CASE WHEN MAX(`Goal1`) - SUM(`Measure`) < 0 THEN 0 ELSE MAX(`Goal1`) - SUM(`Measure`) END The next stacked bar would be: CASE WHEN MAX(`Goal1`) - SUM(`Measure`) < 0 THEN MAX(`Goal2`) + MAX(`Goal1`) -…

Yes. You can use the Domostats dataset "Datasets History" to see the run times of your datasets and then create an ETL that calculates the average runtime and alert you when the run time is x% above the average run time.

You could look at using an overlay chart: You can also create a beastmode in a stacked bar chart that subtracts the actual from the goal and stacks the remaining amount ontop of the actual making the stacks dynamic. We do this for tracking our progress towards goal in our sprints: We each have a different goal amount and…

Was this dataset previously updating and now is having an error? Is this a new dataset that has not yet run? Do other reports run using the same credentials?

Ah gotcha. This is going to be best solved here in your ETL. Below is a link to a screen recording where I walk through one way you could solve this:

Hi Anna, you can't create a beastmode to search between two datasets. You can combine those datasets into one and then have a beastmode search between two fields to see if there is a match. This would be the beastmode to check between columns: CASE WHEN `CampaignField1` = `CampaignField2` THEN 'Match Campaign Name' ELSE…

I had to do this recently where I had a column with 50+ splits. One thing I did to speed things up is shown in the below recording: It's not perfect, but it does speed things up. From there I utilize the pivot/unpivot tiles to make the data more useable. Additionally with the pivot/unpivot tiles it doesn't matter how many…

You would use the chart type "Pivot Table" found in the Chart Types section in Card Analyzer (see below) In your pivot table you would drag your category field into the "Rows" input. Drag the Date field into the "Columns" input and lastly drag your beastmode calcuations into the "Values" input.

You'll want to filter out rows of data that are not the "last day" of data. You can then use the LAST_DAY() function on the date to get the last day of the month (not necessary, but optional). Then you just need to do a lag offset of 1 because your data would look like this: So if you partition by Facility and Engine and…

Hmm I am not getting the same error, see below: Could you screenshot your beastmode so we can take a look?

This is possible, but to help we need a bit more information. Could you share the beastmode field and the other field you are using? It will end up looking something like this: CASE WHEN `Field1` - `CalculatedField` >= 10000 THEN 'In' WHEN `Field1` - `CalculatedField` <= -10000 THEN 'In' ELSE 'Out' END Then you will use…

If this is being used on a dashboard, you could have a separate text value card beneath or above the gauge that uses the same data source and changes the text based on the criteria you define in the beastmode. But to have this on the gauge itself is not possible.

You’ll need to reach out to your customer success manager (CSM) to have them enable the beta in your instance.

You can control for Region Border Color and that is it. However, it is dynamic, so sometimes depending on how your card is configured you will see state borders: See below: Alternatively, you could create a custom map using a DDX brick and have total control over the formatting.

You can partition on multiple fields for your ranking. It would be helpful if you could maybe do a screen recording where you talk and walk through what you are trying to accomplish. Or I'd be happy to set up a call with you to take a look at it. Once again, I am pretty sure we could find a solution - just not sure exactly…

Okay. You would need 2 fields: 1. A rank 2. Number of Employees and then compare the two in a beastmode and if rank = number of employees then "In" else "out". Rank CAN'T be dynamic in this scenario though because you only want a single row left and that would force the rank of that remaining row to 1 which would then mean…

I believe this actually is possible, but I think I need a bit more information about what you are trying to do. You can assign a row number to every row of data in magic ETL, but it will be fixed and wont change from filters in your card or drill path. You can also use a beastmode that will be dynamic and change based on…