DavidChurchman Coach

I've noticed when using a variable in the smart text, it will only appear in the title if something besides the default for the variable is selected. So, if the available values are "A", "B", and "C", with a default of "A", it will only appear in the title when "B" or "C" are selected. Not ideal behavior.

No, that warning did not appear. Even when I click around in the different parts of the app to edit, it does not appear. I also tried making the tab container bigger and smaller, which is the sort of thing that triggers that warning in a standard page, and still not get the warning. I do get that warning on other apps…

I saw the same thing with an App that had a large tab container. I did get it to work with an App made up of all discrete cards. But the export had massive left and right margins, making the PDF basically unusable. Portrait option would be great, as would the ability to allow for taller objects.

Interesting… I see a lot of great engagement on the Slack. It also seems like a lot of the help requests have shifted to Slack. I wonder in the long run if that will make it harder for people to Google answers to questions that have already been asked.

One thing you can play with is you can get images in the Summary Number the same way you can get them in an HTML table. You could play with changing the summary number to an image when a certain value is selected and null out the data, and the opposite when the other value is selected.

To add to Mark's answer, in the Filter tile, there are two options. One is to use a filter rule, which is what you have in your screengrab. The other is to filter using a formula, which is where you'd use Mark's formula. Little hard to see at the bottom, so wanted to make sure you saw that.

Aggregating different fixed functions is tricky. Can you mock up a spreadsheet with the same structure as your data before the BeastModes so we can get a better sense of what each of those individual BeastModes is doing?

Have you looked into Variables? That allows for user input that's used in BeastModes:

Okay, another thought is Mark's approach to splitting and pivoting is pretty computationally inefficient because of the huge join, which is probably why it takes 45 seconds. (It's also very clever within the restrictions of MagicETL, so no shade on Mark). If you could get that time down, you could still use the data in its…

You could "Submit a Product Idea", which would allow people to upvote this. While you hold your breath and wait for them to build that, some other possible approaches: Domo lets you build a custom chart, where you basically just need an SVG file, and then you can shade in different sections based on the data. So you could…

Is what the viewer sees the same as screencap 2 or is it some summary of screencap 2? If it's a summary, I wonder if there's a way of getting to the same summary without restructuring the data? Depending on how many items you have, you may be able to use BeastModes to count if the item contains the value. Or if it doesn't…

You can get pretty close to your report's format with just a default pivot table and a BeastMode: Here's what it looks like exported to Excel: Note that the header color was maintained. Color rules applied to the values will also export to Excel. The name of the file will be the same as the name of the card, so you can…

Sorry, I was imagining a somewhat more manual process than what @ArborRose is suggesting with WorkFlows, which sounds cool. What I was trying to say: create a copy of that card with the URL for each page, and in the Analyzer, apply a filter for the dashboard the card sits on. It's not automatic, but is basically two steps:…

Try the 'Pages and Cards' report from the 'Domo Governance' datasets. That has the Page ID, Page Title, and Card ID of every page in your instance. From that, you could create a BeastMode that has the URL of every page. Then, you could use a card filter for whatever page you're on, so it only shows the URL for the current…

By duplicated, do you mean the title appears both at the top of the card and as the hover-text? If you don't want that hover-text to appear, than you disable the actions for the card, but you may not want to do that, if you want cross-filtering to work. If you want to leverage the hover-text or make it appear less…

Agree with @GrantSmith. Also worth noting that it's possible to see the Embed IDs already created for a dashboard in the admin console.

@verytiredgirl had a very similar question recently, and I posted essentially the same solution as @MichelleH on this thread. @chetan_cricut there are some screenshots on that response that might help you understand what to do with the BeastMode (save on card and use as card filter) vs. the Variable (reference in the…

It sounds like you are trying to get 3 lines on top bars that are broken up into stacks of three? Besides being visually very busy, I'm afraid the lines would be difficult to interpret. A stacked bar is common practice, but with the lines, you'd either have to treat them as stacked, which would go against how lines are…

A BeastMode approach would be to change your FinData to be negative for expenses and positive for revenue. Then you could use the table's built in Total row, which has the advantage of being dynamic with filtering. CASE WHEN Account Type = 'Revenue' THEN FinData ELSE -1 * FinData END

The easiest thing would be to use a Slicer filter instead of a Radio filter, which gives options to select multiple or select all. But, a more literal answer to your original request is using a variable: Create a variable (let's call it channel_variable, with the possible values of 'Facebook', 'Instagram', 'TikTok',…

Assuming data like this: Note, I added a Group to make it easier to apply your color rules, and I joined "Revenue last week" to each row to make it easier to calculate the delta from last week. You could create something like this in a pivot table, plus color rules and formatting: Note that the category names don't repeat…

I like your solution. I think what I would have done (not necessarily better), is filter two datasets, one for Products one for Sales, find row number for both, and join on row number. P

It's a little unclear what you're asking for. I tested your code after changing the directory to '/home/domo' and was able to search for strings within all my Jupyter notebooks in a workspace. Are you wanting to search across workspaces? Or what problem are you running into with your code?

Spark Line chart does most of that. It has icons, current value, and percentage change:

Oh, got it. I didn't realize it was only in App Studio. I see it there, but not on standard pages.

The only column these two tables have in common is "Product", so I'm assuming you can tell what the "Branch" is based on the product. If that's true, I would take the "Product' and "Branch" columns from the first table and join them onto the second table using Product as the join key. Then, you could filter your new table…

I'm not seeing the "contains" option on page filters. Anyone else seeing it?

Do you have a Date Format applied to the column? I was able to reproduce this by applying a bad date format:

Create a branch, filter for Date = Today() Rename HC to "Current HC"; drop Date column and any other redundant columns you don't need to rejoin the data Join the "Current HC" back to the rest of the data. I just joined on country with my simplified data, but depending on your granularity, you'll need to join back based on…

Okay, add a Formula tile in the Magic ETL to calculate Diff before the dynamic Unpivot. Granularity of the data won't change the process. You'll determine the granularity based on the combination of your rows/columns.