-
Using regexp for pulling multiple values out a text string
Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!
-
Step Ratios - Pivot Table
I have a pivot table showing total number of applicants through the recruitment process. I want to be able to show the "step ratio". Pivot Table has Steps in the rows, column is job type, values are a distinct count of candidate ID. Dataset has multiple rows per candidate, each step of the process they've reached. Im…
-
Embed error, duplicate of dashboard does not work
We're getting an error returned based on the embed we are trying. Private embed. Embed: https://public.domo.com/embed/pages/gJ6z3/stack?parts=metadata,datasources,drillPathURNs,domoapp,slicers,dateInfo&includeV4PageLayouts=false Error: {"status":404,"statusReason":"Not Found","toe":"1T0CBEN7LS-682ON-K3KSH"} this one…
-
Case Statement - 28 Days from a specific date?
Hi All, I need to write a case statement that would calculate 28 days from a selected date. How would I write that? The end result would be total sales within the 28 days going back in time from the date selected. Thanks, Paul
-
Syntax Error in Beast mode calculation
CASE WHEN Sort: Month Number = 1 THEN NULL ELSE ( (SUM(All Cases) - LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number)) / LAG(SUM(All Cases), 1) OVER (ORDER BY Sort: Month Number) ) END I'm not able to figure out what is the syntax error over here. Can anyone please help?
-
ETL Wont let me 'Edit' then 'Run'
Hi, I am wondering if this might be a glitch or what might be causing this problem. I have an ETL that I am trying to edit. The only dataset it uses is the calendar dataset. I am able to run it by going to the dataflow, clicking the three dots, then Run. (See attachment if confused) However when I click edit etl, and…
-
DP Product Recap
Wanted to share a copy of the deck used at today's community event. This is all publicly available so sharing as one PDF (file with the videos was too big to share but all the videos are available here too: )
-
Public embedding of a dashboard
I've used Domo for a couple years now and I am just now starting a separate company of my own and I want to feature some dashboards on my website. I have attempted to publicly embed a dashboard I created onto a website; however, I keep getting the error: "public.domo.com refused to connect". I have tried using the link as…
-
Collapse selected branches in Lineage
I would like to have the ability to collapse selected input and output branches in Lineage. This would help declutter the screen when tracing datasets and ETLs, especially when dealing with recursive ETLs that put two or more copies of everything downstream on the screen.
-
Beastmode - Duration (mins) between 2 Datetime Columns
If I have 2 datetime columns (StartDate & EndDate), how do I find the duration (mins) between the 2 using Beastmode? Example:
-
add manifest concept to DDX Bricks (so that i can call codeengine functions from bricks.
thoughts? apparently calling codeengine from ddx isn't currently supported. would it be possible to re-envision ddx with an extra tab (html, js, css, manifest) so we can have that control?
-
Reverse Color Direction to Heatmap features in table
Our use case require to show lowest numbers in darker red color. I'm able to hack this by using diverging and setting the midpoint to an unreasonably high number. Nonetheless, it would be great if there was a toggle just to flip the color direction.
-
Refresh dataset
I am trying to refresh my dataset (google sheet), And i do not see a drag and drop file in the details section of settings. I am not sure how else to do it, and my data preview is not showing the new data I have in my sheet
-
Help building from with Domo Form/Builder
Hello everyone, My instance has access to form builder and form viewer now, but previously analytics request were done via Smartsheet. now we are looking to move away from Smartsheet but try to create the Smartsheet form using domo form builder/viewer. Can anyone offer any thoughts on how to start this process? can i use…
-
Show the Average in Bar Graph (Days/Hours/Minutes)
Hello. Can you help us find a solution how to display the output we want to achieve? This is the current output that we have, but we wanted to see a view using bar graph. The problem is that, the values are 'string' and not 'numbers' because of the concat function we used in beastmode to identify whether the computed…
-
More Customization to Buttons on AppStudio
I have this one use case where I want to take the user to a page that has a broader context to the analysis in the current page (meaning we need to pass another field as a filter for the other page which is not the one that the current page is being filtered on). It would be cool if we could set the button to pass on…
-
Having trouble running a workflow from a Domo Brick
There's a brick called Workflow Start Form that I'm basing my implementation on, primarily the function const startWorkflowWithParams = (alias, params) => { var startURL = '/domo/workflow/v1/models/' + alias + '/start'; domo.post(startURL, params).then(data => { console.log(data);…
-
Change Dataset on Form and Dataset Brick
I'm working on a Form and Dataset Brick. I've got some background in coding enough to change a few table elements. What I'm trying to do now is change the dataset. Right now the table is pointing to a dataset that was seemingly created when I created the brick. I renamed the dataset "P&F Test Form". Everything is working…
-
Dataset on Workflow Start Form
Hi, I'm using the brick "Workflow Start Form" available on app store to start a workflow using a custom form and parameters. That part works greate, but i alse need to query a dataset from there and the card have no option to link one (only allows to link a workflow). Can anyone tell me please how can I link a dataset or…
-
Updating data set
I am new to DOMO, I have uploaded my spreadsheet and can see my card and chart, how do I update the spreadsheet so the datat is up to date each week. Also I have it listed as weekly revenue but it shows as monthly?
-
HTML Table Cell: Space Between Image and Text
I have a linked image of a video and the title of the video in one cell in my HTML table. How can I put space between my image and text in that single cell? I would like the text to just have a small space between it and the image. Here is my beast mode now: CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img…
-
How do you set a table to automatically go back 2 fiscal weeks for a report?
I have a client with a custom fiscal calendar. I have a report that automatically returns data from the previous fiscal week (Sunday to Saturday). I need a second report that will return the same data from two fiscal weeks ago. Does anyone know how I can automatically have the fiscal week updated for this report?
-
Delay Dataflow Trigger
It would be helpful if I could delay a trigger to run 5, 10, 15 minutes after the dataset updates. Use case: My daily data upload process is completed, kicking off the updates of many datasets in Domo. One such dataset could be updated by a single dataflow, which could have six different datasets combined. Some of these…
-
Update table function throwing error in SQL transform
-
Group Administration
I have a closed group that was created in our instance of Domo. The original owner is no longer with the company. I need to make the person who replaced them the owner of the group. However, even as an instance admin, I do not seem to have the ability to do this. I do not see the "edit" option I see on groups that I am…
-
Year Over Year cards Leap year issue
YoY cards cards where Year to date is the range set for the card do not calculate prior year totals and hence yoy changes correctly until the month is complete. Since a year is assumed as 365 days for YOY cards, the leap year throws off the comparison to prior years until the month is complete. We are relying on mid month…
-
Not sure which join to use
I am trying to link 2 datasets to show scheduled appointments and web traffic in the same visit. The goal is to show what, if any, correlation there may be for traffic to specific ad campaigns and appointments for their related services. When I use datafusion or etl join, it gets messy because the only matching data I have…
-
More than one Fiscal Calendar Set Up
It would be great to have more than one fiscal calendar set up. For example, one for monhtly boundaries and one with weekly boundaries.
-
LinkedIn V2 API Changed?
Hello, Does anyone know of any issues currently with the LinkedIn V2 API connector? My connection recently broke and when I try to rerun it for post data, the content field is blank (not showing the account's posts). I was curious if anyone else experienced issues with the V2 connector and if there's a fix I can implement.…
-
Can the dashboard imported to the APP studio be automatically updated and synced?
Hi guys, I have a question for the app studio. I am creating an app using the app studio where I imported many already built pages, I am wondering if the dashboards will be automatically updated and synchronized mutually once there are some changes on one of the ends?