-
SFTP Writeback Connector with Public Key File
I am trying to create an SFTP writeback connector. The SFTP instruction indicates I need to create and upload a public key file to FileZilla. I created it. However, there is no place to upload a file in Domo. I wonder if there is a workaround? thanks!
-
Partitioning in Beast Mode not Working Properly
I am hoping someone can tell me a simple fix for why my beast mode calculation is returning an incorrect value. What I am doing is not too complicated, but it is not working and I could use some guidance because I am new to Domo. I have created a column to show the total amount by Quarter using the following calculation:…
-
09/18 PRODUCT RELEASE SNEAK: Workbench Enterprise 2.0
Domo Workbench Enterprise is a web-based portal that allows you to manage uploading your on-premises data to Domo. Workbench Enterprise 2.0 brings additional capabilities for admins and now supports data partitions and File Watch. Now you can: Import Workbench jobs to Workbench Enterprise Upload data partitions to…
-
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…
-
Custom Padding for Embedded Dashboards with Domo Everywhere
Currently, the desktop version of Domo Everywhere has default padding on the left and right side of the dashbaords making the cards all centered. Sometimes when embedding into external websites this default padding is no longer included, making the cards off kiltered or even too close or far away from one another.…
-
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…
-
Display Card Descriptions and Annotations in PDF prints
I'm seeing that when you download a dashboard to PDF and when doing so I'm seeing that the chart descriptions and annotations are not shown in the PDF, but they are on the dashboard. This would be very helpful to have to send externally and to clients!
-
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…
-
Point ETL Output to Existing Dataset
I want to be able to point the output of an ETL to a pre-existing dataset. If, as part of a fix or as part of development, I need to make alterations to the ETL to get a desired output that I don't want to be the final ETL, it would be great to be able to make the changes and then point the final ETL to the preexisting…
-
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…
-
Top N Formula in Beast Mode
I’m not sure if this has been thought of before, but I think adding a Top N formula to Domo would be very helpful. This formula would simplify the process of creating top/bottom N reports, enhance data filtering flexibility, and improve user experience by reducing the need for complex workarounds. It would also allow…