-
09/18 PRODUCT RELEASE SNEAK: Magic ETL Updates
We are excited to release these new updates to Magic ETL! Upsert Processing: Update rows in output datasets without reprocessing the full dataset, based on a unique row-level key. This replaces any of the remaining needs for recursive dataflows. This makes the pipeline pattern much more resilient and efficient due to an…
-
09/18 PRODUCT RELEASE SNEAK: Group Account Ownership
Historically, Account Ownership was tied to a single individual, making things like change management, or administration by groups next to impossible — which limits the ability to scale. Additionally, if that individual left the company, reclaiming those now-orphaned accounts was difficult and required workarounds in order…
-
09/18 PRODUCT RELEASE SNEAK: Connectors Update
We’ve made a few quality-of-life updates to streamline connector usage upon data ingestion! Define parsing rules for JSON coming in from a webhook: This solution takes sample response JSON from a webhook and allows you to set parsing rules — parse the response into a tabular format that best suits your needs and perform…
-
09/18 PRODUCT RELEASE SNEAK: Data Collection and Action App Building
We’re adding a few capabilities to Forms and App Studio which helps a low-code user easily create a powerful app that, for example, collects information, kicks off a workflow, and queues up an approval for a user who can act on what’s presented in the app. Question-specific Right Rail Drill: We’ve moved the more advanced…
-
Start new users with the dashboard tab unpinned and buzz hidden
Hi Domo, I think it would be a great idea to allow the option for new users to start with their dashboard tab unpinned and buzz tab hidden. By default, these two are showing, and they take up a lot of valuable screen real estate. It is necessary to explain to everyone how to hide these two ribbons so that the visuals can…
-
How to create a collection for public embedded form bricks
I have customized a Form & Dataset domo brick. Powered datasets by mapping to dataset 0,1,2 and also created a new collection and mapped it, changed the schema of dataobject as per customized form. The data is storing to my collection on local server. However I am stuck with two issues here 1. The data is stored locally…
-
Small HealthTech Firm Looking for Domo Expert - FULL TIME JOB
We're looking for a highly skilled domo expert who can harness the power of data to drive strategic decision making and optimize our health tech solution! Job Requirements: Develop and manage Domo dashboards and reports that provide actionable insights. Integrate various data sources into Domo to create a cohesive data…
-
Cumulative Sum with Windows Function
I'm trying to use windows function in the new SQL tile. For example, I have a dataset with three fields: Gender, rank, students; I want to aggregate by gender, sort by rank and sum students cumulatively so the last row of each gender category contains the total number of students. I tried the following query and got an…
-
Beast Mode Calculation used to view data in Table
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
-
CLI with Task Scheduler
Anyone put the script directly into Task Scheduler to export a dataset? at the command prompt I can type the following separate commands (enter after each) java -jar C:/Domo/java/domoUtil.jar connect -s xxxcompany.domo.com -t 3xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx export-data -i 0DATASETIDHEREINTHISSPACE80c -f…
-
Pivot tables
I dunno why, but some of the time I cannot wrap my head around pivot tables. Here is what I want to do and here is how my data is structured and the column headers…. Account | A Prime_TV Revenue | B Prime_TV Revenue | A Premium_TV Revenue | B Premium_TV Revenue Pivot table I want… TV Category | Company A. | Company B…
-
Aggregating Dates Beast Mode
I have an existing simple bar chart that is displaying a count of daily activity. The current fields are Date_StatusChange on my X axis and COUNT of Status_Desc as my Y axis. I'd like to aggregate all dates prior to Aug, 25, 2024 as "Carry-In" so I can display a count of everything prior to that date as "Carry-In" and…
-
Calculating percentage in beast mode based on count
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
-
Preset Card Filters Should Not Override Page Embed Filters
Currently, there is no way to use a single Card in a pre-filtered Card embed as well as a Page filter embed without the Card filter overriding the Page filter on the same field. Context: Filtered Card embed is needed for static 'overall' non-interactive insight. Page embed is needed for more granular interactive filtered…
-
Multi-select in People
Multi-select in People in the Admin settings doesn't function properly. When you search for and select a user, previous selections are deselected. Would love for this to be fixed.
-
How to make a Positive value a Negative value
Sounds like ABS can make a Negative value a Positive value, but how can I do the opposite? Need the result from this Beast Mode to be converted to a negative value: SUM (CASE WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22') AND YEAR(`Month`)=2024 AND `FinancialCategoryName` LIKE '%CAPEX%' AND `Portfolio 2024_p`='Rejected'…
-
Storing form input data for the embedded card.
How to create a collection to store form input data through form & dataset brick when embedded publicly? Currently my collection is only storing the data entered locally.
-
Sharing Scheduled report only for PDP based alert trigger
We are trying to implement a PDP based alert system that can schedule reports only for the users whose PDP data qualifies the alert rule. On a PDP enabled dataset, we tried setting the alert in Contextual mode, but the alert trigger is considering total dataset to validate the alert rule and sharing the report with…
-
JSON No Code - Something went wrong getting data!
I'm using the JSON No Code connector to get form data. It requires paging so when i go to the paging and parsing section it throws this error on the data preview so it won't let me select the number of pages column. It shows the preview below so I know the data is coming through. I exported the data and saw there was a…
-
Custom YOY Seasonal Calendar year
My company runs events twice a year, Spring and Winter. However, these events do not start on the same day every year. I am looking for a way to do Custom YOY dates in the cards so that I can compare this year with last year or the year before without needing to calculate each year's comparison data into each row using the…
-
Error Detection via Line Number
There have been many times where I am writing or troubleshooting a beast mode and when I come across an error, I have to individually go through each line to figure out where the issue lies. Most of the time it usually stems from a CASE WHEN statement and I’m forgetting an END or a parentheses. I think it would be great if…
-
Dashboard Default Filter View not shown with Scheduled Report
We'd like to include the default Filter View of a dashboard when scheduling the page as a report, so that the primary column filters are available as shown in the screen capture below. However, when someone clicks on the received email they see the Close Report / Save Filters to Report options and the default filters are…
-
Variables not showing properly in Control area
Hi Team, I'm having a hard time with a variable for Date View (Daily, Weekly and Monthly), but when I add it to the card, it doesn't show up in the control section, nor when you are looking the card from the dashboard. I want to clarify that the variable does works when added to the dashboard itself, but going card by card…
-
I converted a DDX bricks to App in edit mode
I am working on form and data set brick and had customized the form. I accidentally converted the brick to app. Now installing a new brick instance is automatically converting the form and is affecting my form interaction, is there any way to revert the conversion?
-
Excel export from card analyzer.
It would be great to be able to export tables I make while editing cards without saving them.
-
Dashboard Mock/Wire
Part of our process for dashboards is to sit with business owners and create a mock/wire that can be agreed upon before we sent it to engineers to start ETL/Visualization. Historically this has been a tedious task in PDF format and now that we are on Domo it is even harder as I need sample data to create a mock dashboard.…
-
Fill in gaps in data
I have rows of data that look like this: Customer: ID: 12 NULL 12 NULL 12 NULL 12 NULL 12 NULL 12 56 How do I fill in the above rows with the customer ID, 56, Using ETL?
-
Microsoft PowerPoint easier resizing / cropping for imported cards & tables
At present when cards with charts are imported, many require resizing in advanced setting to make it so the category labels are fully visible, and sometimes the sizing expressed in the settings preview does not translate when the card is refreshed. Requesting ability to resize by dragging the corners and capability to crop…
-
Merged: Card Tagging
This discussion has been merged.
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…