brycec Coach

I'd imagine the schema is maintain either in the manifest.json file or in the schema of the AppDB collection. Can you find the associated collection in Asset Library > AppDB Admin and see if the schema is what it should be? If not, you can edit it there on the collection.

Something like your screenshot isn't natively supported. You can always use a brick or pro-code app to use a different charting library like D3.js. Whenever I have long data labels or y-axis values, and I don't have a date/time x-axis, I change to use a horizontal bar chart.

The appstore listing says it was last updated May 13, 2021. So, I don't think it is still being developed or maintained. However, it looks like one of the better apps they've built over the years.

You can use the option data label settings > rotate.

What is the name of the DataSet and card? Is it all cards on this DataSet that are experiencing the issue or just certain ones? I've run into issues exporting when certain characters are used in the name like brackets. Domo often has more helpful error reporting in the API response than is displayed to the user. Can you…

(CASE WHEN LAG(`Status/Stage`) OVER (PARTITION BY `Program Name`,`Deliverable`, `Billing Entity`, `Billing Month New` ORDER BY `Snapshot Date` ASC, `Billing Month New` ASC) != 'Parked Revenue' AND `Status/Stage` = 'Parked Revenue' AND `Snapshot Week Rank` = 0 THEN 'Yes' ELSE 'No' END) You'll have to add it to the Beast…

For anyone finding this thread after the fact, I got on a call with @ARutledge and was able to fix the issue by changing the following: Some of the columns in the Beast Mode were accidentally strings instead of columns. They were enclosed in single quotes instead of backticks. Program Name, Billing Entity, and Deliverable…

Sure, I'll DM you

In your initial post, you said the data was snapshotted every week. But in a recent reply, you said the data was snapshotted every day. Which is it? I've been under the assumption that it was once a week, so if that isn't true, the Beast Mode would need to be updated to reflect that. There is likely a way to achieve it in…

You would have to add Billing Entity to the partition if you want to have that in the table too. But, if that doesn't work, then maybe another solution is best. You could make a column in the DataFlow to use. And maybe you already have that and I missed it. What is the Snapshot Week Rank column?

I've never run into this issue. I just verified on several of my DataSets and they all have all Beast Modes as options. You could create a case with Domo Support. But can probably get some information via the network tab in the developer tools that could help you fix it yourself or at least inform that conversation with…

Oh, you're using a pivot table? That might be the issue. They aggregate things a lot differently and I haven't verified this specific Beast Mode on one. Can you try using a mega table?

Where are you storing the Excel spreadsheet? The answer is likely Workflows or the Product APIs, but it depends on where you are storing it and what your use case is. There are also tools like Webforms that allow you to update a spreadsheet inside of Domo that could be useful depending on who's updating it.

What is your date range filtered to? Or do you have any other filters on the card that could be filtering the values you need out?

Kind of, but not really. Directly as you stated, it isn't possible unless you do what you said, make a color rule for every user then every page. However, if the business unit column shows up in that drill path, it will be colored. So, you could keep the user/page as your x- or y-axis value but add the business unit as the…

There should be yes's to select. Sometimes with window functions you have to save the card so that the Beast Mode saves, then refresh and see if you can select them then. If they still aren't there, something else needs to be adjusted.

@tpfeiffer54 not at the moment. You can make an HTML link using an a tag and add the target="_blank" property to it, which is what I've been doing forever. But using this new feature that doesn't require a Beast Mode and writing HTML, there isn't a way for it to open in a new tab.

Oh lol, I put Status/Stage then Stage/Status. Just adjust the second reference to be Status/Stage.

Is the key for the column also called "Region"? Or did you set the key as "region"? If you don't remember, you can view it here: https://<instance>.domo.com/admin/governance/attribute-management

What is the date column for when your snapshot occurred called? I just put Snapshot Date as an assumption, but yours isn't called that probably.

(CASE WHEN LAG(`Status/Stage`) OVER (PARTITION BY `<unique_identifier>` ORDER BY `Snapshot Date` ASC) != 'Parked Revenue' AND `Stage/Status` = 'Parked Revenue' THEN 'Yes' ELSE 'No' END) Add this Beast Mode as a filter, and select Yes. Make sure to replace the unique_identifier field with whatever your unique identifier is…

I'm not sure I understand your goal. What do you want the final table to look like and be grouped by?

In your Beast Mode, your condition has Snapshot Week Rank = 1 AND Snapshot Week Rank = 0, which cannot both be true at the same. The same is happening to the Status/Stage condition. For week over week, you can use a Period Over Period chart type, change the graph by period to week, and compare week over week.…

Are you on consumption? If you are, it is included at no extra cost. If you have consumption but it says request a quote, that just means they didn't put it in your contract. So, you'll have to contact your CSM or AE and ask for access, and they might have you sign a $0 amendment to add it. If you are on the user model, I…

If you use a Pro-Code App, you can use React and find a component library that makes things a lot quicker and easier to build. I'd recommend React Hook Forms, AWS Amplify, Chakra UI, React Bootstrap, or Material UI for starters. AWS Amplify also has a way to build forms without code, then import it into React and modify as…

This isn't supported at the moment, so it would be best to submit an idea to the Ideas Exchange if one doesn't already exist. For workarounds, you could use a Brick or Pro-Code App to achieve this. Documentation for those can be found here: Domo Developer - Apps Overview.

Yeah, the only way you are going to get this is by using a DDX Brick or a Pro-Code App. As far as templates, React typically has the most templates that are the easiest to implement into Domo, so I would go for a Pro-Code App built in React. You can find millions of templates online. Here is a great library from Atlassian…

Have you looked into the Domo Finance App yet? Domo Finance | Implementation Guide. It includes a great P&L report that is probably what you're looking for. You will probably have to prep it a bit in a DataFlow or Views Explorer, especially for your margin columns.

You're looking for the value domo.policy.managed_email_address as referenced here: PDP Automation

If you give them the manage all DataSets grant via a role, that will show all DataSets to them and allow them to edit all of them.