-
Magic ETL Preview Single Tile / Run to Here
One of the biggest gaps in Magic ETL vs SQL dataflows in not being able to just run a preview of a single tile. I also wish we had the Run to Here option. For example, maybe I only want to run a series of tiles from a particular input dataset before it is joined to another dataset. The point is that it is inefficient and…
-
Import App Pages
In App Studio when you go to page to import there is an option to import app pages. When I select this, only the Apps are available for selection and not the pages within the Apps. I think this is a bug and should allow for import of the pages within other Apps. Is anyone else having this same issue?
-
Removing leading zeros from PO_Number, (using OPENQUERY)
I've tried the following 3 things to remove the leading zeros from PO_Number, (using OPENQUERY) in the workbench without success, any other suggestions please? Using CAST and LTRIM: SELECT * FROM OPENQUERY(ACME_CO_PRD, 'SELECT LTRIM(CAST(CAST(fd.PO_NO AS INT) AS VARCHAR)) AS PO_No, 2. Using PATINDEX and SUBSTRING: SELECT *…
-
Bulk Filter Paste For App Studio
A couple months ago DOMO launched a bulk copy+paste filter function for Dashboard filters. Currently, this functionality does not work for the App Studio. It would be great to have that be a universal capability across DOMO as it's very helpful when filtering for 100+ items.
-
Domo Mobile App Access for App Studio in Subscriber Instances
We have a client who uses a subscriber instance and when we download the Domo App and try logging into the URL for the subscriber instance to access their Apps our SSO does not work. We get an error message: "Could not sign in - Mobile access has been restricted by your company. Please contact your MajorDomo for more…
-
ETL fails due to "This data set does not support data version filtering."
I have my SQL raw dataset set to merge new rows which is working correctly: This SQL dataset is the input for my ETL attempting to process New rows then Upsert in the output dataset: However my ETL fails to run due to the stated error: Am I setting something up wrong? My raw SQL data is not partitioned but it is using the…
-
Magic ETL Column Search Improvements
The new Column Search feature is a godsend. But … it could be better with two modifications: Add a Match String checkbox to limit the search to match the text string exactly. I was searching for the source of a field in a very large ETL. It turned out that the name of the one I wanted (countAsCar, for example) is included…
-
Editable "Form"/Survey Style to Log Interactions
Team, Is there a functionality within Domo wherein end users can log interactions? Something like this: I tried to build out a Form in AppStudio, but all end users got an "Error Loading Form" issue (see my separate thread: Any ideas?? I've thought about making a Google sheet that was connected to Domo but that feels clunky.
-
Data Join Confusion - Magic ETL
Hi, I'm trying to join two sets of data together (assignments submission data & assignment summary data) For the output, I am trying to get a list of all assignments with a due date in a date range that have not been submitted by the students. The assignment submission data has a row for every student that lists every…
-
Datasets API - Get Metadata - RequestedParts
The documentation for the dataset-get-metadata endpoint here indicates that the "requestedParts" parameter can be used to specify which parts of the metadata are needed in the response. However, the documentation does not indicate list of accepted values. The sample request below also indicates a different param named…
-
how to mimic this report on domo.
How to build this report on domo.When i export to excel.It should exactly look same .which chart type should we use
-
On a "Line Bar" Chart, display values for a third measure, with matching Legend entry
On a Line Bar chart, we had added a tool-tips hover over state that shows a third Measure. A user requested that we make these third measure values show permanently on the chart, so the viewer would be able to see all values at once. Support was able to get the values to persist on all bars (without needing hover over) by…
-
Change App Default for "Allow Editing in App Mode"
The default for text cards in an app (whether imported or newly added) is to "Allow Editing in App Mode" which allows any viewer of the app to click in and change the text of a text box. This option can be individually unchecked for every text box in the app, but I'd love if there was a feature to change the default to not…
-
Vertical and Horizontal Reference Lines
Analyzer has some tools for creating reference lines: they offer a "goal" option on y-axis fields that allow you to enter a constant value, max and min lines, as well as regression lines, projections, and total lines. I'd love to be able to have more control over reference lines, including: Vertical reference lines: For…
-
Has anyone found smartsheet formatting that creates an error when loading to Domo?
I am trying to use the Smartsheet connector to load a single sheet of data in Domo and I get this error: "Failed to execute import successfully." I can load a different sheet without issues, and I can load in the column data for the sheet I want, so I am wondering if there is some sort of formatting or column type that is…
-
Lock Cards by default when created
Dear all, When a new card is created please lock it by default instead of keeping it unlocked. Thank you. Best Regards, Tejal
-
Ability to duplicate page in App Studio
I know we can currently import an existing dashboard into App Studios but it will be very helpful if we can duplicate a page in App Studios. I've made a couple of edits on one of my pages and wanted to duplicate it but we don't currently have that option in DOMO.
-
Allow Group Ownership for DataFlows
I know there is a feature to update groups to own a dataset. If we can have group ownership for dataflows as well, that will help track dataflow failures as a team.
-
Filter View Button Action in App Studio
I love the new "Clear filters" action for buttons in App Studio. What would be great is an action that could select a specific "Filter View". Currently, the only place to see filter views is several layers deep in the "Controls" menu, which is not the most intuitive place to look for novice users. I would love to add a…
-
Failed to run dataset due to error from the bery beginning node
I have a dataset that failed to run due to an error from the very beginning node. It said "Failed to convert value '5785586.012810127' from type 'String' to type 'Date'." However, that input itself runs normally and the data looks legit. I checked, no abnormal and no value of 5785586 anywhere. I tried to change all…
-
Chart Types to plot multiple date fields on the same axis
Assume I have a dataset that includes fields for Request ID, Create Date, and Complete Date, which I wanted to graph a time series chart with series for Requests Created (Count of Request ID grouped by Create Date) and Requests Completed (Count of Request ID grouped by Complete Date). Currently I would have to use an ETL…
-
SAP S/4 HANA
We currently use Microsoft Navision and will be implementing SAP S/4 HANA. I was under the impression that I would be able to build up the data in a very similar fashion to what I have done with the Navision data. For example, our sales data consists of two basic tables "Sales Invoice Header" and "Sales Invoice Line". I…
-
Need to show the last 12 months data along with previous year data
Team, Need to display last 12 months data with below calculations , Kindly guide on this, Last 12 Months Last 12 Months Data Previous Year Months Previous Year Data Final Data Should Show in Chart Feb-25 2 Feb-24 1 1 Jan-25 3 Jan-24 2 1 Dec-24 4 Dec-23 3 1 Nov-24 5 Nov-23 4 1 Oct-24 6 Oct-23 5 1 Sep-24 7 Sep-23 6 1 Aug-24…
-
Issue with form brick data flowing to app db
I have a form brick and the data flowing from form to app db. I have deployed the brick and have been using it across different locations. Now I don't see my app db running. I dont see my form input data flowing to app db. This is critical as we are not seeing the data that is recently collected. Can someone please assist?
-
I'm in Analyzer, how can I sum the totals for only some of my columns
I'm creating a card in Analyzer and currently using chart type "Table". Other than changing my chart type to Pivot Table, how else can I sum the totals for my columns……but not all, only some of them?
-
Dashboard
I am in the process of
-
Quick Filter Displayed on Dashboard or App
Could quick filters on cards become something users can interact with from the dashboard or app? Right now, a viewer can only interact with it if they expand the card—ideally we could toggle the quick filter being viewed in the "appearance" settings and any dashboard or app viewer could interact with it right away. Or the…
-
How to calculate Months between two dates with DATEDIFF?
I was trying to use the formula DATEDIFF(month,date1,date2) to calculate the months between two dates based on the function details that shows up in Magic ETL (which I have pasted below). In the Unit form, the difference is returned in the specified units from the first argument until the second. For example, DATEDIFF(day,…
-
PDP question
Sorry for the vague title. My brain just couldn't think of anything else. I have a commission report and I just can't seem to come up with a path to get the PDP setup correctly. I have 3 distinct levels of access: Role level: Salesperson can see only their personal rows. Supervisor can see the rows of everyone that reports…
-
How to create a card via the DOMO Card API
Referring to this API: which could definitely benefit from more clarity and cohesion in its documentation. In particular I have been unable to do POST requests for creating a card. I have obtained the authorisation token already, and are able to perform other requests such as updating a dataset. I'm not sure if it's due to…