-
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?
I am looking for a way to easily identify recursive flows. Is there anything in lineage that would quickly identify recursive flows? The only way I have found to verify is to individually go through each input and output to check and see. Is there any feature that tags which flows are recursive?
-
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)…
-
Workflows to check Dataflow executions
Hello. I've been trying to use the "Get Dataflow Execution Status" and "Was Last DataFlow Run Successful" functions, but I'm getting weird results. I purposely created a dataflow that always fails: Then I test these functions on the workflow editor I get a "FAILURE" and "false" responses (see images). However, once I…
-
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…
-
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…
-
App Studio Controls/Filters
While creating apps with multiple pages/tabs we don't often use the same dataset for each card we put on a dashboard (app in this case, woohoo for app studio!) Where we are running into trouble here is that page filters only have the option to select a singular dataset rather than all datasets where the field is present.…
-
YouTube Connectors Using YouTube Account Username and Password
Hi Domo Dojo Community, I've been setting up some test YouTube Connectors in my Domo account. I'm using the Username/Password of the YouTube account to make the connection. So far, no data has come in and its been several weeks. Are there other barriers or settings which I can investigate in order to successfully connect?…
-
How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
I am using the Domo workbench to import data that includes two fields, OrderDate and TransactionDate, which are in date/time format. My goal is to import these date/time values exactly as they are, without any modifications or timezone shifts. For example, if the OrderDate is 8/26/2024 9:00:49 AM, I want it to be imported…
-
Grand Total to Show as Average instead of Sum
I'm trying to get my Grand Total for Revenue as an example to show as an average instead of a sum in a Mega Table. My Revenue calc is below. SUM (CASE WHEN (`Source` = 'Order Items' AND `OrderItems.Type` = 'SpaceOrder' AND `Rank_DateRunOrderItems` = 1) AND `Reservation.State` != 'Canceled' AND `Enterprise.Name` IS NOT NULL…
-
Making Users Watch Mandatory Videos
Hi, Im not sure if this is possible within DOMO but has anyone set up their instance where users have to watch a video or two in order to gain access to content? I am trying to create training videos that is required to watch before being able to use DOMO. Any advice would be great!
-
Is it possible for a WorkFlow to update a column during Various Users Tasks?
I'm developing a WorkFlow Process that has a few user-based tasks. The workflow is triggered by the addition of a Form Submission that will update a Dataset. As the Workflow progresses (users approve tasks), I would like to have a service automatically update the status in the original Form Dataset that will be used for…
-
How to identify workflow initiator
I have numerous use cases where when a user initiates a workflow they will need to be sent a notification email, eg after an approval action, "Your request has been approved/rejected" or validating* a form input, "The email address is incorrect, Stuff@stuff is not valid". The only way I can see to do this is to have a…
-
Best practice for using the same dataset for different projects
So my team has a Sales dataset that is being used to make a Sales App, this dataset has variables, BeastMode calculated fields that use those variables, and these BeastMode were saved to the dataset when created. Now I'm making a new app that also using the same Dataset, however, I'll need to create different Beastmode…