DavidChurchman Coach

GrantSmith's restructure would be more dynamic than what I'll suggest, but if you want something a bit simpler: Approach 1: ETL a Baseline Column All of your 7 BeastModes are comparing to the same baseline. You could just use an ETL to filter for that baseline data and join it back as a "baseline" column to your dataset,…

The "DISTINCT" in your COUNT(DISTINCT) will make it so each student is only counted once across whatever level of aggregation you are using in your card. Since students tend to be the same across fall/spring/summer, your count across the terms will be closer to the count of a single term than the sum of the terms. That…

The dataflow is working again, with no changes from me. It was probably some update? Maybe I should add "wait a couple hours" to my troubleshooting toolkit.

I can't tell from you've written if your problem is A) the graph goes to 12/2025, even though you only have data through 1/2025. B) It's hard to see the "action", because the y-axis goes from 0 to 40M, even though the values are all in the 25M to 35M range. If it's A, then you need to filter. You could filter for Actual RM…

What happens if you try making the cards larger? I think sometimes different browsers resize/reformat a little weird

Because I'm so bad with FIXED formulas, I would personally probably approach this at the ETL step. If you do your FBA/WFS in the ETL before filtering the "On list", it should work.

Is Financial Month an actual date-type column, or is it a string column? If not, you might need to reformat it so that Domo reads it as a date.

I think you can do this with a FIXED function: https://domo-support.domo.com/s/article/4408174643607?language=en_US It always takes me at least three attempts before I correctly write a FIXED function, so this probably won't work out of the box, but it will be something like this: CASE WHEN SUM(CASE WHEN WAREHOUSE_CODE IN…

As an addendum, I think those super wide tables with just a couple rows are hard to scan. To me, it's a lot easier to read across long lists of numbers in columns:

Here's an approach: I think you should group your metrics by 'Revenue' and 'Costs' Then, to get that Total row that is a different aggregation (% gross margin) than your value, a BeastMode that tricks the pivot table into doing that for you: Then a pivot table: One of the options on subtotals is to add padding, which acts…

You should be able to get an average in the total row by switching the aggregation to average the way you did. There's something else going on. Maybe a lot of nulls in the data? Or you accidentally clicked "Hide total" option on the measure?

Okay, I think this is what you'd want for your Test 1 Forecast beastmode: SUM(AVG(`Test`) FIXED(BY Week Ending Date)) - SUM(`Test 1`) That first half sums the average of Test, fixed by week. I use the average so we get 363K once, and then fix it by week so that it uses the average for each week, summing across those weeks.

SUM(DISTINCT) is only adding up the distinct values. In this case, all the values are the same, so it just returns 363K, where you want it to return 363K*4 for the four weeks. Depending on why you are doing a SUM(DISTINCT) rather than a SUM(), you might be able to resolve this by just doing a SUM(). Or you might need a…

Coleman is right that you'll need to share more about your BeastModes to give a full answer, but what what appears to be happening is that you are subtracting the two columns. The first column is unchanging and the second isn't. The resulting grand total is the difference between the unchanging value and the sum of the…

I think something like this would work: CASE WHEN COUNT(DISTINCT Division) FIXED (BY Customer) >1 then CONCAT(`Customer`, '-', Division) else CONCAT(Customer) END

I'll miss the cringe-bot

In AppStudio, you can set filters to persist across pages in the app, and set up links to other pages within the app (or just have people browse between pages using the drop-down). Is that similar to what you're asking for?

Flag Count is already aggregated in the BeastMode, so it doesn't let you switch the aggregation, which is why that option is greyed out, but it should still be able to aggregate in the Summary. What happens when you switch from "Use Current Value" to "Use All Values"?

So, the question is: how to have sub-totals display in-line with their category and still preserve the ability to have a total row. Short answer, no you can't do that. Long answer, you could fake it using an ETL: pre-calculate the sub-totals and totals and append the rows: Then turn off the subtotals and totals in your…

If all you are pivoting is a single value metric by two categories, like in your example, you can use the "Heat map" chart type from "Popular charts" (not the Heat Map table). That pivots your data and gives a lot of heatmap options. I also like it because it's the only table type where you can use Tooltips to get a lot of…

You could go real old-school, use a monospaced font, and pad the column so they all have the same number of characters. There might be an easier way to pad in a BeastMode, but something like this would work, where 25 is the maximum string length of a column value, and you pad it out with extra spaces ending with a period…

How is this different than a default filter view?

In your sample data, if you drop Class 2, add a total row, you can label the total row "Gross Margin", and it will appear like the other rows:

The BeastMode could be written without the Country: (sum(CASE WHEN Fruit = 'Oranges' THEN Picked ELSE 0 END) + sum(CASE WHEN Fruit = 'Apples' THEN Picked ELSE 0 END) )/ sum(CASE WHEN Fruit = 'Pineapples' THEN Picked ELSE 0 END) And the way you would "pivot" by country is by using country as a variable: You could literally…

You could use the "financial style negatives (100)" option, which is a standard way to deal with this, and uses parentheses instead of negative signs:

Yes, I would love more control over the "control" menu! I end up adding so many filter cards to my apps because I know the control menu will be too hard to navigate, which isn't the best use of screen real-estate when there's a built in, collapsible menu that should do that for me. You should submit this post as an "idea"…

Love this. It would be so much more intuitive and space efficient!

Maybe I'm misunderstanding what's in your data, but I think you just need to drop 'Class 2' from your rows. Then format your total row to have the same formatting as your other rows.

When you look at your Magic ETL's history, is the error thrown on the Python scripting tile or somewhere else? What's your Python script?

I'm sorry, I didn't read your original post very carefully. Your formula in the ETL is fine so ignore my comment about wrapping the 8s and 10s. Using your sample data, I could not recreate the error with your formulas (wrapping the shift length in a sum). Re-reading, the only thing that might be wrong is your beastmodes…