-
Row Numbers from original data
Hi there! Huge fan of the forums and hoping you can help me with something that previous posts and many late night Google searches have eluded me on... We have an email connector pulling in many CSV files from attachments and appending them one after the other in the order received. The order of the data within each CSV is…
-
Long Execution
Hi people! I'm here again! This time, i have a e long execution problem! I have a table with raw data with 46 million lines, approximately. Here is my first question: When a create a dataflow that process that 46 million rows and generates a output dataset, that dataset is a physical table or anytime i use that output…
-
Is there any way we could replicate Multi-Row formula tile of Alteryx tool in Domo?
This tool is very good to fill in data gaps (if any) based on logic.
-
How to Trim a column with multiple words in it using ETL
I need to Trim extra spaces, How can I do that in ETL? I used the replace text function, but it would remove all spaces. So, if the column contains " Josh Smith Jarrod ", I want "Josh Smith Jarrod" but I am getting "JoshSmithJarrod". I am not looking for SQL solution as the end user need it through ETL. Thanks in advance.
-
DOMO Regex Extraction ETL
I'm looking to extract a work order number which contains the letter W followed by 15 digits (Ex. W571191476628566). The order number lies within a string containing notes content that has been exported into domo. (Ex. "Customer called in to discuss work order W571191476628566, and asked about order status"). In the domo…
-
calculate difference between two dates
Hi, We have one filed name "Inquiry Date". and we wanted to calculate the difference between the two inquiries. we need output like mentioned below screenshot (Difference between two dates) eg: (01/01/21) - (01/01/21) = 0 (02/01/21) - (01/01/21) = 1 (07/01/21) - (02/01/21) = 5 (15/01/21) - (07/01/21) = 8 Please suggest a…
-
Beastmode | Exclude data based on dates
Hi all, I'm probably missing something small here but I'm using the following beastmode: (case when `Date` >2021-07-01 then (case when `company` like '%company1%' and `ConversionTypeName` like '%product1%' then 'exclude' else 'include' end) end) But when I use it as a filter it excludes everything and not only the sales…
-
Make title column of a mega table wider than the successive columns
Hello all, Is there a way to make the title columns of a mega table wider than the successive columns so that the generally longer titles don't have to wrap and make the rows double wide? I see there is an option to set column widths, but I can't seem to figure out how this setting functions. Can someone provide an example?
-
Help with Beast Mode field please!
Hello Community, I have a beast mode field that is working great when I am using a single number chart looking at the total for the current quarter we are in. The problem I need help with is, what can I update or what am I missing from the below Beast Mode field that will not allow me to show each month in the current…
-
Is there an easy way to calculate the days left in the month to insert in a Beast Mode equation?
I'm working on a Beast Mode where I have a given an amount of production that I want to divide by the remaining days of the month. The method I have below doesn't function the way I want it to. My code segment is below. Is there any easier way to go about doing this? Thanks in advance. (SUM(`Goal`) - SUM(`Production`)) /…
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
-
Grab the most current entry
I have a dataset with a list of activities. For each opportunity I want to grab the most current update/activity show those notes. so for a proof of concept, I might have the following: Activity Date. type description 1/1/2021. environment buildout. Built stuff to support POC 1/5/2021 project kickoff things are going…
-
Can you remove duplicated rows of data in a data set?
We have a data set that is updated from a Google Sheet. I see that back in June we have duplicate entries for June 22 and June 23 in the data set, yet the data in the Google Sheet is not duplicated. Is there a way to edit the data that is in the data set to remove these duplicates?
-
Determine percentage of repeat callers (beast Mode or ETL?)
Good morning. We've been trying to create a beast mode to help us determine the percentage of repeat callers and while I can picture in my mind what needs to be done, we've been unable to determine a working calcuation for it. In the image below, there are 14 distinct companies/phone#'s and a total of 33 calls.…
-
Help with Quarter Beast Mode Please`
Hello Community, I have a beast mode that is working for my purposes when reporting on the fiscal quarter in total. What I need to do next is show in a bar chart each month in the current fiscal quarter and the calculated currency value for each month. This dataset is coming from Salesforce and is from the opportunity…
-
Updating Datasets
Hello, My datasets were moved to a different server and now I need to point all my dataflows/cards to the new dataset. Before I do can someone please guide me with the following questions: Is there a way to change the datasets in one place vs going thru each dataflow? My predecessor applied some of the beast modes to the…
-
HTML Table Hyperlink Beast Mode
Hi, I am trying to find a way to add a hyperlink to my HTML Table where I have a Column called 'ID' with rows of numeric values of our Helpdesk Case #'s. How do I create a beast mode formula to link to our helpdesk system: If ID = 12345 and link is https://www.helpdesksystem.com/userui/ticket?ID=12345 Thank you in advance!
-
Shopping Funnel Via Google Analytics Advance Connector
Hey, The business question I’m trying to answer is where customers are dropping off in the purchase funnel. I tried using Google analytics advance connector, but the data does not align with what I'm seeing in the platform or what I see in my other datasets that use the same connector. Have any of you guys successfully…
-
CONCAT different cells in the same column
Hello I have a column let's says its called 'Column A' and it looks like this: COLUMN A 1 2 3 4 How do I concat so It shows in the same column like so: COLUMN A 1,2,3,4 Is there a beast mode that can help me do that? Thanks!
-
How to find the difference between 2 dates?
My dataset aggregate value totals on a monthly basis. Each row represents an individual site and value for numerous metrics. What I am trying to do would be how to find the change between 2 months like between Oct 1 , and Nov 1, as shown above for the values in the column to the right. But I am not sure how to write the…
-
How to find a two digit number in Replace Text
I'm using replace text to change Country ID codes with the name of the country but I find out that when the the text code is "10" it just read the last number and replace it. What should be the right configuration to search the whole text?
-
Dataflow creation best practice and recommendation
A lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an easy 1:1 comparison that makes joining the data very easy. usually I am using 1 report for almost the entire visualization, and puling a column or two form the 2nd report. Since the reports aren't in an identical format, and…
-
Formula to Remove Duplicates and keep Max Value
Hi, I am currently looking at some records where customer's accounts were waived. However a customer can have two applications waived the same day (maybe they drew on the account two different times so there are two applications on an account for them.) I want to remove the duplicate record and keep the record showing the…
-
Period to date sales beast mode
Currently using this beast mode for "this year period to date sales": SUM(CASE WHEN `SALE_DATE` > CURDATE()-40 AND (CASE WHEN CURDATE()-1 >= '12/30/2018' AND CURDATE()-1 <= '1/26/2019' THEN 1 WHEN CURDATE()-1 >= '1/27/2019' AND CURDATE()-1 <= '2/23/2019' THEN 2 WHEN CURDATE()-1 >= '2/24/2019' AND CURDATE()-1 <= '3/30/2019'…
-
Conditionally Format Data Label Fill Color on Grouped Bar + Line Chart
Hello, Is there a way to conditionally format the data label fills below so that any positive % has a green box with a white font & any negative number has a red box with a white font? I have seen success in similar situations in Domo where others have used HTML statements within beast modes to achieve a similar result,…
-
Creating a calculated column in beast mode results in data being split up
Hi all - I am new to Domo and experiencing some issues displaying desired results in a bullet chart. I have a beast mode calculation where it provides a value if one criteria is met, and another when a different criteria is met. In my bullet bar graph, when I select both criterias in the filters, values are now split into…
-
Can PDPs be created on other Admins?
I need to create a PDP on two datasets where admins only see the data that pertains to them. Is this possible?
-
FInd out who deleted a Dataset
Is there a way to find out who deleted a dataset in DOMO? Thanks
-
Join Function in ETL
Hi, I am trying to join a table on my DataSet, using the left join function. My original DataSet contains only 118k rows, and the other table contains 1405 rows. I thought that the output DataSet will stay 118k rows, and just have addition columns on it. However, the output DataSet is 4.6M which is way more then I…
-
Putting Current day and Previous day as columns instead of rows
Hello! I have run into a problem just like this link: I followed the sql transform but once I ran it the output dataset was the same as the input dataset. I don't know what I am doing wrong, I even uploaded a file that is exact to the example in the link above. If someone can help me figure out why it seems like its not…