-
Calculated Fields - Pipedrive ID's
Hi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Field ID's into text. Is there a way that I can do this once instead of doing calculated fields for each metric?
-
REGEXP_REPLACE in ETL add new line?
I have data in Domo for an address that includes a new line character. This data was brought in from NetSuite in this format. I am trying to add additional data that matches this format. I have the following data: Ship Address: attn~company~addr1~addr2~city, state zip I would like it saved as such: attn company addr1 addr2…
-
Reverting Back to the old dataSet version
Hi team, I changed a few things in my recursive ETL dataset and lost all the rows of data that were recursed in it. When I try to revert the flow to a previous version, it does not show the lost data rows. Any way to retrieve those?
-
How do you rename null values in a date column?
I have blank values in a date column which is messing with my filter, is there a way to rename these? I don't get the option since it's not a text format
-
Manually adding data to a existing DOMO dataset
Hi Team, I am trying to add the data to a existing DOMO dataset..Can you please let me know how I can achieve the same.. Thanks, Arun
-
Add Data that has been modified in the last 7 days
I have a snowflake dataset that has a modified date column. I want to merge the data that has been modified in the last 7 days to the dataset. Sometimes an order is modified after its placed and we want to capture the new values of the order. I have used this query but its not working SELECT * FROM "TABLE" WHERE…
-
Setting a duplicate value in a column to null or zero
I have a dataflow where I'm joining projects to their respective tasks. Each project will have a large number of tasks associated with it and a planned/actual cost for the project. This results in many duplications of the cost and task data. Can I somehow set all duplications, after the first set, to 0 or null without…
-
How to remove empty columns from a dataset?
I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values? I know I can write a script using Python/R but we don't have a scripting tile in our package.
-
Line over BAR chart
Hi All, Hope you are doing well!.. I currently have a bar chart to show the this year inventory by Fiscal week... I want to have a line running over my bar chart that shows the inventory for the same time last year...Can you please let me know how to do that.. My beast mode for This year inventory count(distinct case when…
-
Problem with column sorting
Hi All, I am sorting a dataset in the visualizer...I am sorting by the dealer name and whether the item got shipped or not and then by the order date all in the ascending order... The beast mode that I am using for the shipped or not beast mode is the following: CASE WHEN TRIM(`order_status`) = 'order shipped' then '1'…
-
Return data within geographical radius?
I have a table containing a list of zipcodes and corresponding data. Say a salesperson unfamiliar with SQL wanted an elegant user-friendly interface to return all rows within a 5 mile radius of a given zipcode. Is there a way to implement geographical data like this? Or perhaps a free Domo app that can integrate this…
-
How can I prevent a running backlog total beastmode from hitting zero?
I'm working on building a labor model for my department to track where our projected backlog will be over the next several weeks. One problem I'm running into is when the incoming backlog is less that what we're projected to process, the backlog goes into the negative instead of hitting zero which then throws off all…
-
Using UPDATE statement in Redshift
Hi , I am trying to update a column in Redshift using UPDATE statement. But I am getting error If someone can suggest whats wrong with the code I tried this code- UPDATE "table1", SET "created_dt" = '01/07/2022' where "change_hint" = 'update' The output comes as - Whoops ! Something went wrong
-
How to find a max value from multiple aggregates
Hey guys, I'm looking at our collections information from the last two years to find our best collections month during that time frame for each of our locations. Before when I had to do this I just did it in ETL using a group by function, but this case is a little more complicated as I'm wanting a specific set of…
-
showing record with max date
Hello I have a dataset which pulls record numbers(gn_id) and its pulling some duplicates and it looks like if it that gn_id has a duplicate I want to pull the one with the most recent or max date but am unsure on how to accomplish this, I have attached a screenshot of what I'm looking at as on this example would want to…
-
Data Interval Using Business Days In MagicETL
I am calculating deadlines by using a dynamic formula in MagicETL, which adds 4 days to a date like so: CASE WHEN `issue` = 'bug' THEN ( CASE WHEN `priority` = 1 THEN ADDDATE(`CreationDate`, INTERVAL 4 DAY) END ) This works great, however I'm wondering how I could change the interval to simply be four business days instead…
-
Vertical Symbol + Grouped Bar chart Question
Hi All, I am trying to create a vertical symbol +Grouped bar chart to show by Fiscal Month week to show the On order $ for this year and last year and the on order units for this year and last year... Following are the beast modes that I am using X-Axis: Fiscal month week -CONCAT(UPPER(`FISCAL_PERIOD_LABEL_SHORT`),'-WK ',…
-
Beast Mode for Getting the order status of the vehicles on order
I am trying to determine the status of the vehicle on order -Whether it is stock or Sold , whether it is part of the BAM campaign or not and the sold or stock date based on the following set of rules If the data column orderstatus has *SLD ,SLD or SOLD then the comment column is sold ; if the orderstatus column has STOCK…
-
Is there a way to rank based on R squared value?
i'm looking to see if there is a way to rank based on the increasing trend (R squared). i.e. the greater the increase over a set period the higher the rank. Thanks, Steve.
-
Pendo connection: how to add a date column to a dataset?
Hello! I have created a Pendo connection to domo but a date column was not pulled over with the data. I was wanting to add a column to the dataset and put the date that the corresponds with the data but am struggling to do so. Does anyone have any ideas on how to do this?
-
OR statements in card filtering
Hi folks - We have a dataset where users can have datapointA and datapointB. We want to build a card where an end user can have a filter that asks for any user has datapointA = 'green' OR 'databpointB = 'circle'. When we put those two datasets in a dataflow/card and add the datapoints as Quick Filters, it automatically…
-
Set values in a column based on a "master row"?
We are a music library company that makes a large amount of our income from the sum of tons of small royalties. Pretty much the only information that comes in from the royalty reports is the track title and amount earned, and even if it does have other information it's not unified among all the different royalty sources…
-
Beast Mode calc for omitting specific modalities?
I have a dataset that contains data on a whole collection of transactions. Within the dataset is a dimension I'm interested in- Divisional Expenses. This dimension has a few modalities- HR, Sales, Marketing, etc. Each of these modalities has a value. If I want to create a beast mode calculation on Divisional Expenses that…
-
Getting dates in one row
Hi All, I am working on the data visualizer and have the data as below The columns order,model, ord date, rec date,cur prm come from the DOMO workbench while the columns prm date -7D, prm date -14 D, prm date -28 D come from the beast mode... I am trying to get the above data in the format below...Can you please help…
-
Finding average of difference in two different dates
Hi All, I am trying to find the average difference in the dates between two different dates at a level of plant ,segment, model and part..I used the Group by tile for the same and in the aggregated column I am writing the below formula AVG(DATEDIFF(`cur_prm_date`,`prmdate7` )) over (order by `cur_prm_date`) for which I am…
-
Getting an error in visualizer
Hi All, I am getting an error when I am on the visualizer ...There was a problem saving your card. If the problem persists, contact the Domo support team. ..Can you please let me know what to do now...Will I lose all the work I have done now..
-
data flow to added new data to dataset each week.
Hi, I'm a bit stuck trying figure out how to added additional data to a dataset each week. the new data is added as a weekly extraction and uploaded to DOMO via SharePoint connector. I also have a 10 yr dump of historical data. what im looking to do is to create a dataset set to include the historical data and each week…
-
Why won't this beast mode work -- case statement
CASE WHEN `Variable Name`<= 1 THEN 'SMALL' WHEN `Variable Name` BETWEEN 1 AND 1,000 THEN 'MEDIUM' WHEN `Variable Name` > 1,000 'LARGE' END
-
Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.
Our subscription data is collected on multiple days throughout the week and creates a snapshot of that point in time. I want to see what that week's total was based on the most recent day. I don't mind removing the row with an earlier start date.
-
Adrenaline Data Export Failed
Hello, My ETLs sometimes randomly say this for no reason, my understanding is that Adrenaline data flow is an advanced feature that we do not have. I have had this happen at least 10 times before and then it is fine the next day, probably just a glitch. But I have had this one dataflow that looks perfectly normal and will…