-
Beast mode CONCAT() for creating a dynamic link in a table
I have a field in my dataset which I want to use to create a new field which is a URL in the below format - <a href="www.example.com/[`DatasetField`]" target="_blank">www.example.com/[`DatasetField`]</a> Where `DatasetField` is a column in my dataset. I am doing CONCAT like on the lines I have mentioned but it does not…
-
Calculating on a calculation
Couldn't think of the best way to title this but the description should make it clear. The calculation I need to do is a basic one but doing it isn't as straight forward as it seems. I'd like to calculate an average of the total work a team gets done in a set period of time and if you're familiar with the software dev…
-
Calculating Score Domo with Variable
Hi, I am trying to calculate a score from different fields using CASE in domo but it seems we cannot use variables in beastmode and I am facing dificulties. Each of my columns have values which I want to translate into a score and then sum up the final score for a line. ie: If Field1='1" Then score=20 + If Field2="Yes"…
-
Deleting dataflow and datasets
Is there a way to delete a dataflow and all its associated datasets/cards? It's irritating to delete a dataset, get navigated away, find the dataflow, delete the dataflow
-
Division - Beast Mode - Exceptions
Experts, So I have a division formula that we built in a beast mode. Some of my data on the bottom part of the divisor comes up as 0. So what I did to account for that is to do a NULLIF. However, when you divide by NULL Domo freaks out when you are trying to present this in a card. What ways would you recommend to…
-
Beast Mode not calculating for Current Year to Date
I am stumped on this one... I created a beast mode to calculate the number of rejections as a percentage of sales. Specific lines of data have reason codes to flag what type of transaction it is. So F, H, etc are specific type of rejection lines. The "0" is a normal sales transaction. The beast mode below calculates…
-
When do we use Magic ETL and SQL data flows?
Hello everyone Im new at Domo. When I want to transform and combine my data, is it better to use magic etl or sql data flows? Does it matter? Ive already made some experiences, they both work fine. Is there a difference? Thanks for your answers.
-
Beast Model for Calculating Average of Values for lines which meets certain conditions
Hi Everyone, I have looked through several posts to see if this was already discussed, but couldn't didn't quite find what I was looking for. I have a dataset that contains a date column representing the week for which the data is for. I would like to calculate the average of values within a 6 week period from the original…
-
Issue converting string to number in beast mode
I've seen some others posts about this and have gotten this to work on other cards but I'm having an issue converting a string to a number on this card. I've tried `Field_name`*1 and I've tried CAST(`Field_Name` AS DECIMAL(10,2)) but I get back a 0 or null response in the newly created column. I've also tried a CASE…
-
How can I display year over year counts of volume by physician?
Hi, I'm having trouble trying to get my physicians on a card and do a comparison of their volumes year over year on the same card. See attached graph.
-
How to use count distinct
When I do count(distinct) it is saying that is not a valid formula. Below is my formula. I am counting the sales names named (SalesHost), but against their sales and I want to sum the sales. I added a beastmode to calculate the rank, but need to get rid of the duplicate sales names. The first is invalid, but the second is…
-
Looking for an equivalent to 'SELECT column_name WHERE IN' for beast mode.
Is there a Beast Mode equivalant for this SQL? Can Beast Mode even accomodate something like this? select * from TABLE where ResolvedBy in (select distinct ResolvedBy from TABLE where AssignmentGroup = 'IT Ops T1 Tickets' and ResolvedBy != '') and AssignmentGroup = 'IT Ops T1 Tickets' order by ResolvedBy asc; I know it can…
-
How to build fact and dimension tables?
Hello everyone, I am new at Domo and need some help. I built a fact and several dimension tables (Star Schema), which are my data sets. Now I want to visualize the data, but unfortunately I can only choose one data set in a card. Is it posible to have a Star Schema in Domo? What do I have to do? Thank you
-
Calculate Variance of a variable from two date ranges
Hello I am fairly new to domo, and I am wondering how to calculate the variance of a variable in my data set from a specific time frame (Quarter 1 2019) and divide that by then variance from another time frame (Quarter 3 2018)? So far I have tried this, but this did not match with the values from a calculation in Excel:…
-
MySQL mapping fields to columns
I have a MySQL dataflow that contains all the metrics for our sales reps (new customers, pipeline, leads, etc.) from 8 different sources. I need to remove all the sales reps who are inactive/terminated, and I already have this field (Roster Status) available in one of the data sources (the Roster data). How can I remove…
-
Is there a feature in Domo similar to Tableau's level of detail expressions (LOD)
Hi, I am trying to do some cohort analysis calculations and I wonder if there is something similar to Tableau's level of detail expressions? It is better to explain what I mean by looking at this link with some LOD examples: http://www.tableau.com/about/blog/LOD-expressions Thanks,
-
Beast mode percentage of
I am trying to calculate the percentage of the total for each media. I will be using this on a table (media as dimention, spend as metrics). Here is my formula: SUM(CASE WHEN `media` = 'Radio' THEN `spend` WHEN `media` = 'A' THEN `spend` WHEN `media` = 'B' THEN `spend` WHEN `media` = 'C' THEN `spend` END) / SUM(`spend`)…
-
How do I create a column containing the max number from a ranked column?
I'm creating an ETL and need to create a column that lists the highest value from another column that lists ranking. If it helps, the ranking is based on date created on. Something that looks like this:
-
Dataset with weeks as columns, need to pivot weeks into one column
Hi, How can i pivot a dataset which has the weeks as columns? I need to create one column with the weeks and the values within another column. This will enable me to provide charts more easily. thanks for any ideas! i'm sure it's within redshift functionality, but i'm stuck. thanks!
-
Sort Table by Field Count
Hi, I have a list of locations in one column with a list of attributes in the second column. I need to count the number of locations attributed to each attribute in a table chart. How can i create this simple result? I haven't had accurate results using COUNT functionality. thanks!
-
question on calculation
for calculation trying to build "total bill" I need it to be column A + column B + column C, but there are times when column C is null, if I write it as column A + B + C only the rows with a value in C will fill in how would I do this calculation for both cases? thank you
-
Calculating a cumulative total in a sumo card
Hi all I'm posting in ETL/Dataflow as I assume this is where the ultimate answer lies. My end objective is I want to be able to present a simple table outlining my different customer cohorts (cohort is identified based on the month they placed their first order), and their average Gross Profit to us each month since…
-
Why does the DATE() function return the next date after 6:00 PM?
I have a dataset with a Date and Time stamp field. When I convert it to a date field using DATE(`date_field`) I am finding some unexpected results. The only way that I was able to get the intended results was to subtract 6 hours from the timestamp first: Is this an intended function of the DATE() function, or am I doing…
-
Custom Summary Number
Let me preface this by saying that I use custom summary numbers on a lot of cards and I format the html to include colors and symbols so I feel a little embarassed making this post. Recently I have custom summary numbers that will not work on one dataset but work on another. For the life of me I cannot figure out why, so I…
-
Field that returns 1/0 based on all similar values in the same column
Hello, This should be pretty simple but I can't find the solution. I tried fiddling around in ETL and beastmode, as well as googling, but was unsuccessful. Here is the problem: I am trying to create a column that returns 1 when any unique Job has a PO#. For example, in the second row there is no PO, however the 1st row is…
-
How to give an indicator for a time range
Hello, Can someone give me some suggestions on how to deal with my case: I have a table with project start date and end date, I also know $ of each project, now I need to get the total $ for all project for each month and also compare with the previous month $. This is what I was thinking: get avg $/month for each project,…
-
Download the Schema of a dataset
Is there not a way to download just the schema of a dataset? I'm doing some documentation and it would be really helpful if I didn't have to retype the field name and types of >100 fields. TIA!
-
Monthly Average
Hi, I want to create a Table Chart to show the service level by month for this Fiscal Year. I've created a calculation to get the service level --> (1-(SUM(`Lost Sales`)/(SUM(`Lost Sales`)+SUM(`Sales`))))*100 And now I want to calculate the Monthly Average of Service Level In a line chart, I can manage it with date…
-
Row size is wider than MySql supports. Please reduce the row size or number of columns.
OK so I have this one dataflow, DataFlow A, that feeds into other dataflows, DataFlow B and DataFlow C, that works perfectly fine until I try and add this one additional column to it called Lead Source. When I add this column to DataFlow A it runs just fine, however, DataFlow B and C then fail due to this reason: "Row size…
-
Using two different datasets with ETL calculator
Hi all - I am trying to convert values in a dataset using an exchange rate contained in another dataset. Which function in ETL will allow me to do this? It seems to me the Calculator function only allows one input dataset. Thanks for your help