DavidChurchman Coach

First, how to get those aggregations (no formula needed): You could set up a table card with two columns, id and number . If you select "sum" for the aggregation for that field, it will show the sum per id. Then you could have a second table card with list and number and a third with just number. To match your question, I…

There is "Domo Everywhere", where you can privately embed instances of your dashboard somewhere outside of Domo, and it is possible to create your own authentication with that private embed (i.e. not a Domo account). Using Domo Everywhere does cost more and there are technical hurdles to implementing it. PDP is not…

In MagicETL, you could do outer joins between your actuals and scenarios. If you want all scenarios available for both the first and second filter, then you could join the scenarios twice, renaming the columns on the join to distinguish. So basically Actuals x Scenarios copy 1 x Scenarios copy 2. Then you could do all the…

I would use a "bullet chart" for this situation. It's designed to show progress against a goal with staggered targets.

I haven't used PyDomo, but it sounds like you're replacing a dataset when you want to append your dataset. This post has the same question: https://community-forums.domo.com/main/discussion/56876/pydomo-ds-update-to-append-data

I think a best practice when dealing with a large number of fields like this is to unpivot them into a "long format" dataset rather than a super wide dataset. That helps you not have to perform the same transforms 25 times, and usually makes building cards easier, too. Making some broad assumptions without knowing your…

I was having a similar issue with a date column that changed to text when I wrote the data frame to a dataset in Domo. I played with the different dtypes, and found one that did stay as a date after moving to Domo (though the timezone changed, so it ended up being a few hours different than what I had in Pandas). Domo…

I believe the controls match the sort of the dataset or card.

To do aggregate (as opposed to row-level) calculations in a BeastMode, you'll need to use FIXED functions: Yours would be something like: (case when sum(count(Distinct `Customer Name`) fixed())>=2 then 1 else 0 END)/sum(count(distinct `Customer Name`) fixed())

To some extent, it is implemented, but costs extra. There are limitations to where the custom fonts can appear: https://domo-support.domo.com/s/article/5428851518999?language=en_US

One of the simplest things that would open up so many options

Strongly agree with conditional color formatting. The custom color templates aligned with your company is a available in the "Brand Kit", for 💰💰💰 https://domo-support.domo.com/s/article/5428851518999?language=en_US

A lot of what you're describing can be done with bullet charts. It has that satisfying goal line for the bar to punch through, as well the ability to shade incremental goals in the background before the one big goal. You can't break it up into a stacked series, but I think you would end up with something easier to…

Yes, agreed! The export should appear the same as the dashboard for both PDFs and PowerPoints

I think there's more than one thing going on, but I would start by playing with your sorts. I don't think you want a sort on Onboarding Conversion status, which is what's causing the duplicate dates across your x-axis.

There are no rank functions in beastmode (unless I'm mistaken?) but this would be relatively easy to accomplish in Magic ETL. First, a GROUP BY block, grouping by CPT Code, getting a sum of value. Second, a RANK & WINDOW block, finding the descending rank of the value sum column you made in your group by. Third, LEFT JOIN…

Originally, I thought it was because my chart had two many nodes, but even after restructuring so I only have 2 nodes, it's still cutting off the right side of my chart

I'm noticing this, too. Updating the variable definition in the analyzer does not update the variable control card. This needs to be fixed to make variables usable

Okay, I figured out the actual solution (can I revoke marking someone's answer as the solution and give it to myself?). Maybe this would be obvious to everyone else, but in case you are like me and have huge bubbles you can't figure out that don't correspond to your legend, this is what I needed to do: * Turn off auto-zoom…

Here's an example Magic ETL that does this: This creates a column that has the Total # Accounts on every row You can then use the average of that as your denominator in the BeastMode: COUNT(DISTINCT `Account Number`)/avg(`Total # Accounts`)

The image given in the documentation looks as if it the legend is scaled correctly, or at least in the correct ballpark. Bern is 15.6 million, which appears to be almost exactly the same size indicated in the legend. Based on this answer, this is either misleading or incorrect.

It sounds like you want to do a left join using either DataFusion/Blend or Magic ETL. Based on your question, it's a little unclear what you want to keep from the first dataset and what you want to drop, but both options give you the ability to drop columns from either the left or right dataset.

I would like this for choosing which elements appear on the card (title/description/summary, etc.) I often want a similar layout for 3-6 cards at a time

I also think this would be nice. It could use the same language as the "Any of these are true" option on the filter block in magic ETL. You could present users with groups of filters, and they could switch between "any" and "all". In the meantime, you could achieve something similar with a variable, and link that variable…

Looks like you're missing "END" in the second formula

I don't think you want 'graph by' since it's not really a time series. You're using the year as a categorical variable and applying it as the series value. I would get rid of the 'graph by', and then double check your sorts

What you're describing is an "inner join". You can do it in Magic ETL: https://domohelp.domo.com/hc/en-us/articles/360044876194-Magic-ETL-Tiles-Combine-Data or DataFusion: https://domohelp.domo.com/hc/en-us/articles/360043428293-Combining-DataSets-Using-DataFusion DataFusion is simpler. All it does is join the data. Magic…

There's no " over(partition by)" in BeastMode I'm not a fixed function master, but I'm pretty sure you just need "BY". This user says FIXED BY is the same as ORDER(PARTITION BY) https://dojo.domo.com/main/discussion/55689/fixed-functions-are-difficult-to-understand-and-should-be-rolled-into-window-functions

You could concatenate the months of the two columns, and then use the "contains" filter. For example, the cell value would be "May, June" (concatenated from the two date columns), and the filter would be "Contains May"

I think the math isn't that hard to get week differences, you just need to multiply the years by 52. ( LEFT(YYWW_date_1, 2)*52 + RIGHT(YYWW_date_1, 2)) - ( LEFT(YYWW_date_2, 2)*52 + RIGHT(YYWW_date_2, 2)) For your 2301 - 2244 example, that would be (23*52+1) - (22*52 +44) = (1197) - (1188) = 9 Caveat: I'm pretty sure…