-
Compare rows and delete if one of the fields do not match
Hello, I have data like this. 1, red 1, blue 2, purple 2, purple 3, yellow 3,red I'd like to edit the data to show the data like this: 1, red 2, purple 2, purple 3, yellow So I'd only like to only keep duplicates if the first and second field each have a match in the data. Any ideas? Assuming it is ETL somehow but can't…
-
Magic ETL - filter with not in
Please forgive me if this is a stupid question but until this point all of my dataflows have been in mySQL or Redshift and I am trying to utilize the Magic ETL where possible looking for performance gains. Common scenario is to get a list of accounts and use that in a where clause to exclude those records from a result.…
-
Summing a field based on filter criteria
I am trying to create a summary number showing the percentage of the total that is "open" (as opposed to closed lost or closed won). I have been playing with beast modes and have not been able to figure out how best to display this. As an example, we would have 400 accounts that we are displaying trends in a card, but the…
-
Hour-over-Hour for the past 24 hours
Hi, I have been trying to figure out how to graph performance of applications for each hour in a rolling 24-hour period (and once I get that then I need to do it hourly for a rolling 30 days). My database behind the scenes is a MySQL database where I added a calculated column so that I would have just the date and the hour…
-
HTML in Textbox Cards Type isn't Available ?
Hi All So im trying to use HTML to format the conditional colour in text box cards, but it never work and it always end in failure (means the colour doesnt change based on formula, instead they show literal formula). Im attaching the image of the formula result in attachment Basically the formula in beast mode is looking…
-
Beast Mode Syntax error
Hi, I would greatly appreciate some help with this beastmode. The idea is to calculate what % of the remaining sales quota for the quarter each open deal per salesperson is. I want to divide the Open deal value by (Quota - Value of all Won deals) 100000--this is the quota, manual input case when `Status` = 'Open' then…
-
Adding Chart to Table Cards Using Beast Mode
Dear All I stumbled upon this amazing knowledge base article, which is contains information about adding graphics, links, and images to table cards using Beast Mode…
-
Trying to calculate with multiple conditions in Beast mode
I have this created in excel and it works perfectly, unfortunately, translating it to a case statement is proving to be difficult. here is the case statement I am having issues validating with by the way, I have created a beast mode with the calculations already and it is working, unfortunately, with DOMO's limitations in…
-
Benchmarking leads against an average
I have a dataset that aggregates all contact us form submissions submitted within my website for all of Australia. I've got DOMO setup already showing me cards with breakdowns on the number of leads by state, store size, and individual store which are great, but the sales team want more (of course). I need to be able to…
-
Historical Comparisons
Hello, We have completed our 2nd full year in Domo and we are starting to see performance issues with the dataflows. We have been integrating data sources left and right and our instance is around 500M rows. Not sure if that is typical or not but it should give you an idea of the data we are processing. Some of our…
-
Conditional Formatting
Hello, I've seen some other posts about conditional formatting, but they involved html and I have extremely limited coding ability. I'll explain what I'm trying to do below in case there is an easier way or I'm not approaching it from the right angle. Thanks in advance! Say I've got two variables: 1. Sales Quota 2. Actual…
-
Sum by using unique values in a different column
Hi there, I'm kinda stuck here, I've read other similar threads on this topic but I don't think any of the solutions applies to me because I'm using the global filters on the page quite a bit here. Below is an example data set Activity IDActivity CategoryEmployeeOrder IDOrder…
-
ETL内でSQLを書けるようにはできないのでしょうか
SQLで全てコーディングできるといいですが、 SQLの知識もあまりないため、ETL活用させてもらっています。 しかし、ETLで出来ない機能については一度出力して変換、再出力でETLに戻す工程が発生しています。 ETL内の機能でSQLを使用した処理を書けるといいのですが、機能として存在しますでしょうか?
-
Can we use variable and temporary tables in MySQL data flow ? Something similar to storeprocedure?
Here is the problem that i am currently facing. I need to Alter table column name at run time dynamically being based on some dataset mapping. Is there a way I could use variable, temporary table or store procedure in MySQL Data Flow so that i can create a dynamic ALTER statement and execute it? Following is what I am…
-
DataFlow - Quickbooks - Picking up Edits
Good Morning, Experts! I wanted to resurrect a question I had asked previously. The question encompassed a dataflow that was built. In the data flow, the data flow is bringing in inputs from 4 separate Stacker jobs that aggregate data from dataflows from various Quickbooks (QB) jobs (Accounts, Vendors, Class and GL). In…
-
Renaming Input ETL dataset
Hello, I was wondering how in ETL mode, how to change the input dataset name. Whenever I input a new dataset, the name is the same as the input. Is there a way to change that? There is one dataset that has different name and not sure how this was done. Thanks
-
Does anyone know how to solve "invalid data" in output dataset?
I tried to join two datasets. Everything looks fine but the invalid data in the output data. The preview table in output data looks great, but I can't assess the data when I am creating a card.
-
Beast Mode Help: Calculating Hit Rate (Projects & Quotes)
Here is a short video overview of what I am trying to accomplish: https://youtu.be/Dz_uXS1OGco In simple terms the Project Hit Rate is the Count of (distinct) "Project Name" where "Convereted to Order?"='Yes' divided by the total Count of (distinct) "Project Name". In simple terms the Quote Hit Rate is the Count of…
-
Replace dataset that has many beastmode calculations
Have a very large dataset (5M rows) from a connector that we need to clean up by exporting the data, de-duping and replacing the dataset. The dataset has a large number of saved beast mode calculations (2 dozen). Will the beast mode caculations be preserved when we reload the data?
-
Date Trunc in Redshift
Domo Community, I am trying to rewrite this calculation in Domo but keep getting a "FROM" error where the Dataflow is not recognizing the input data set. Have any of you ever encountered or used this type of statement? SELECT sum("Process Time") FILTER (WHERE date_trunc('month', "Date (Lead Created)") >=…
-
Are beast modes in dashboard cards calculated/updated client side or server side?
Are beast modes in dashboard cards calculated/updated client side or server side? If someone is viewing the dashboard on a more limited machine, will it take longer to load a full dashboard of cards (which are based on beast modes)?
-
how can I exclude one min and one max in a dataset
basically, its a survey dataset that have a score of 1 to 10.. every quarter, we need to exclude 1 lowest and 1 highest. currently we are doing the manual exclusion of the lowest and highest, we're wondering if we can do it in beastmode
-
Running total: ETL or MySql?
I want to create a running total that resets every year. I've seen posts for doing it with ETL and a window function and others for MySQL and I am lost on which way would be best. The data table is similar to this : Month Revenue Reimbursables 1/1/2018 100 5 2/1/2018 97 11 3/1/2018 102 8 etc. In ETL, I calculate the Net…
-
Use Beast Mode to Change Column Header Name
How do I create a beast mode statement to change the name of a column header? For example: Column Heading = X and I want it to be changed to Y.
-
Best mode - combine MTD and YTD
Hi there! I have a problem with beast mode. I think the solution is easy, but I can´t figure out the correct function in beast mode. We need to display sales of our team. Therefore I created a table with team names and sales MTD and Sales YTD. My datasource includes a field called season (our business year is from May till…
-
Decimal to DateTime
My data for date is being imported as decimals in a text format. How do I convert this 43497.241179 to date time? Using magic ETL or beastmode.
-
Waterfall chart with annual values at each end and variances as waterfall steps
I'm trying to create a waterfall chart, where the first bar in the waterfall is the absolute value for 2017, and the steps in the waterfall are the variances in each category. This should result in the summary bar being the absolute value for 2018. My best solution so far is to create a new category for values in 2017,…
-
How to check date between two Dates?
I want to check Pick up date between two date columns . See below. I am getting an error Invalid formula (CASE when `type`='PICKUP' AND `pickup_date` BETWEEN `appt_start_time` and `appt_end_time` then 1 end)
-
Count Number of Log Ins this Year (2019)
I would like to create an insight card that divides the number of Last Logins in 2019 (125) against my total users (214) to show total percentage of users this year (58%). I am attempting to show this through a chart type of Progress Bar, Filled or Compartive Gauge (any suggestions appreciated). However before I can create…
-
Splitting columns with custom deliminator
Hi, I'm trying to split my column in my data flow and the data in the original column is formatted as, "Stretch Wrap & Strapping - Copy". I want to split this column such that the "Stretch Wrap & Strapping" is in one column and the other column reads, "Copy". I tried making my custom deliminator, " - " however the split…