-
Scheduled Report - Excel Attachement
Allow scheduled reports to attach the data in excel format rather than csv. CSV files don't keep special characters in the data, so accented characters are messed up in the CSV.
-
How to get the first character of a string in domo beast mode analyzer
Hi I am trying to get the first letter in the product number field. I have created a test field to remove any extra white spaces the product number field would come with and here is the calculation: TRIM(ProductNumber) Next I am trying to use the Left function to get the first letter from that test field without any extra…
-
How come MySQL does not support window function, specifically lag in dataflows?
Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window…
-
how can i track remote domo stats available in my child instances (05875821)
apparently remote domo stats have to be enabled on a per request basis (ticket 05875821) if i have 100 instances, what would be the most expedient way of confirming that all of them have the same stats reports available? if Domo updates a version of the report (and modifies the schema or how content is generated) what…
-
how to change the type of existing DOMO data?
data has been uploaded into DOMO. the first column is in integer type like '45319' but actually it is DATE(Jan-28-2024), how can i change it to DATE in DOMO without changing the original spreadsheet data type? thanks
-
Confluence Card
Hi all, I heard something in DOMOPALOOZA24 about having a card with Confuence content, does anyone know anything about this? I couldn't find a connector or anything… The idea was to have a card with the dashbboard documentation that lives as as Confluence page. Thanks!
-
Remove lookback period from the data and see the values.
I have a dataset which holds transaction data. I have dates, i have derived a week column from date which has values like “2024/17”, etc. and I usually filter data based on weeks. My use case is when I select a week using 2 variables- one will pick year and other will pick week number, I want to subtract lets say past 4…
-
Connect Two Cards
Hello, I'm currently working on a Dashboard. In this dashboard I have three different cards: one is a slicer that allows you to select certain deal numbers, the other is a product description based on the deal number, the last one is product description by date. Now what I have not been able to figure out when I select a…
-
Mexico city zipcode map in DOMO
I am looking to add a custom chart for the city of Mexico on Domo based on zipcodes (supported file format - svg, GeoJSON, kml) . Please share if anyone has any reference links. Thanks in advance.
-
Charts on distinct values
I have a dataset, which is the result of a join so the ID is not a unique key: +————+——————+——————-+—————| | — ID — | — Name — | — Gender — | — Role — | +————+——————+——————-+—————| | 001 | Alex B | Male | User | | 001 | Alex B | Male | Admin | | 002 | John C | Male | Agent | | 003 | Drew H | Female | User | | 003 | Drew H…
-
Want to track progression and targets based per Quarter
Hi all, I've one datafile with sales with different products. Quantity is a column where I used 'sum' Target is made through a beastmode 'case when QUARTER(date) like 1 then 1250 else 0 end' Progress v2 is also made through beastmode and doesn't deliver the right results 'QUARTER(date) like 1 then (1250- (quantity)) else 0…
-
Microsoft Forms and/or Customer Voice Connections
We currently utilize SurveyMonkey for some of our internal surveys; however, we are looking to transition away due to the increasing cost and instead leverage some of our 365 products. We were looking to move to either MS Forms or Customer Voice; however, I'm not seeing a direct connector in Domo to pull data. I know I've…
-
How do I append data to a designed CARD every day automatically?
I set up a CARD to show warehouse storage location quantity, every morning the 3PL send daily storage location report, I'd like to append the daily data automatically to DOMO from google sheet because 3PL's report is in google sheet format. How can I set up it? Thanks a lot.
-
Choosing first and last month in BM
Is there a way to use fixed functions or something else to grab the first date that appears and the last date that appears? I am trying to calculate yearly attrition. I have it by month but adding up or avg the monthly % is not mathematically correct. I need to get the first month and last month's values within a certain…
-
Filtering data with 2 columns with beast mode?
Now I have a dataset something as below; ID Cat Name Cond01 0001 1 A 3 0002 2 B 4 0002 1 A 3 0001 1 D 1 0003 2 B 7 0003 1 C 5 0004 1 A 9 … … … … Now I want to make two filter cards to select data by Name , conditioned with a Cat value, where one card is for filtering data by Name when Cat = 1, another one by Name when Cat…
-
UTC to PST conversion in ETL
Hi, I am trying to convert the "Date" from UTC to PST in the ETL. Currently, I created "Send Date PST" with the formula below. TIMESTAMP((convert_tz(`SendDate`, 'UTC', 'America/Los_Angeles'))) However, when I try to use it in the card and filter for the last 4 hours, my card is blank: It works when I do the same thing with…
-
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…