DavidChurchman Coach

Wow, what a great find. This is incredibly misleading advertising from Domo. Everything about this would be very difficult to achieve without basically coding it yourself in Javascript and using a D3 or Echarts brick to put it in your dashboard (and if you're able to do that, what is the value-add of Domo?). I'm commenting…

Some similar ideas (I'm not alone):

What do I have to do to prove that I am aware of App Studio? It's like a missionary doing their service trip inside the church building. We know, Khushboo!

Agree with Manasi, you could use a CASE statement in a BeastMode. Something like: CASE WHEN [conditions for first table] THEN 'Row 1' WHEN [conditions for second table] THEN 'Row 2' WHEN [conditions for third table] THEN 'Row 3' ELSE 'Exclude' END Then filter your card to exclude the 'Exclude' rows.

If you switch it back to an HTML table, are there any settings not turned to default? Sometimes when you switch between card types, you can check off a setting that still applies to other card types, even if that setting doesn't appear in the menus. My other thought it that maybe one of the cards is on a "view" of the data…

You need to reshape your data so the years are in a column. That would be easy in a MagicETL: If you don't want to reshape your data, the only card I can think that would make sense "out of the box" is the pivot table card:

You need to reshape your data so the years are in a column. That would be easy in a MagicETL:

With the 4 columns you describe (Product, 2025, …, 2028), I don't think there's a way to get the bar chart you described without reshaping your data first. The only card I can think of that would analyze your data as is would be the pivot table: If you're willing to do a quick MagicETL to unpivot your data to a long…

You could use the Word Cloud chart type, and have a different dataset/column/etc. feed into each slide:

There's another Qualtrics report called "Survey Response Choices" that you can join to the "Survey Responses" report for the labels.

Yes, this is a frequent question in the forum, and multiple ideas have been posted about it. Pasting a few of those for additional visibility.…

You can create a view of your dataset and rename your date column for that view. Then use your view for the single card. The client filter will still work, but since the name of the date column is different, the page filter for the date won't affect that card.

You can use a window function to create a running total column: sum(Sum(Impressions)) over(order by Week) And then you can create another one that divides that by your goal. (Not sure if that goal is in another column or what, so just using roughly what it seems to be based on your data): sum(Sum(Impressions)) over(order…

You could filter using a BeastMode/Variable combo. This video has a walkthrough of almost exactly this situation: https://www.domo.com/learn/video/variables-use-case-feature-walkthrough

I don't know the technical way to say this, but BeastModes need to be at all the same level of aggregation. So if part of your BeastMode is fixed, all of it needs to be fixed. Rather than using nested BeastModes, you'll have better luck re-writing the larger BeastMode from scratch, which will make it obvious where you are…

Is the checkbox to "Save Calculation to Dataset" clicked on?

Find a table with the lat/long of the provinces and join it to your table of values so you can use the lat/long map. There aren't that many provinces, so if you don't want to bother with a join, it wouldn't be that hard to do it in a BeastMode for lat and Beastmode for long. Something like: — Latitute Case when Province =…

There's the 'Card Pages' DomoStats dataset. Is that what you're looking for?

For the OP, if you open the "detailed" view of the card, then you can zoom in/out in the browser window to get something pretty similar to what you asked for. If you need every value in something that scrolls on the dashboard (without having to expand to details), maybe a heatmap table instead of a bar chart?

Since you have mixed types of aggregation, I think instead of putting the SUM on the drop-down of the Total beastmode, where it affects the entire BeastMode, I would write it into the BeastMode itself: SUM( Online Fee + (amFee-`Platinum amFee`)+ … Royalty Inside Charge) + AVG( `Ticketing Royalties Expense 1 `) The thing is…

Could you give a sample of what your data looks like (anonymized) and describe the end-result you're trying to achieve? Ideally, mock up a sample of what you expect to produce from your example data. It's difficult to trouble-shoot a big BeastMode like that without understanding what your data looks like.

When you say you added a filter that "Hierarchy not in REVENUE", does that mean the Structure column will never equal 'Revenue'? If so, that means that your denominator will be 0 because of your ELSE statement, and dividing by zero will result in null.

@ArborRose Yeah, with arrows like that, you could also make your target 100% transparent and just use the data label as the target (centered data-label from tool-tip, symbols-only data-label): Case when Price* Quantity >= Budget then '🔹' when Price* Quantity < Budget then '🔻' END

This should work: That said, the format you have your data in already is ideal for most uses. You could also pivot it as is in a Pivot Table Card:

As far as I know, you have to use the HTML formatting in a Summary Number. When I do this, I use a single-value card with blank values for the values in the card, and put my HTML beastmode in the Summary. This would be a crude example (hyphens instead of a solid line), but maybe you can adapt it: concat( '<div>',…

ArborRose's approach works on most card types, but not on the Bullet Chart. For whatever reason, Bullets won't accept color rules like this. If I were to guess why, it's that the philosophy behind a Bullet Chart is to show progress against targets using the relationship between the bar and the target marker, so a color…

The closest thing I can think of out-of-the box is you could use variables to manually explore different combinations, and depending on how complex your situation is, that might be a good way to get an intuitive sense of why the optimal solution is what it is, or what some sub-optimal good-enough solutions would be. Or if…

This is a common question: here's one (of many) answers to it: https://community-forums.domo.com/main/discussion/comment/86113#Comment_86113?utm_source=community-search&utm_medium=organic-search&utm_term=filter+on+nulls If you found it frustrating/unintuitive, you could vote on several of the idea exchange ideas to improve…

I agree. Did a few double-takes and mis-clicks with these new icons

I'm not 100% I understand what you're saying, so I'm going to say what I think you're saying, and then you can correct me if I missed something. (GrantSmith's suggestion is a good one, and likely to lead to a faster/better answer.) I think your data looks something like this: And then you have BeastModes like this: and: In…