ColemenWilson Coach

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: https://domo-support.domo.com/s/article/360043429413?language=en_US 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…

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: https://www.loom.com/share/213f6231deb74ca59f6b006ab563c453?sid=2298a47c-9dc7-4eb4-bafb-e1977069daf7

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: https://www.loom.com/share/671eda360b2a4d4da2741363419200c9?sid=7309d94b-1d8e-4448-90d3-1d6c7d98c205 It's not perfect, but it does speed things up. From there I utilize the pivot/unpivot tiles…

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…

@MarkSnodgrass Awesome solution! I immediately thought that this would have to be a loop in python but I love your non-python solution!

I replicated your sample data and plugged in my beastmode to the data and it worked as expected. See test column above. Here is the exact beastmode using your field names as provided: CASE WHEN MONTH(`Monthly`) = MONTH(CURDATE()) THEN `Goal` * (DAY(CURDATE()) / DAY(LAST_DAY(CURDATE()))) WHEN MONTH(`Monthly`) >…

I'd suggest talking to your Account Executive and/or CSM about Python scripting tiles or Jupyter workspaces. From there you can find python packages/libraries that help with fuzzy matching: https://medium.com/codex/best-libraries-for-fuzzy-matching-in-python-cbb3e0ef87dd

If you have pre-defined groupings then you can use a formula tile or beastmode to create a new field that groups the data together based on your criteria. You could start with something like this: CASE WHEN LOWER(`Underwriter`) LIKE '%bankers trust% OR LOWER(`Underwriter`) LIKE '%bankerstrust% AND LOWER(`Corporate…

This was just announced today as a new Domo feature release! Reach out to your CSM for beta access!

Assuming your data looks like this: CASE WHEN MONTH(`Month`) = MONTH(CURDATE()) THEN `Goal` * (DAY(CURDATE()) / DAY(LAST_DAY(CURDATE()))) WHEN MONTH(`Month`) > MONTH(CURDATE()) THEN 0 ELSE `Goal` END If your data is structured differently and you can't figure out how to modify the beastmode to work please let me know and…

@zacpolin There is a brand new chart type announced today called Packed Bubble chart that could be an option for your hierarchical data. https://www.domo.com/product/new-features#new-charts