brycec Domo Employee

Did you add the proxyId to the manifest.json?

@AjaX22, you are correct that Product APIs can be used inside of Code Engine. However, they cannot be used inside of Bricks and Pro Code Apps. Those require the App Framework APIs, a third type of Domo API. However, you can just use the App Framework API for Code Engine or Workflows to call a Code Engine function that then…

My Postman collection that @MarkSnodgrass linked is for the Product APIs. You are using the OAuth API. While the Product API is more powerful, in the case of Project and Tasks, the OAuth API likely has equivalent functionality. However, I am also unable to make this request work. So, you can put in a ticket to Domo…

When was the last time you tried this? I just found out they weren't working in app components but a fix for that was pushed out last week on Thursday.

Sorry, I didn't realize the function you were using was the same one in the idea. The function I suggested was written in JavaScript. You are using Python. I am less familiar with writing Code Engine functions in Python. But from what I can tell, the codeengine.request method is only for JavaScript. For Python, you want to…

Are you doing this request in Code Engine? If so, you have to use the codeengine.sendRequest method. Also, in my original comment, I wrote a function for getting tags, which is a GET request. But the link you sent is for creating tags, which is a POST request. In your code, you are using GET but with a body of an empty…

You can use the new beta feature FileSets. Then you can reference then whenever you want via this URL: https://<instance>.domo.com/api/files/v1/filesets/<fileset_id>/files/<file_id>/download

This really should be updated. But you can technically copy it, even though it is very unintuitive. Just click and drag your mouse from the beginning of the file to the end, then ctrl + c or cmd + c for mac.

That's not supported in that package in the current implementation. You can create an idea in the Ideas Exchange if that's something you would like added. If you want to instead create your own Code Engine function to achieve that, you can using the following: const codeengine = require('codeengine') async function…

I am running into the exact same error. I assume you are using the Group By tile when this occurs, not the Add Formula tile? I cannot tell from your screenshots because of how they are cropped. I ask because the Add Formula tile doesn't support aggregation functions, which MIN is. But when I tried that, it gave me the…

What do you mean by "index" exactly? I don't understand how you are using that term. In regards to the formula you tried, I find that Beast Mode editor doesn't like it when you use non-windowed aggregation functions with windowed aggregation functions. So, you might have to try something like this: (…

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