-
The correct regex to remove the first character?
I have a column( that illustrates a dollar amount but is in string format. What I am trying to do is to remove the dollar sign ($) that is the very first character in each row, so i am only left with the numbers. I have tried the left/right substring but each dollar amount is different length so I have ran in to issues.
-
Some content is too tall to export
Trying to export a dashboard with lots of cards to a PDF. The PPT download won't hold dashboard filters when exported. The email scheduled report does not send the entire dashboard only part of it. What are users doing as a workaround for exporting reports to external (non-domo) users. This is all robust financial…
-
Write a Filter Formula using Magic ETL Filter Tile
Hey guys, so I am trying to utilize the filter formula feature in magic etl, but I can't seem to get it to work. When I run the following formula, no data appears. Using Excel, I performed a concatenate on all 517 websites that I would like to be filtered out from my data in order to build my formula. I've also used AND as…
-
ETL join is matching multiple values - not exact matches
I am joining two datasets and the result is matching multiple values from the second data set to a single value in the first data set. Is it possible to have the join only match exact values? Example: Data Set 1 Data Set 2 Join result Join = Left Outer Left Table = Data Set 1 Right Table = Data Set 2 Matching Column = ID…
-
DOMO - Timestamp
Hello, I have data coming in from SQL with a timestamp from previous day. So the date in the table will be current date -1. I want to separate this data into 3 different tables, Table 1 - 7 AM to 3 PM Table 2 - 3 Pm - 11 PM Table 3 - 11 PM to 7 AM. How can I add a formula in the filter for tile to filter the rows by that?…
-
how to show a duplicate in a table graph
Hello Dojo! basically, we have a dataset that shows the number of beast modes we have created along the years. what we have is one column for the beast mode name, who made it and when. what we do not have, and what we want is a column that identifies that this beast mode is a duplicate. It would either show "1" or…
-
Alerts on Output Dataset Fail with False Claim of Duplication
When attempting to add an alert to the output dataset of one of our dataflows we receive the below error message: We have added a Remove Duplicates step to the dataflow on the `Case Number` column just before the output dataset, however this message is still being received. We even compared the Count to the Distinct Count…
-
Multiple Case When statement
Hi - I'm looking for a Case statement that will provide a new column when 2 columns meet a particular condition. I've tried multiple versions but none have worked. 2 examples below. Thanks in advance for any suggested fixes to the formula. IF(AND(`Plant`=1302,`Line of Business`='cable'),'QC Fibre','') WHEN(`Plant`=1302 AND…
-
How populate a new column with data based on data in other rows
I have a dataset consisting of Google Analytics data. One of the columns identifies their Userid (for our ecommerce portal) if they authenticated. Another column identifies their GA session ID (during the visit to our site before and after they authenticate). I am interested in capturing all the activity for a user before…
-
Export Dashboard to Excel
Hello, I've built a dashboard with multiple tables - each with unique datasets. How can I export to excel without having to select each table, manually export each table to excel, and then combine in the same excel workbook in excel? Ideally, each table from the dashboard would export to its own tab in the same excel…
-
Is this doable? Seeing percent of total day sales by hour using Timestamp column.
Hello! I have a problem that needs to be visualized and it was phrased to me like this: I need to see what percentage of sales each hour had for the total day last year then I need that percentage multiplied by the daily goal to get an hourly goal for today. So we have this chart right now: this show us net sales today,…
-
how can i filter colunms?
I have data like below on excel sheet to monitor KPI of multiple products. Product 2021/02 2021/03 2021/04 A 5 4 5 B 4 3 2 C 2 3 4 how can i create/modify on domo so KPI and month can be labeled and create a line chart below?
-
Reconnecting Disconnected Output DataSets and Cards
We are developing under several accounts (e.g. Dev1 and Dev2). In order to organize the ownership, I have changed the ownership of some pages and cards to one account (Dev2 > Dev1). Then the connection between the DataSet and the card got disconnected and the card is no longer visible. For the card with a direct connection…
-
Summary Number - Conditional Format Colors with Directional Arrow
I've read a few posts here in the Dojo, and also read this Knowledge Base article: Sample Beast Mode Calculations: Card Element Transforms but cannot get this to work. It seems that the examples I am finding are far more complex than I need - maybe I'm missing something simple. The logic I am trying to apply for a Summary…
-
Removing GUID from Columns.
Hey all. Hoping I could get some help with this one. I am fairly new to DOMO but I have done some research before I posted this. I am looking for the best way to take data in a column and convert it to something else. Problem is that it does very from time to time. I have some examples of the existing data and what I would…
-
3+ Consecutive days
I'm creating a card where it shows the 3+ Consecutive days if the Delegate is No I only want to display 3+ consecutive N but right now its' displaying all the dates. (CASE WHEN `Delegate Y/N` ='N' AND DATE_SUB(`Date`, Interval 3 day) THEN 1 ELSE 0 END)
-
Group Sales Data by Hour by Day
Hi! I have a dataset that has a timestamp as the date column. I need to sum the sales by hour for each day. I need this done in Magic ETL so I can do another part of my problem before putting it into a card. Is there a way to do this? I have been playing with 'Group By' tile and 'Rank & Window' tile but can't seem to…
-
How to append data to the output dataset?
I have a workbench job that will run daily. It will get the data with current date. I then needs to filter this data and create two data sets using the DataFlow ETL tool. How do I append data to the DataFlow ETL output table? DataFlow ETL creates a new table every time it runs. I realize that One way to achieve this is to…
-
Anything like Difference matrix, Difference between two pivots, difference within the value field?
I've searched around but haven't had any luck finding what I need, but I am not sure if I've searched the best way either so please refer me if this is a duplicate. I'll use dummy data to ask my question, but effectively I need the difference between two values across a couple of dimensions. The goal is different from our…
-
Beast mode difference shows blank even when using coalesce
@MarkSnodgrass and @GrantSmith, you both helped me with my last question and for the most part, it gets me in the right direction. The problem seems to be that a null value completely nulls the whole result (like in sql), even when using ifnull() or coalesce(), whereas excel does evaluate it correctly, albeit with its own…
-
Count the number of times one day appears in a month
How can I count the number of Mondays (also need it for Tuesdays, Wednesdays, etc.) in the previous month?
-
Nested joins in Data Fusion
Can someone please help me to understand how to build nested joins using Data fusion? Should the links be added in a single data fusion or should i use nested data fusion?
-
Comparing values based on their update in google sheets
Hello, I am stuck with a very simple yet hard to design dataflow in domo. So just to elaborate my problem, I have a some google sheets where data gets updated once or twice in a month by our different sales team members. Now they have asked me to build a dashboard where I could show them difference between the values or…
-
Domo IDEAs Conference - Beast Modes - Rolling Averages
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to calculate a rolling average. Problem: How do I calculate a rolling average? Solution: We can utilize the LAG function to get the prior X values and then divide the sum by the number of values. Lag:…
-
Updating a DataSet Triggered by the Finish of a Glue Job
We are using a Connector to retrieve data from Amazon Redshift and display it in Domo. We use AWS Glue to retrieve data from Oracle and store it in Redshift, but I don't think it's possible to trigger the end of the Glue job to update the DataSet in Domo. Currently we schedule the DataSet update around the time the Glue…
-
Handling multiple aggregation levels from source data
My company uses syndicated POS data from sources like IRI, NPD, and retailer POS. There are many measures that cannot be aggregated from the item level data, so I need to bring in pre-aggregated data in addition to the non-aggregated data. I was planning to have one column that indicated the aggregation level, but when I…
-
Beast Mode for Aging Bucket
Hi, I'm writing a beast mode to create the aging bucket, it's is showing results but it's has everything under < 15 days. Note sure what I'm doing wrong here. The 0.06% in 15-30 Days are the negative # (CASE WHEN ((DATEDIFF(CURRENT_DATE(), `Application Started`)) - (DATEDIFF(CURRENT_DATE(), `Date Assigned`))) <= 15 THEN…
-
What's wrong with this case when statement / how do case when's operate on the back end?
Hello! I'm having a problem with a case when statement, and it seems like its not working because I don't fully understand how/when Case When's output information, especially when nested. Here's the code for my new variable `CurrentWeekofYear` case when `Week Number` = (case when `WorkDate`=TODAY() then `Week Number` end)…
-
Line breaks and special characters are being added to a webform
We use a webform for our Sales roster. We have had an intermittent issue with line breaks and special characters being added to the rep's names which causes quite a few issues. The very first sales rep on the roster is getting a line break added to her name. There's another sales rep getting multiple line breaks and…
-
Failed parse text 'NULL' from column 'Column Name' as type 'Date'
Does anyone know how I can solve for the error msg below: Failed parse text 'NULL' from column 'Column Name' as type 'Date' I get this error msg when the ETL finds a NULL value in a column with data type 'Date'. Thanks in advance.