DavidChurchman 🟡

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…

@ST_-Superman-_ Setting 'color rules' doesn't bother me* but being able to format or position the legend of multiple graphs independently would be nice. Like have a legend spanning across multiple cards. * I would like more flexibility, like being able to re-order them, or color one variable based on the values of another…

Linking to sections would be great!

Yes, this would be good. Then you can use the viz as an icon for an overview page

You should be ale to eliminate the null option with a card level filter. For single-selection, I think you want the radio-button, not the slicer. For default filter, I am not certain, but I think if you add what you want the default to be to the default filter view, and then users should be able to use the radio to switch…

If you are wanting to add and subtract columns, it sounds like you do want to join the datasets based on the row numbers of each dataset. This seems more appropriate for ETL than within the card building