-
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…
-
Formula to find the last known order date for a customer ID
We have a table where we are trying to add up the customers total order value over a period of time and would like one column to note the last known order date for the customer. How would I write the statement to find that value?
-
Calculated Field not available as Summary Number
We're using Beast Mode to take the absolute value of another column, eg `abs(amount)`, and we'd like to use this value to calculate the summary number, but the field is not available in the drop down. All of the other posts I've read simply say that the summary number has to be an aggregate value, and that doesn't seem to…
-
Trying to calculate percentages for a group values
I am trying to calculate a percentage for each "Bucket". Less than 0 days past due 1 to 15 days past due 16 to 30 days past due 31 to 60 days past due I have each calculation and the formula works for each "Bucket" but I cant get them all in one beast mode calculation. Here are my formulas: Sum(Case WHEN `DaysPastDue`<= 0…
-
Using Date value within Case statement.
In the below case statement I am trying to look at product that is on order to our warehouse, and have it breakout by expected arrival timeframes. I am not sure if casting the `RDC_ETA_STATUS` as a date or using a value of current date() + is a potential way of creating the ranges so any help would be appreciated. (CASE…
-
Converting String To Date so it shows as an option for DATE FIELD in Summary Number
Good morning. Not sure what it is that we're missing but for some reason the only data avialable to choose in the DATE FIELD dropdown (series of screenshots below) is _BATCH_LAST_RUN_, which is not the date field we need to show CURRENT in the top level summary number. We've converted Last Viewed from text string to date…
-
Is there a way to convert a numerical string to a number value in Beast Mode?
We have a very large dataset (10+MM rows currently) and for some reason our fiscal week is located in a column formated as YYYYMMWW. I can use a RIGHT(`FiscalYearWeek`,2) to get the value for the week, but it's a string, not a number. Is there a way to convert this to a number so I can then compare it via greater or lesser…
-
ETL: SQL Set column type
Is there a way to set the column type of while you are creating the column in mysql? I have a column that I am creating based on a date (Min Cust Svc Start) and a comparison to another date (1/1/2015). I want "Min Cust Svc Start 15" to be a datetype column; however, it is defaulting to text. I know I can change it in alter…
-
Delete/Hide Rows
Hello, I have a page of cards with a page filter, however, I need to limit what can be seen/selected. The cards all have the column Region and show the following example data: RegionRevenueNorth$1,000South$2,000East$1,500West$750 North and South are both allowed to see each others revenue. And East and West are both…
-
Grouping/Filtering
Hello, Our main POS system allows salespoints to be assigned to salespoint groups. Salespoint groups are a commonly used filter in our reporting outside of Domo. One salespoint can belong to many salespoint groups (some belong to 8 or more). Outside of Domo I would setup a salespoint group parameter, retrieve the list of…
-
Adding a field with mySQL
Hello, I'm trying to add a new field to an existing data set via mySQL (my first time doing this). The new field will take data from my existing data set (Product Name) and re-assign a new name leveraging a case statement. Below is my code. I'm currently receiving an syntax error, which I'm looking for assistance on.…
-
Is there a way to use vector style data groupings in Beast Mode?
I am trying to find a quicker way to use grouped data values in a column to filter an issue. Let's say I want to say any records that are A,B, and D should be marked "Inefficient" out of column Alpha that has values A,B,C,D,E. In something like R I would do this by using a similar code: v-Inefficient <- c{"A","B","D"}…
-
Issue with basic calculation causing card to error out
I am trying to do what I normally would think of as a basic calculation in beast mode, but it is continuting to error out my card as soon as I add it to the table. I want to devide my revenue per client by the number of distinct cutomers. My table looks like this Client Customers Retail Avg Customer Smith 4 100 25 in Excel…
-
How to deal with the 1st of month for "Current month" filter
Hello all, Context : Each day, we feed DOMO with the data of the day before (for exemple today, the 1st of August, I have data until 31st of July). In some reports, I put only cards with "current month" filter to see the evolution through the month and I allow users to see the date filter in order to interact with the…
-
ETL: Calcs based on date ranges
I am using Magic ETL to load data. My data has columns for customer, month, product and revenue. I have created calculated columns in the ETL for the customers start month. I am trying to create a column that calculates the maximum monthly revenue for a customer within the first 3 months of their start date; this is…
-
beast mode within a beast mode
Hello, I'm creating a card based upon the changes in tenure buckets of our sales reps. I am using start date and "As of" date (or the date we import the roster data. "As of" would be today's date, for instance). From there, I want to bucket it into different ranges like "0-6 months," 1-2 years," and so on. Another piece of…
-
Transform task renaming Table + Adding "Create table"
Whenever I try to run own of my data flows automatically it bombs. When I check the dataflow transform task it always changes from "SELECT COLUMNNAME" to "CREATE TABLE" and renames the output tablename to something generic. Anyone seen this before?
-
Setting Goals for each Quarter in Bar Chart
I am trying to set goals for each individual quarter. My data is currently represented as a stacked bar chart and would like to make the goals a line. My series is calculating the count of each type of lead for each fiscal quarter. I am having trouble with my beastmode calculation setting the goal value of leads for each…
-
Issue getting Last_Day(`Date`) working properly in mysql query
Hi, I have a MySql dataflow that I'm having an issue with. I have this query that I'm working with and I'm trying to pull the latest NumProjects value in each month. In the output, I'm seeing that its showing the latest set of values twice because the values are different (I assume). This winds up throwing my chart off and…
-
Beast Mode Code
I am trying to write the following Beast mode code If a date field is blank then "CAPA Phase" else it is "Implementation Phase " the following case statement will not work case when `PA_PLAN_DUE_DATE`='' then 'CAPA Phase' else 'Implementation Phase' end
-
Using Total as figure in Beast calc
This might be obvious, but I couldn't find how to do this. Is it possible to use the total figure (row total) as an individual figure in beast mode calcs? I have tried to do the following calc: Amount/SUM(Amount) The above calc is only doing the calculation on a row by row basis and is not using the sum figure/total figure.
-
Updating Brand New SQL Table
What I'm trying to do with this sql data flow is to add to my data two additional columns based on one of the metrics in the origial input. Specifically, take DMA data and get a state and region column. But I'm running into issues. I planned to do this by editing the original data, create a new table with the desired…
-
Beast mode divide by zero error
Hi, I am stumped on a divide by zero error. I am calculating the weekly index by comparing weekly sales to the avg qtrly sales. Q3 and Q4 don't have results yet, so their value in the dataset is zero. How would I expand the case statement to correct for this error? Thanks!! Debbie case when `acct_wk_i` <= 13 then…