brycec Contributor

Probably won't be much help, since it is not the SDK and you already tried just adding "type", but here it is as cURL generated from my HTTP Postman request: curl --location 'https://<instance>.domo.com/api/query/v1/data-control/<datasetIid>/filter-groups' \ --data '{ "name": "Pod Owners", "dataSourceId": "<datasetIid>",…

Not that I can find anywhere unfortunately. Domo isn't great at documentation, especially with newer features.

Do you mean User Management in the Governance Toolkit? If so, passwords are not controlled by the configuration DataSet, so your existing users would keep their password. Additionally, there is an option when setting up the toolkit job to "send invite". If you check this, it will send new users an email inviting them to…

Using the Product API for AI Services Layer instead, I know the endpoint to list models for a certain use case (e.g., text-to-sql) is https://<your_instance>.domo.com/api/ai/v1/settings/services/sql/models. That being said, you may be able to use that same endpoint in the App Framework API you are using, likely…

Not exactly sure, because I ever use R. But the object keys are almost identical to using the Product API endpoint https://<your_instance>.domo.com/api/query/v1/data-control/<dataset_id>/filter-groups. For that, a "type" key is used with a value of "DYNAMIC" to achieve the result you are looking for. I'd trying adding and…

What you might be looking for is Page Drill functionality. If that isn't, you could explore hyperlinks instead of a literal drill, and then use pfilters. PS: despite that documentation for pfilters being about embedded content, they work on both dashboards and cards that are not embedded.

I had a similar problem in which I wanted to track vacation and sick time accrual for our employees. I needed to show the balance as a running total without it losing any history and becoming inaccurate due to date range filtering. The solution that worked in this case was to change my leave transaction DataSet from row =…

You want to use a FIXED function. SUM(MAX(`Facebook Spend By Day`) FIXED (BY `Date`))

If you are building a Domo app (pro-code or brick), then you will likely need to use one of Domo's SDKs and this authentication hack won't work. But, to use the X-DOMO-Developer-Token header, you simply add a header to your API request key: X-DOMO-Developer-Token, value: <your_access_token>. You can generate an access…

Weird. Might be a bug then. I would reach out to Domo Support.

I believe what you are looking for didn't exist, until the latest feature update at the end of January. It should now be built-in and possible. Current Release Notes - Workflows: Initialize Variables

I'm not sure how you would download files from Domo. But if you just mean get the data from an Excel or other file in that folder and put it in a DataSet, that is possible. We usually use the report "File Download" on the SharePoint connector in Domo, enter the exact Site ID, then putting in the file path to that folder.

Do you have a sandbox instance? Adding a DataSet to a sandbox instance requires it to have PDP rules enabled, even if you just set it up to give all rows access to anyone with DataSet access. Otherwise, you could just go to the PDP tab of the DataSet and turn off the PDP if you don't want it.

You can use the DomoStats People report as a DataSet to get a user's last login timestamp. Then, you can use the built in Code Engine function DOMO Users > deleteUser.

You can use the Utility > Add formula tile to achieve this. Put it just before your append tile on the line coming from your new data. Name the column, something like snapshot date, then put the formula as CURRENT_DATE().

Which API are you using and how are you authenticating? You should be able to use the Product API endpoint for Code Engine and use the X_DOMO_DEVELOPER header to authenticate with an access token.

I'm not aware of any limits on that API, but it certainly could have some. More likely, Postman is unable to handle that large of a response, and that is why it crashes. I'd suggest trying some other API endpoints, like query in the same API you are using. Or you could use the Product API endpoints of export to S3, query,…

I believe you are looking for the Card Permissions report on the DomoStats connector. DomoStats

CASE statements are exclusive, so once it finds an option that is true, it exits and doesn't evaluate other options. Not sure really how to explain it better, but I do have the solution. This is what variables are for! :) They are wonderful honestly. Create a variable that has your options of YTD and MTD, then create a…

@MrDeanoB Any chance you figured this out? I am looking to achieve the same thing and have had no luck so far.

If it is pulling the same date for every row, it sounds like you aren't grouping on the correct columns. What columns are you grouping on? You'll want to group in a way that identifies the unique row that you want the date aggregated for.

First thing I noticed, you don't want to have DAYOFMONTH in the check for Last Year, because comparing less than or equal to would mean you skip 05-2023 through 12-2023. Second, I would suggest splitting out your calculation into different formulas or even different tiles. So, I would first calculate your max date in a…

This should be achievable. What is your Beast Mode formula right now?

Are you saying your date is stored as a string/text column and not of date data type? If so, you'll need to use the function STR_TO_DATE() to convert the column to a date first, then you can use the other Beast Mode I sent.

You'll want to use the data repair feature. Add this exact string to the end of the URL of the DataSet: ?_f=dataRepair Then, you'll now have a new tab on the DataSet called Data Repair. Navigate to it. Now, you should have all the tools and options to do what you need. It'll let you delete updates, replace updates with a…

You can use Domo's undocumented public API for this. To authenticate to it, create an access token from these instructions: Use that token as the value for the header X-DOMO-Developer-Token when sending your API request. To find the right endpoint, required parameters, etc. just open up the network developer console in…

This is supported by Domo Everywhere. Under the Private Embed section of this page should provide what you're looking for.

Is the problem you're running into that it's aggregated on the card but you don't want it aggregated on the drill? If so, you can create a DataSet using a DataFlow that aggregates the values for the card, then use a different DataSet that's not aggregated for the drill. I'm probably not understanding the problem well. Feel…

I don't think so, but maybe someone else knows better than I do. Domo only allows one aggregation level, and two when using FIXED. You can try to change the options for that column at the top (where you normally format the value), and see if you can change the total option to SUM. But, I'd assume that would cause three…

Sounds like the Domo connector was probably built poorly and doesn't include it. I'd suggest using the JSON No Code OAuth connector and just using AirTable's API to build a request yourself. You can test the API in Domo or in a tool like Postman first to see if the URL field returns correctly.