DavidChurchman Coach

Nothing wrong with Colemen's formula, but since you already created a table that you joined on your start dates, you should be able to use that same table and join it a second time to your end dates. Also, for a BeastMode friendly formula approach, you could leverage the WEEKDAY function, which returns 1 for Sunday, 2 for…

You can't do it with HTML tags, but you could play with concatenating white space to the front of the summary number if you have a fixed width card.

Agree with chart title formatting. FYI: @JasonAltenburg you can format summary numbers using HTML tags: KB article:

For the card not to even update in the Analyzer, I would guess that it's not actually being fed by the same dataset, just one with the same name. When you click the down arrow next to the dataset and select "Change Dataset", is there more than one option with that name? My hypothesis: someone was working on the MagicETL,…

There is a DomoStats for Workflows.

It looks like Delivered Margin Define is coming from a different BeastMode. What does that BeastMode look like? It is probably the culprit.

Ah, I didn't test role changes. In the DomoStats Activity log, you can see "CHANGED_ROLE" and the "Object_ID" corresponds to the person whose role was changed. You can join that to the People DomoStats to see the person and their current role, but not what the role was changed from, which I'm guess is what you're after? If…

In the "Activity Log" report from DomoStats, I don't get that exact field, but all of the information contained in that field are in it, split across columns. You could probably recreate that field without too much trouble: CONCAT(`Name`, ' ' , lower(`Action`), ' ', case when Object_Type = 'DATA_APP_VIEW' then 'app' … end,…

Jay.p is talking about clicking/unclicking the legend to filter the card. I also see this behavior when viewing the "detailed" version of the card (not just on bubble charts, either). If people are looking at this card in the "detailed view", you could add your series as a "quick filter", which will always appear in that…

Agreed. Here's the same idea, with a comment from Domo that it is in the backlog (over a year ago). Add some votes to that idea, too, to bump it, as well as this one.…

I like ArborRose's regex for cleaning the notes, but then the second part seems too manual, especially if you have a large number of company names. If you have a list of clean names, you could join with an expression to see if those clean names are like the clean notes. WHEN clean_notes LIKE concat('%', clean_names, '%')…

A little clunkier than multi-select on a filter, but you could achieve this with multiple variable controls. Let's say you want them to be able to select up to 3 Job types, you'd create 3 variables: selection_1 selection_2 selection_3 Then create a BeastMode that references the variables and use that BeastMode as your card…

I don't think you can control the color of the variance lines, since it's not a series or variable, but something calculated on the backend. If you used the Symbols+Bar type, you could change your starting symbol and use the color rules, but it wouldn't calculate variance for you. You'd have to figure out how to calculate…

Glad it helped. One note of caution: the problem with using BeastMode rather than ETL to force your data wide is it doesn't actually change structure of the data, just relabels it. Prior year data are still on different rows than current years. So if you try to do anything with your date variable, like filter it or…

I think I'm going to suggest something similar (identical?) to GrantSmith, but maybe easier because instead of flexible periods, it's just YoY. Instead of a long dataset feeding your card that has all of your dates on top of each other, you can restructure your data to use just this year's data, with additional columns for…

Yes! I think this problem is compounded by the fact that you can't control the organization of App Studio Apps, so the only thing you have is the name, and the name has to be super-short, so it would be difficult to add a descriptive prefix to apps you wanted to be grouped together. This was my idea coming at the same…

I'd add that the low display resolution on text cards makes them hard to read, as does the default font option. When exported as PPT/PDF, they're especially hard to read and ugly.

You could pivot your data to be longer, and make the "column" field be your metric name. Filter for non-blank values and your column headers will be dynamic to what data is available.

Bumping this, because the email function is now live, but I'm curious about additional export options

IMO ideally you should not use to color to encode a variable with more than 5-6 options, and even in your 8 question example, it looks like you have around 20ish response choices? To give good feedback, it would be helpful to know what you want the user to get out of this chart. I'll give some suggestions based on what you…

There's a checkbox to apply the color rules to totals and subtotals in the "general" section of chart properties:

This is something that comes up in the forum all the time, and I've seen multiple ideas posted about it. Posting it again will probably help, but also comment/upvote these. These were just the ones I could find with a quick search. If there are others, please add them in the comments

Oh, I didn't know that shortcut! I usually just Google something like "unicode triangle down" and copy/paste from the web… inefficient but effective

There's an idea you should upvote to make this easier: https://community-forums.domo.com/main/discussion/56705/scroll-bar-in-bar-charts?utm_source=community-search&utm_medium=organic-search&utm_term=scroll+bar+chart And a similar conversation:

To get an answer, I recommend you break up this question and ask just the first part. If you're still stuck after that, ask the next part. There's a lot going on and it's not clear what you're asking. At the end of your question, it seems like you're asking about why your sums aren't aligned 38K vs. 34K. I'm not sure how…

I feel like there's an idea requesting folder-style organization about once a month (whether it's for datasets, dataflows, apps, pages, etc.). Below I'm listing some of those that are most similar to your idea to show that even though most of these only have a few votes, collectively they show it is a big enough issue that…

More built in options are always nice, but this can also be achieved using a BeastMode in the sort

I count 6 of these: ( and 7 of these: ) If that's not it, then can you give more details about what's not working? Is the formula validating, but not giving the expected result? Or is it not validating at all?

Most of the idea links go to the wrong idea

You need to write a BeastMode for your Y-axis to format it all as percentages. It will probably be something like: sum(Aloc..)/Sum(SUM(Aloc..) FIXED())