DavidChurchman Coach

Interesting, this appears to be a bug, which I was only able to reproduce with single-item groups like this (where the preceding entry is exactly the same). A handful of approaches (each with their own drawbacks): If you check off "suppress single item subtotals", it will give the unit type (but you'll lose the formatted,…

Sometimes it can be hard to access the menu on small cards, so I might try resizing it to see if that menu appears. (Drag the border of the dead-space up into the card above it)

Yes to better boxplots! I would also like the ability to label them correctly, with each of the numbers on the correct place on the plot.

It's funny, on an embedded app, you can "allow export" which surfaces the Export button to be right next to the "expand for detailed view" button, which is way easier to find for users. It would be nice if this was possible in an AppStudio app that was shared directly in Domo.

This isn't as good, but as an action tied to the alert, you can send a scheduled report. That scheduled report can be tied to a specific, filtered card as you describe, and there is an option to include the Excel dataset on the email. I did this for a report that I scheduled years in the future, so it's only sent based on…

I figured it out. I had a column in my dataset called "Year", that was in a weird school year format, i.e. "2023-2024". I had filters on that column, but for whatever reason, in some places, Domo interpreted that values in that column as "2023" instead of "2023-2024" (trying to force it to a numeric year, I guess). I had a…

Rather than the output, a sample of the data in the format you're using would be more helpful. Explaining the column names used in your BeastMode would also help. I'm not sure what 'Cost Center Family' is, but I'm assuming that partitioning over it is what is causing the issue in the total row. In my experience, Pivot…

Yeah, n would be great, especially under the category name, like what would be standard in a publication. I'd add the labels currently available should have smarter placement, i.e. median goes on the median, Q3 goes on Q3, etc.

No, can't install from a mirror or directly from GitHub

Not super clear what will be shown for each of the 21 "cards", but if the idea is to show them all on the same screen, I would try to find a way to graph all the combinations in a single card. It would be impossible to get 21 cards onto the same screen in Domo, with how sparse the design options are in Domo. You might…

Also, something weird about the lat/long maps are that you can apply color rules, but they don't show up in the "Chart Properties" panel. You have to access them through the color rules menu up top

Yes, but… Are all staff that work in a department in the same State? If not, then you'd need a different card type. I'd say the best card type for this level of detail is the lat/long map, but for that you'll need to get the lat/longs instead of the zip codes (I'm sure there are tables you can join to your zips to get…

It seems to that the team/region/country cards would be on such different scales that they wouldn't be that useful to have all on the same card. The simplest implementation would be 3 different line graph cards, one using "Team" for its series, one using "Region" for its series, and one using "Country" for its series. You…

Is the same dataset powering your "Units" gauge as the map? If the goal is to get the same number to appear on both that and the map card, a good place to start would be what is different about those two cards

It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work: CASE WHEN customer='Spektra' THEN 'Wednesday, Friday' ELSE 'What you want ConsolidationDay to be when the customer is not Spektra' END If you want it to be null when the customer is not 'Spektra',…

Yes, I have gotten this to work. Heads up: HTML formatting tags only work on Summary Numbers (which you got to work), HTML tables, and Heatmap tables. (Not MegaTables or Pivot Tables). Stuff in your HTML formatting might get "trumped" by other properties native to the card. For example, the font-weight (bold/vs. not bold)…

There's a calendar card-type, if you just want a list of dates. But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in…

There are two A/3/M rows, so 2/3=.67 is correct, right?

@jrtomici Hard to say what's going on. It looks like you added a few rows to your example data. Could you post a screen grab of the raw example dataset, too?

The numerator seems like it will be a straight count. For the denominator, you want an average of the Avails fixed by your distinct grouping. count(Network)/(AVG(Avails) FIXED(By Network,Hour, Date))

I'm going to plug two ideas in the exchange (one of them mine) that also request descriptions for PPT/PDF exports. You could upvote both of them and post your own for fun. Then there will be company in the void that you're shouting into.

Sorry, I meant the "summary number" that's part of any analytics card. I don't think you can apply html tags to smart text within a text card (unless someone knows a way to do that?) The other warning is that HTML tags don't show up in previews; you have to save and close a card to see the formatting applied. Finally, I…

My favorite way to do this is in the summary number. You can apply HTML formatting tags to summary numbers. Here's an article with some examples: I sometimes will use a text card with blank text and only a summary number, since I have more control over the formatting of the summary number than the card itself. For your…

Short answer: there's not really an easy way to do this. A) HTML format each column You can use HTML coding in an HTML table to hard code formatting like this. If you have a wide data structure, each month's formula could look something like this: CONCAT('<div style=color:#000000>', Case when February = January then ''…

You can't directly. You could change your measure to be "change from prior month" instead of the raw value. You could have that "change from prior month" as a separate value in the pivot table, and color-code that A different approach I've used is concatenating an icon in the formula. I showed a (not particularly…

With just 6 values (Marge/Revenue/Cost and their respective budgets), I think a visual that doesn't require interaction would be preferable to let users see measures at a glance. A bullet chart could do that, and then I would use a different series for budget vs. target to make clear you're trying to push through the…

If green is a subset of blue, I think the overlay bar is the appropriate graph. The advantage of the overlay is that even without figuring out the percent that you want, the raw values will be correct, so hovering and tips will work out of the box. The default calculation for percent_of_category isn't necessarily wrong, it…

First, I don't think that's an overlay bar, because there's no option label totals in an overlay bar. But if you were using an overlay bar, MichelleH is right that the best approach would be a BeastMode and a tooltip. It's an unusual percentage to get, but I think if you're using an overlay, I agree, it's what you want.…

The label options on boxplots make them essentially useless, IMO. You can't even position them in the correct location (i.e. median goes on the median). You could concatenate the N to the axis labels. Something like this: Disadvantage is changing the names of the series makes cross-filtering between cards dice-ier. I would…

Ideally, your data would look like this: Category Type Value Budget Planned 343 Budget Carry-over 3432 … The easiest way to get it in that format is with MagicETL. There's probably a more elegant way to do it with a dynamic unpivot, but to me, the easiest to understand is to just select the two columns, add a category…