-
Allow differential shading between multiple sub-total fields in Pivot Table
Domo allows multiple sub-totals in Pivot tables depending on how many dimensions are thrown in. In my example, I have Daily, Weekly, Monthly, and Overall, where Daily is the lowest granularity, Overall is the Total, and thus Weekly and Monthly are both sub-total fields. Monthly is a higher level than weekly, but the…
-
Is there a DOMOStat that shows what users have access to what Pages/apps?
Hi, I am wondering if there is a domostat connector that shows what users have access to what pages/apps? Thanks!
-
Using Partition by with Count
Hi, I have this beastmode that is taking the % of people over $1000 in revenue and dividing it by the total # of people. It behaves correctly when I have only one terminal selected, however it shoots up to 350% when no terminal is selected. What is causing this? I tried removing the Partition by in the count distinct but…
-
Folder structure for dashboards and apps
Working with a team within domo, it becomes tedious to scroll through the "Shared" tab for apps or dashboards to find visualizations we use within the organization and across departments. It would be great to have a folder structure within the shared folders where team members can organize work. This would be great for…
-
Quick toggle to exclude "Today"
In a report set for "last 7 days", Domo will automatically include the current date if your dataset has rows representing that date. I have many datasets with rows for the future, where the data isn't filled in yet. In order to get today's date to be suppressed in the report, I have to write a Beast Mode: case when `Date…
-
How to link Microsoft teams to workflows
-
JSON Connector - File without extension
Hi everyone, I need to connect with a EndPoint that has an specific Id, domina,, viewId and apikey. I have tried out many Json connector without any luck Is there any specific connector that I can use considering the following parameters? EndPoint id domain viewId apiKey
-
Switch Order of Period over Period Chart
I'm afraid the answer is no - but is it possible to switch the order of a Period over Period Chart? I want "Year to date" on the far left, followed by 1 year ago, 2 years ago, 3 years ago.
-
Add Distinct Count to Summary Number
It would be nice if Count Distinct was an option in the Summary Number aggregation options to quickly show a distinct count. Right now, I have to create a beast mode for this number to show up in the Summary Number choices. It would be a nice timesaver if it was a built in aggregation choice.
-
sendEmail Function via API
Hi Team. I'm using this method: With the below details from postman (replaced inputs{} for this question) ``` POST https://{company}.domo.com/api/codeengine/v2/packages/{package_id_found_in_url}/versions/{version_integers}/functions/sendEmail Authorization: Token (generated via Admin > Access Tokens) body (JSON) {…
-
Rank by Sum of Style then Compare Rank to total
Hi, I have transactional data over periods of time. Data includes dates and time periods as well as SKUs and Net sales. I want to be able to dynamically rank SKUs based on net sales to create a top 10 group and then compare that group to the total sales for the category. Trying this but I don't want the SKUs in my report…
-
How to resolve CORS error while using Product API's?
{ "method": "POST", "url": "https://my-instance.domo.com/api/ai/v1/text/generation", "headers": { "X-DOMO-Developer-Token": "generated from Admin>Auth..>access token", "Content-Type": "application/json" }, "body": { "input": "why is sky blue?" } } Above is the request I sent but getting CORS error like below Access to…
-
New ETL Tile
It would be great to see an etl tile which can be placed before outputs of ETL which give the option to set different update frequencies for different outputs of the same ETLs.
-
How do I avoid decimals from being truncated while bringing data from Excel?
I have an Excel that has several measures that are percentages. The Excel is in a Box folder, so I am using the Box connector to bring the data to a Domo dataset. Everything works fine, except that the percentages get converted to decimal numbers (so, all are <1) and truncated to 2 decimals... so that is causing me issues…
-
Is there a creative way to adjust the decimal places on a progress bar?
I have this progress bar that is showing two places past the decimal. There are no chart properties to allow for adjusting this. Is there a beast mode or some other method I could use to get this to round?
-
Extract multiple sets of numbers from a single string
I am trying to extract two different sets of numbers from a string. I have tried substring and Regexp, but to no avail. Examples of the stringss- Possible string format #1 Company Name - 2024-07-01-2024-07-31 - GPPC - YTUBE - VYT - 63784 - 2782837 - 458573682 - [745-000121-003] Possible string format #2 Company Name -…
-
Beastmode to flag an item if the date is longer than a week from the current date.
Hello, I am trying to write a beastmode to 'FLAG' and item if the submission date is longer than a week from the current date. How would I proceed? See below for my current beastmode that flags something if it does not fall into the current week of the current date. My thought process is if the date is longer than the…
-
How do I make a Domo to Power BI Connection with Microsoft Authentication or Okta SSO and not ROPC?
Using the connector on the left requires an ROPC verification type which asks for the users Password. Our security requires that we work through a redirect with SSO and a token is passed back so passwords are only entered in one area. I believe the MSAL connector on the right should fill that criteria but it is still…
-
Managed attribute can't be edited or deleted
I'm getting "Attribute definition failed to be deleted" when trying to delete a managed attribute and an unspecified Error when trying to edit it. I can get to the edit modal, but it throws the error when I try to save my changes. This attribute was previously used in two PDPs, but I've now deleted the PDPs. In the…
-
Efficient Way to Rollover Filters with New Month
I have a dashboard with monthly volumes by service line. In order to only show the prior month that is closed, I manually set a filter to the prior month. Instead of going through each card and updating this filter manually to the next month (current state), is there a way to automate this rollover? Or perhaps have a…
-
Dashboards Filter API Behavior Discrepancy with App Studio (Removing filters)
I'm encountering an issue with the domo.filterContainer() API in Domo App Studio. When I apply filters (Custom filter brick) using this API within my app, they work as expected. However, when I clear the filters using the UI (e.g., by clicking a "Clear All" button or removing individual filter selections), the filters are…
-
PostgreSQL Connector vs Postgres Federated SSL Error
I have two accounts setup: the native PostgreSQL Connector the Federated PostgreSQL connector I can successfully query and retrieve data from the Federated PostgreSQL connector but when I put the same credentials into the native PostgreSQL Connector and try to run a custom query against it, I get the error: Error setting…
-
Is there a list of API or endpoints to use in code engine?
I recently got a requirement to get the images of a card, someone from DOMO gave a function to get the card images as pdf, if there is any list of endpoints or API's listed in any documentation it will be helpful to create our own code Engine functions. please let me know if there are any documentations available for this.
-
Using Average on Beast Mode
I want to calculate the average number of semesters that students with bachelor's degrees have completed. Below is my Beast Mode calculation. However, it currently counts all semesters (or terms) a student has attended, even if they pursued additional degrees after earning their bachelor's. I only want to count the…
-
Export data from DOMO to Google Sheets on Schedule
Hello! I imported data from Snowflake using federated dataset to DOMO. Now I wish I can export this dataset to Google Sheets. I've tried Add-on, it partially works but it can't automatically run on schedule. I've also tried to use Magic ETL to writeback data but I can't get access to the API so it doesn't work. Can anybody…
-
How do you join a federated dataset with a cloud amplifier dataset from Snowflake?
-
Do we have any API for creating a SQL Dataflow in DOMO through python?
I am working on SQL transformations within Domo and have a requirement to create a SQL dataflow programmatically from a code engine using a Python script via the API. Does Domo provide any API support for creating dataflows?
-
Clearer form submission confirmation
Currently, when a user fills out our form, a small green dialog box appears in the bottom left corner, but it’s easily missed. As a result, many users end up submitting the form twice. Could we implement a more prominent confirmation page or popup to clearly signal that the submission was successful?
-
Running Into Error with BeastMode and Table
I'm working on a beastmode where I am trying to assign a label to individual orders based on their price_tier and their Product Name. If an order's price_tier is equal to the MAX of the price_tier for a Product Name, I want it labeled "Sold". If an order's price tier is less than the max, I want it labeled "Discount". And…
-
Creating an HMAC and pushing data to a JSON Webhook connector with a secret applied
It can be a little confusing when trying to setup the JSON Webhook connector with a secret applied and push data successfully. The biggest hurdle can often be creating the HMAC to pass in through the header. Depending on the source that you're pushing from or what programming language you're using will change the setup…