DavidChurchman Coach

You need to aggregate shift length so the pivot table knows how to combine the cells. Wrap it in either a sum() or avg(), depending on which makes more sense for you for this case I think you might need to wrap the 8s and 10s, too

Short answer, no. Manasi suggested using text-input as the control, which is probably the easiest way for this use case. For a drop-down, once you laboriously populate the variable, it can be a pain to make sure the values you have populated for the variable on your card are the same as the ones you have in your control,…

Yup, looks better on my instance now

I see the problem with your approach. Your filter is looking for rows where the CitySelector is in the Lane, but because the CitySelector is only the Shipper_City_State, there are no rows that exist where the CitySelector is the same as the Consignee. For this approach to work, you'd need to double the length of your…

I can verify that this is happening for me, too, and that this is new behavior (and that it's annoying). As a quick 'hack' to be able to see the filtered row count, you can change the Data Preview to "sampled" with a sample size larger than your total number of rows. Then it will display the number of rows "previewed" next…

It appears logically sound. Can you give some examples of city/lane combinations that worked in your filter and ones that did not work? I suspect it's some text formatting thing. Wrapping your variables in UPPER() and TRIM() might be good, to make sure it's not a case/white space issue. If that doesn't do it, I'd need to…

One workaround on this is to use a Pivot Table instead of a Table/Mega Table. You can control which columns collapse/don't collapse by checking/unchecking the "include in subtotal" option.

HTML tables don't scroll, and pivot tables don't do HTML, so I demoed an imperfect compromise on this discussion: https://community-forums.domo.com/main/discussion/comment/95482#Comment_95482

Sadly, you can't.

Append stacks any columns that match on top of each other. If your column names don't match, they won't stack on top of each other. Table 1 Table 1 Item ID Table 1 Order ID A 1 B 2 C 3 Table 2 Table 2 Item ID Table 2 Order ID X 7 Y 8 Z 9 Table 1 appended to Table 2 Table 1 Item ID Table 1 Order ID Table 2 Item ID Table 2…

You said you want 6 lines in the output. If you have IRs A, B, C and ISOs 1, 2, 3, what would a successful join look like to you? Option A: IR ISO A B C 1 2 3 Option B: Type Code IR A IR B IR C ISO 1 ISO 2 ISO 3 Option C: Some other ID that ties the correct IR and ISO to the correct row? IR ISO U A 3 V B 2 W C 1 X A 1 Y B…

Re: Are there any other data points you'd like to see me include in these monthly posts? What about more information on ideas from the Ideas Exchange? How many have been implemented this month? How many are under review? Which users have had ideas they suggested incorporated into the product? I'd also like to incentivize…

It looks like you have a distinct set of categories for each cluster. The gap is a result of showing the null values for each category that a cluster does not contain. I count at least 15 different colors in your series, so the first cluster shows the values for all your "blues", and then 0s/nulls for all your greens and…

If you could simplify your table to two categorical dimensions, a Heatmap card (the one under Popular cards, not the Heatmap Table) can do what you're asking out of the box: Pivots data Can be easily and flexibly color coded Has Hovertext

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)…