-
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…
-
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), `%`)