-
Using LIKE operator in Beast Mode
I am tryign to sum values based on two criteria. This is what I have come up with but it says there is a syntax error. I am not to sure how to use the LIKE and IN operator as I could not find much info on them. SUM(DISTINCT CASE WHEN `Travel Location` like 'Domestic' and 'International' THEN `Entered Hours` END) Thanks!
-
Trying to combine two different case statements
Hey everyone, I am currently trying to combine two case statements. I have written this statement: CASE WHEN DATEDIFF(`actual_ship_date`,`release_date`) < 2 THEN 'A' WHEN DATEDIFF(`actual_ship_date`,`release_date`) <= 3 THEN 'B' WHEN DATEDIFF(`actual_ship_date`,`release_date`) <= 4 THEN 'C' When…
-
Hover Results on stacked bar Graph
Hello, Is there a way to have all of the results show for the corresponding Bars when hovering over a specific result? Example: When I hover of the "F" Category in my card it highlights all of the other "F" categories within the card as well. But it does not display the results in all of them, it only displays the results…
-
Updating data in a dataset based on date
Hi Everyone. Long time lurker first time poster (please be gentle) I have a dataset that contains a lot of customer data (not to brag or anything) and I'm trying to update the customerID column for one specific customer from 123 to 456 only when another column "event date and time" is before 8/1/18. Essentially, I want all…
-
nested case for arithmetic operators
Hi, I've been having troubles with MySQL dataflow trying to write a code basically doing something like this: (CASE WHEN week = 1 THEN (a/b) END) - (c/d) * e i tried writing it down like this: (CASE WHEN `Week` = "1" THEN SUM((CASE WHEN `8Q` = "POR" AND `Fiscal_Year` = "FY19" THEN(`8Q_Price`*`Tons`) END)) / SUM((CASE WHEN…
-
Adding a new date column which is based on another Date column
Hi, I am trying to build a card that shows the items and the date it goes out of stock and the date it comes back on stock. I have the following dataset: Item Country Date In_stock In_stock_previous_week A USA Sep 17 0 1 A USA Sep 24 0 0 A USA Oct 1 0 0 A USA Oct 8 1 0 A USA Oct 15 0 1 A USA Oct 22 0 0 A USA Oct 29 0 0…
-
Beast Mode Embedded True/False
Hi There, I'd like to create a beast mode so that my pie chart can create all the options. I currently have a beast mode that has a true/false statement indicating which cells have been updated/not updated. I want to return the count of all the not updated as well as options A, B, and C. I'm not sure who to return all of…
-
Finding Average Depending on Warehouse
Hey Everyone, I am trying to make a card that finds the average of each warehouse depending on how quickly they unload a container. Then I will be giving them a "Grade" (A,B, C, D, F) depending on there average for the Year, Quarter, Month, and week. The thing that I am struggling to figure out is how can I have domo do an…
-
Return the value based on the most recent matching the criaterion
Hi all, please help to resolve the following issue. I Have a very huge dataset showing the following and I need to fill the column "Currency 2/ USD" with values: # Time; Cur 1; Cur 2; Pair; Price; Currency 2/USD 1 2:00 pm EUR ; USD; EUR/USD 1,165 1 2 5:00 pm EUR ; USD; EUR/USD 1,167 1 3 5:01 pm UAH ; EUR; UAH/EUR 0,032…
-
Replace Undefined/Blank with a value in Beast Mode
Hi, I am calculating accuracy with a formula inside Beast Mode: (A - F) / A * 100. There are few instances where the denominator is 0. For those instances, I am getting blank values as shown below: I want to replace the blank/undefined with a different value I tried to use the CASE and IFNULL BeastMode functions but that…
-
Beast Mode Turning numbers into a Letter Grade
Hey everyone, I am currently working on a project where I have built a data set to see the turn around times on our containers coming in to our warehouses. I am trying to make it so that it will assign each warehouse a letter grade depending on how many days it takes them to empty out a shipping container. I have been…
-
Fiscal calendar in Beast Mode
We have the fiscal calendar feature enabled in DOMO. I want to convert a transaction date into its fiscal quarter. Is there a way to do that?
-
Add group by as an additional field
Hi everyone, I am looking to add a column to a dataset where I join all my users and their orders (could be 1 or more) and get a count of how many orders an individual user has placed. I pulled all the columns I want in my ETL dataflow, and then calculated this field using the "Group By" transformation. I group by…
-
What is wrong with my formula?
What is wrong with my formula? both columns exist in this card. i don't understand.
-
Aggregate data from multiple columns
I am attempting to aggregate (or subtotal) the number of cars by destination whse and then by PLA (date field). The yellow column below shows the output that I am looking to create. Beast mode? SQL data flow? ETL? Any help here would be appreciated.
-
Grouped Running Total Bar Card where Each BarValue Consists of a Percentage of a Total in Beastmode.
I am having difficulty making a particular card to work. I am attempting to make a Grouped Running Total Bar card. But instead of number values... I want the bar to represent a percentage to a total of value in particular fields. There is one text field called Preference_Type and it contains a '1' or a '2' value, denoting…
-
[Join dataset with Regex]
Hello guys, hope you have a nice day! I am joining 2 datasets with slightly different keys. One has the structure of [random characters] + [value] + [random characters], and one is value. Could you guys suggest on how to join these 2 dataset? I'm thinking using MySQL join, combined with some regex. However I could not find…
-
Beastmode Help: Determine if order is <= $50,000
I've got a dataset that contains order data at the line item level. An order could have 1, or many items. I need to create a flag column that indicates if the total order value is <= 50,000. Would like to do this with a Beastmode if possible. The unique identifier in this case is the order number, and the extended price is…
-
Beast mode Case Statement
I am trying to do an "If" statement in beast mode (which means I will need to use a case statement). If the "warehouse column" has a cell in it that cointains CA or WA I want it to subtract 5 from the cell in the column port to warehouse days.If the "warehouse column" has a cell in it that cointains GA I want it to…
-
Re: Window functions missing from MySQL
Hi, My data source is a flat file from FTP and i am using the SQL data flow in Domo for data transformations. I have a need to use rank function and am wondering if i can use rank() over window partition by method. I can use the MySQL method mentioned at below link, but the window method is throwing errors. Does the…
-
Select with an AND Condition
Hello, I have some sales document data [Sales Doc] [Line No] [Product] 1000 10 X 1000 20 Y 1000 30 Z 2000 10 A 2000 20 B 2000 30 Z 3000 10 X 3000 20 A 3000 30 Z etc.... My requirement is to have a user be able to select products (A user could select any combination of products), so in our example the pool of products is…
-
generate url if condition is met
I have 2 fields: * has_preview * Preview_url for the Preview_url field I am using beast mode: CONCAT('<a href=', CONCAT('https://full_url_',`presentation_id`,'.mp4 target="_blank"'), '>','Preview', '</a>') I only want the 'Preview_url' field populated if 'has_preview' field has a value of 'yes'. Any ideas how I can achieve…
-
MAX Price
I have a list of suppliers and their prices. Is there a way in Domo to find the lowest and highest prices and return the supplier who has them. Attached is an example of what I am trying to achieve Any Help would be appreciated Many Thanks Simon Gillham
-
Transforming Data before a Join
Hello, I've been trying out DOMO for a week now, and it seems to work a bit different than other BI tools. What I want to do, is add a calculated column to a table, based on a formula (in this case, based on DATEDIFF since I want to calculate Age from Date of Birth). After this, I want to add a conditional column Age…
-
How can I extract values from one column and create 2 separate columns?
Hi I have a column in my dataset with values that looks like "711-500001-3068-22-STL-000000-00000000000". I wanted to take that value and create two columns. First column will have the value of "3068" and second column with "22". What's the best wat to accomplish this?
-
Series Formatting (various types, i.e. Currency, Percentage, etc)
Just closed out a case w/Domo Support on this on this request; it's not built in functionality at this time though a good argument was made for it to be considered for a future release and it was submitted as an enhancement request. Were trying to show Total Cases (Y Axis, this is no problem), but then also show Total…
-
Beast Mode - Separate Running Total into Daily Values
I'm using the Search Users report in the Twitter connector to pull the number of followers for a particular user. I have it set to run daily and append the new data, which gives me the running total for twitter followers for the given user. I'd like to create a beast mode calculation that will give me the number of new…
-
Grouping Dates with consecutive weeks
Hi, I have to visualize Projected Out of Stock Items and the date it goes out of stock in the inventory. I have a table which shows when the item may go out of stock. This table shows the Projected Inventory for every Monday of the week. Item Location Projected Inventory Date A1 L1 0 Aug 20, 2018 A1 L1 0 August 27, 2018 A1…
-
Beast Mode for Conditional Formatting of Standard Table
Description: The following Beast Mode examples will help you create conditional formatting on a standard (non-Sumo) table which I've used in the instances that a client needs a modified drill path table view. At present, these options are not available w/in Sumo tables but may be as development continues. Please up-vote…
-
How to sum over a row
I'm building a card where each row represents a client and each column represents the features they have enabled and the ones they actually use. I need to sum over the columns for each row to count every cell that has a zero or a one to come up with the total feautures enabled or used per client. I've tried with a beast…