-
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…
-
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…
-
Search the Dataset amongst all the available datasets
Hello, I would like to search the datasets (amongst many datasets) that uses Aggregate functions (Such as count or sum). Please help me with the steps.
-
How Do I Resolve This Error: ERROR:Dataset row count does not match. Expected: 0, actual: 4899545
I removed some data (Deleted dataset updates back to 2/15) and am running an APPEND job, but getting this error, how do I resolve? The Domo server reported an error while performing analysis: 'ERROR:Dataset row count does not match. Expected: 0, actual: 4899545.
-
Is there a way to identify recursive flows?
Is there a way to identify which flows are recursive in smart ETL? If I look in the lineage I cannot see any flag or notation that a flow is recursive. Does anyone have a way to quickly identify which flows are recursive besides opening them up and looking at the input and output tiles? Thanks!
-
Microsoft SharePoint Online Rest Connector - Download all files in a folder
I've gotten the Microsoft SharePoint Online Rest Connector connected in our Domo instance and have been succesful pulling in individual file contents using the "Download Item Contents" report option. However, we have a sharepoint folder where users will drop multiple files, and I need to bring the contents of all of these…
-
Do we have any API for SQL dataflows creation 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?
-
Do we have any API for creating a
-
Converting Decimal Format to Days, Hour, minute format
I'm trying to convert these DATEDIF values from this format that outputs "3.36 days" to the format that reads "3 days, 8 hours, 38 minutes". I would need to be able to average them out too so I don't think a CONCAT function would work. Where should I start?
-
How can I utilize double case statements in a beastmode
I want to create a beastmode where it calculates something like the below: when segment = A then calculate the amount moved from A to B when segment = B then calculate the amount moved from B to A (image below) How can I calculate this using the beastmode functions?
-
Why is Domo Support on my PDPs?
I'm finding Domo Support listed on many of my PDPs. Why would this be? Should I remove them?
-
Good Names for Domo Super User Group??
Hi Domos! We are scaling effectively and I'm kicking off our first "Super User" group to help grow the team of capable users. Tapping into the collective brilliance of this community - what's a fun name for our super user group?? Bonus points if there's some play on words regarding: Vance Thompson Vision (our company)…
-
Help figuring out how to get a data set to work with a funnel
For context the data set image linked is a representation of the data I am working with to protect our real customer data. I do not have the ability to reformat the data coming in, only use magic ETL and SQL transformations to convert this data into the format it needs to be in. I can not find a way to make the funnels…
-
Grand total of pivot table
I have a beast mode that is taking sales and dividing by number of chairs*number of locations. It looks good at the detail level but the total level is just summing rather than taking the total number of sales and dividing it by the total number of chairs. TY net sales is a sum of sales where a flag = Ty Number of stores…
-
Option to hide appendix from scheduled reports
The ability to choose to hide or unhide an appendix from dashboard scheduled reports. Also, thinking ahead to Report Builder, the same functionality - hide appendix from reports.
-
Ability to Use the Secondary Email when Adding User to a Group
Often users provide a secondary email address in the their Domo profile, which they prefer to use for certain alerts and scheduled reports. Currently, it is not possible to add a user's secondary email address to a group. One possible workaround is to add the email individually to a scheduled report, but this makes it…
-
Card Size Sliders won't go away????
Hi Community, I've never experienced this before and now sure what happened to cause it. See screenshot below - but all of the "dividers" / borders of cards are still present even though I deleted the cards. How can I get rid of these ghost borders?
-
Are workflows not supported by embedded links?
I am trying to Create a workflow for a form that I am looking to send to our customers. I have created a workflow and added it to app studios. But when i go and check on my embedded link it shows the card outline but doesnt show the workflow form that is on it in my instance. Are workflows not compatible with embedded…
-
Future Date Filter
Hi, I have an App Studio app that I would like to add a quick future date filter to. This is similar to the presets in the Date Slicer Filter, but I want to allow users to select Week to Go, Month to Go, Next 2 Months, Year to Go, etc. I considered using a Beast Mode, but "Week to Go" would not be included in "Month to Go"…
-
How to create a custom roleto edit cards/dashboards, but only view (not edit) dataflows and datasets
I want to grant some users access to maintain and update their dashboards, and the ability to view the datasets and dataflows. I don't want these users to edit the dataflows or datasets because they feed several other dataflows and dashboards, but in the edit role data grants, I only see "Manage" or "Edit", no "View" level…
-
Year-over-Year Sales Unit Comparison
This comprehensive report is crucial for businesses aiming to track performance and make informed decisions. By comparing sales units from the current period against the same period last year, stakeholders can gauge the effectiveness of their strategies, identify trends, and adjust operations to enhance profitability. The…