-
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…
-
way to split column name into first and last
Hello, Is there a way to split a field if I have into 2? I have a field name, for example Bob Smith, can I split this into 2 so having 'Bob' and 'Smith' for first name and last name
-
Counting codes across multiple fields and re-labeling the codes
I'm a new user and trying to do some code counting aggregation. I have 5 columns of codes (Col1, Col2, Col3, Col4, Col5), and in each there are 20 possible code values for a data record, let's say the possible values fall within 00 to 20. Only 1 possible code per record per column. So data might look like: Rec Col1 Col2…
-
Add values from Web Form row as Columns to a Dataset
Hi, I want to use a web form dataset to allow a user to enter values for 4 variables. Basically, a single row with 4 columns for the variable values. I want to then add these values as additional columns to each row in another dataset. What is the easiest way to do this? The use case is, I want to be able to use the…
-
Ranking dates in a Beast Mode doesn't yield the right order in a card
We are trying to make a simple radio button display to put into a dashboard, and the date is in the format YYYY-Month. The default order is alphabetical, so the information is displayed 2018-August, 2018-December, 2018-July, and so on. (This is for FY19 data only, minus July.) So, one of my managers wrote a simple Beast…
-
Sum Previous 4 Weeks of Sales Together
Hi, I'm trying to sum our weekly sales data into 4 weeks of sales. For example, if we had $10 in sales each of the past 4 weeks, the value returnded should be $40. I'm using this function: SUM(CASE WHEN WEEK('Week Beginning') > WEEK('Week Beginning') - 4 THEN 'Sales' ELSE 0 END) But this is just returning the sales for…
-
Summing up sales for previous year
Hello - I'm trying to pull into a table on my card the following: Current Year Sales Previous Year Sales The calculation I'm using for previous year sales in beast mode is CASE WHEN YEAR(current_date()) = YEAR(`week_beginning`) - 1 THEN SUM(`sales`) ELSE 0 END or sum(CASE WHEN YEAR(current_date()) = YEAR(`week_beginning`)…
-
Break Line based on character for use in Mail Merge
Greetings All, I am seeking advice on how to add a break line to a string based on a specific character. I was able to get the table to look semi correct using ETL + Beast Mode. REPLACE(`String`,';','<br>') But I am unable to use my mail merge doc because the data doesn't doesn't export to excel correctly. I am a bit…
-
Day on Day Change Issue
Hi, I am trying to calculate the day on day changes of campaign activities (i.e. Sends, Receipts). The problem experienced is restricting the unique counts to one day because the code I've been using includes some records of the previous day. Depending on the time of viewing the domo cards, it takes the record of 24hrs…
-
Collapse columns based on value
I have a set of Call data where each row contains similar information in all columns but creates a new row based on the "flow" of the call. For example: LinkedId Leg LegType MenuName MenuOption Initial Queue Namebos-z15-call3-1550235827.1062618leg 1Dial curc-iready-qbos-z15-call3-1550235827.1062618leg 2Answer…
-
Running Customer Value
I am trying to build a card that show our customers' running total value (for the last 365 days). Here's the BM I have right now: SUM(CASE WHEN `SO Ship Date`<=`SO Ship Date` AND `SO Ship Date`>SUBDATE(`SO Ship Date`,INTERVAL 365 DAY) THEN `SO Item Total Amount` ELSE 0 END) Obviously though, when I graph it by month, I'm…
-
Dashboard not displaying Zero Sum results
I've built a dashboard for a variety of Adwords and Bing Ad results, and everything is working smoothly besides when I filter specific timeframes and the summation is zero, wherein it doesn't display anything in the Single Value field. I've created the following piece of code to try to mediate the issue and it doesn't seem…
-
How can I create a custom moving date range
I need to create a custom date range that moves with the current day. It needs to show the date range of the previous 10 days and the next 5 days based on current day. I can't seem to wrap my head around how to get started on it and if it can even be done in beast mode.
-
Adding year value to MM/DD date field.
I have a free text note field that we preface each note with a MM/DD format date. I am trying to add the year to this field so that Domo can chronologize this field and compare this free text date with things like system driven dates. I am currently using the following beast mode to extract the date from our text field,…
-
How to count unique value in a column
If I have a following list of data - 1,1,2,2,2,3,3,3,3,4,5,5,6,6,6 and I want to know how many unique value in this list, in this case, it's 6. How to do it in DOMO? Thank you!
-
Regular expression/RegEx cheat sheet and ETLs you can use RegEx in?
Hey all, I am extremely new to DOMO so I'm still adjusting to using this. I sometimes use the R plugin but I want to learn to use the ETLs as well- I am used to text mining and RegEx in R using stringR or grep. But, when I try to do the same search-and-replace operations using Value Mapper or Text Replace, my expected…