-
Multiple date columns (count) from single dataset - using 12 month calendar NOT from dataset?
I've read several posts on things simialr to this, but not sure that this exact issue has ever been brought up or of it's even possible. We've been running into an issue when trying to create a Line + Grouped Bar chart that would require data from two separate date columns (ReviewedDate and ResolvedDate) in the same…
-
year over over comparison
I trying to build a line graph that is comparing previous years. X axis is showing months y axis showing values
-
Summary dataset (from detailed dataset)
We have a dataset (agent hours) that contains cumulative/summary data by status/day, and a beast mode to determine the total number of hours worked (something along the lines of start time - non work activities/statuses - end time = total actual hours worked), plus another dataset that is detailed/transactional for…
-
Using a Beast Mode Calculation in Summary Number
Hi, I'm trying to create a beast mode that will allow me to use CASE WHEN COUNT as a summary number and I'm having some trouble. I've tried this with SUM and AVG in front. I've tried subtracting the Like count from the Not Like count. I'm not sure how to turn this into an aggregation so that I can use it in the summary.…
-
Employee Tenure Based On Hire Date
What is the Beast Mode Formula for calculating employee tenure using their Hire Date? I am trying to create a card that shows average tenure per office.
-
compare field with current date
I'm trying to compare a field birth_date which I have converted to just show the month and day as DATE_FORMAT(`birth_date`,'%m/%d') with the current date to only return the records where their birthdate = the current day I tried the following but didn't work if DATE_FORMAT(`birth_date`,'%m/%d') =…
-
How do I use Fiscal Year in a Beast Mode?
I'm looking to create a case statement to indicate the fiscal year that a transaction occured in. Here is what I have so far: case when `SHIP_DATE` between '06/01/2014' and '05/31/2015' then 'FY15' when `SHIP_DATE` between '06/01/2015' and '05/31/2016' then 'FY16' when `SHIP_DATE` between '06/01/2016' and '05/31/2017' then…
-
Get value from a column for the most recent date on the dataset
How do I pull the data for the most recent date from another column in the dataset using beast mode?
-
Filters on Calendar Week
We have Weekend Dates to be filtered for viewing Sales, But Business is used to filters Like between June Week 1 & Jun Week 4. In Domo, I saw we can filter on Dates, I have modified the weekend date to be that corresponding month & week number, But with this option Dates get converted to string, and they dont get to see…
-
Percentage Calculation per Opportunity Owner
I am trying to determine the percentage of opportunities (by count) in (A,B,C Stage) / (D Stage) per Opportunity Owner. I am getting lost on the formula in Beat Mode as well as how to summarize these per Opportunity Owner. Essentially, I want to see a graph of each opportunity owner and the percentage of opportunities they…
-
HTML/CSS issue (Summary# data showing on separate lines)
Did a lot of reading from previous posts about using HTML/CSS in Summary#'s and wanted to give it a try for a card, and while it looks great and provides a very effective quick view to determine lost time, can't seem to get this to display properly, i.e. on a single line (we wanted to make the lost time standout, using RED…
-
Concat percent sign (%) after a beast mode calculation. Syntax Error
Hi, I created a BeastMode calculation to create a basic percentage value. However, when I try to enter the formula into a concat it give me syntax error. Works: count (`Have License`) / count (`Total Users`) * 100 Does Not Work Concat ( count (`Have License`) / count (`Total Users`) * 100), `%`)
-
Avg. Created Opportunities
Hi, I'm trying to create a Beast Mode calculation that will let me see the average opportunity by month (distinct by year) over all time (not actually broken out by month, but by individual who created them). Currently I have this, which counts as several years being the same month. How do I group them easily to be…
-
Adding Two Rows
I have a dataset listed below: Year Gain Loss Net 1999 10 5 5 2000 15 20 -5 2001 12 9 3 2002 19 8 11 2003 17 21 -4 2004 18 3 15 I need to create a new column that has a sum of all active clients for that year: Year Gain Loss Net Active 1999 10 5 5 5 2000 15 20 -5 0 2001 12 9 3 3 2002 19 8 11 14 2003 17 21 -4 10 2004 18 3…
-
Selecting from multiple tables based on conditions
I have the following code where I am pulling all data from one table, a. Then counting a column from a different table as a new column. However, I am getting a syntax error message. Can someone point me in the right direction? select a.* ,(Select count(DISTINCT b.Employee) as `Number of Distro` from `transform_data_9` b…
-
Average Deal Size
Hey guys, We're looking to take a dataset from our CRM and SUM a column with all of the values in the value column ONLY if the deal is won, and then divide it by the count of Won deals. How would we do this? Trying to see year over year how big our average deal is...
-
Is there a way to convert a numerical value to a string in beast mode?
Hi - I found many discussions around converting a string to a number, but I wanted to convert a number into a string. Is that possible in beast mode? Thanks! Eva
-
Recursive dataflow not storing historical data
Hello, In our data team, we are trying to build a recursive SQL dataflow to save historical data and append new data as the original dataset is updated daily, following the instructions in this post: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_SQL_DataFlow. However, the…
-
Beast Mode Calculated Field
I have the P&L file upload from QB to Domo in the attached format. I want to calculate the GP which is Income-Expense. How can i do this in beast mode?
-
NULL Values
NULL Values seem to cause some confusion. First, when filtering on a field that has a NULL value and you select that as a filter, it does not provide any results. Secondly, when adding fields, where a NULL value may exist, it won't necessarily add together, but rather provide a NULL result (10 + NULL = NULL). I have seen…
-
Percent Increase Decrease
Hello, If I have many columns for ex: "2010 population" "2012 population" "2014 population" and I would like to show the % evolution between each of them on the graph how can I do it? If beast mode is the way to do it I will then have 3 columns "2010 population" "2012 population" "2014 population" then 2 columns "10/12…
-
Beast Mode - UTC to Mountain Time
Hey! I need help with doing a beast mode calculation. I have 'Date SO Created" and it has UTC time zone, which I need to convert to Mountain Time. The data is shown as "6/4/2018 2:41:00 AM" I heard about CONVERT_TZ and I have tried plugging it in myself, but nothing is validated. Thank you!
-
Effect of adding new column to imported data on an existing dataset/dataflow and populating it
Hi, I'm trying to add an extra column to a dataset that I have an ETL on. What I'm hoping to do, is to take data that is coming in from a Netsuite connector and add on a column where I can mark if the customer product has actually been delivered. This is not captured in Netsuite, but is important to have in visualization…
-
Beast Mode Help - Special Rounding Case (round at up at .25)
Here is a video that gives an overview of what I am trying to do with a beast mode. https://youtu.be/g5j9gNDqtRw
-
Count Occurrences in String
How can I find a string within a String? My String looks like: COPD|ARDS|Pleural Effusion I am attempting to perform a count of occurrences like so: SELECT SessionNumber,EventDate, round(count( case when `Reg Category` = 'G' and `Interest Areas` LIKE '%Pleural Effusion%' then 1 end )/count(*) * 100,0) As…
-
I am looking for html language to hide metrics within a beast mode summary number calculation
Hey all, I'm looking for html language to use in a summary number beast mode calculation to hide certain metrics so only the month portion is visible. I'm looking to hide everything from view in the summary number after the (`Post Month`) portion of the first 2 lines. Is this possible? Here's the beast mode I'm using…
-
SUM of CASE in Beast Mode
Hi, I am trying to sum a column based on date value output from another case statement, but i dont see anything getting calculated when i check the formula. there are no formula validation issues. SUM((CASE when (CASE when DATE_FORMAT(`Date`,'%d')=1 then (CASE when DATE_FORMAT(`Date`,'%m')=1 then 'Open Month' else (CASE…
-
I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL...
I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL, so that I can group by month etc.
-
How to change/reroute specific values in a field and leave all others the same
I have a table card. It shows the amount of deals closed by each sales team. In some cases, sales reps change industry teams. I want to be able to say "If sales manager = Joe Smith, then change team to Retail" but since there are 100 managers, I don't want to go thru and put each one in since the rest of the mappings…
-
Beastmode to Group All Months into a Total Month
Hello, I'm trying to use a multi-line chart where I already have my years broken out but want to have the months be seperate but also have a total. Can you please let me know what I am doing wrong in this beastmode. It "validates" but the "Total" never shows up: (CASE WHEN (month(`Start/Invoice Date`) = 1) THEN…