-
How do I delete records in an ETL data flow?
Good Day, I have an ETL data flow that is recursive in nature updating Google Analytics data on a daily basis. A subset of data was missing so I appended another dataset in the flow which was ultimately in error. I am attempting to delete the data which was ultimately in error and replace it with new data. I'm not sure how…
-
Help for nested case statement in beast mode
I have these two measures made in beast mode that looks like this: Status CASE WHEN `Delivery` = 'Done' THEN 'Complete' ELSE CASE WHEN IFNULL(`Quantity`, 0) < IFNULL(`Order Quantity`,0) THEN 'Pending' ELSE 'Complete END Completion Percentage ( COUNT(DISTINCT CASE WHEN `Delivery` = 'Done' THEN CONCAT(`Company Code`,…
-
how to use the percentage of a category as the summary number
Hello, I have this card that looks like this (Showing only one month's data) What I want to show in the summary number is the percentage of expired category(14,131 / 8,961+14,131) that is made available when you hover over the chart (61.19%). How do I do that for the summary number? Thanks!
-
Beast Mode assistance (issues w/month-over-month calculations for 12 month table)
This is a followup to a thread from last month (Table, compare several month-over-month). We've created a table card that for the most part function as requested, but noticed a few things that need to be accounted for and we haven't been able to figure those out at this time. In the screenshot below, we have a…
-
Creating an arbitrary date field unrelated to data to hold every date that exists
I'm trying to recreate a chart that compares Created to Resolved issues (based off JIRA data). How it looks in JIRA below Where i'm running into trouble in Domo is that I think JIRA just creates a random new date field/range on the fly that isn't included with the data when pulled over. In Domo I have to choose what field…
-
How do I translate these report format in Excel to Domo?
Hi, I have these tables that looks like below: The formula shown is for J12, and going from J12:V16 they have the same syntax of formula like that. Other numbers are manually input or linked from other sheets. Now, how do I replicate the report format and the formula in Domo? I have tried using Beast mode to solve this,…
-
Splitting comma delimited keywords and combining in one column
Use case: For every account I have a set of comma delimited keywords stored in 1 column (think "SaaS,business,b2b,etc"). I ultimately want to create a list of all unique keywords, then compare that against my dataset to measure frequency ("How many accounts contain "SaaS"?) My feeble attempt: I've managed to split the…
-
Calculating hour differential over multiple days
I'm trying to calculate the number of hours elapsed between when a given event occurred and the current time. Both are formatted as "DD MMM YYYY HH:MM: SS". Basically, if the event occurred at 01 Jan 2019 12:30:00, and the current date is 03 Jan 2019 12:00:00, I would like the output to be 47:30:00 Thanks!
-
SUM of CASE in Beast Mode
Hello, I would like to create a beast mode which can give me a % of a column in a table (e.g. % OCJ Actual) like such: Marketing IntentFY GoalOCJ Actual% OCJ ActualCOLLABORATION5,000,000500,00010%SECURITY5,000,000500,00010% The beast mode formula seems correct but I am getting this error 'An issue has occurred during…
-
How do we data mask in DOMO ?
I need to data mask some of the data that is coming from SFDC, successfactor. Do we have any automated function in domo we can do with ?
-
Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.: * Project Parent = Self * Task Parent = Project * Sub Task Parent = Task I'd like to be able to have a column that…
-
Period over Period card, Last 'n' weeks compared to 52/53 weeks ago = How to EXCLUDE current week?
I have a BigQuery dataset that updates daily, but is one day behind on purpose. Today is Monday, so the lastest data that I have is from Sunday. My company is working on a Mon-Sun fiscal calendar, and, yes, it IS optioned for our instance. I am creating a "Last 5 Weeks" grouped bar card, with comparison enabled to 52 weeks…
-
Columns with 2 Unique Values (1,0), into one Column
Hoping someone can help me solve this. I have a dataset that has multiple columns with a 0 or 1 value. I'm trying to combine these multiple columns into one using a beastmode, naming those values with their respective headers - So: (CASE when `Business Change` = 1 then 'Business Change' when `Division Change` = 1 then…
-
Incorrect Column Type Preventing ETL
I'm trying to use Magic ETL to transform a dataset using rank&window and remove duplicates. My ETL keeps failing due to the error "Failed to parse data as integer for column". I attempted to input a "Set Column Type" step connected to input but the ETL is failing at the "Input Data Set" stage and never reaches that point.…
-
Can DOMO add functionality for certifying a dataset/dataflow in DOMO?
I've really enjoyed the new Certification process for cards. I've seen on other threads as well that it has been requested to expand that functionality to pages and collections which I agree would be very helpful. An additional thought/request I'd like to throw out there is the ability to certify a Dataflow or Dataset. It…
-
Finding the "Growth Rate" of a metric in Beastmode
We are currently building a dashboard where looking at change over time is critical - ideally how we'd like to accomplish this is by measuring the growth rate, or change in the metrics over the period set by the analyzer. Is it possible to calculate this in a beastmode while still retaining the ability to change the…
-
Net change of facebook followers in 30 day period
I am trying to make a calculated field which determines the net change in facebook followers in the last 30 days. The data has columns: exampleDate: November 04, 2018 1:00:00 AMTotal Page Fans: 262 How can I determine the number of fans 30 days ago, and yesterday and output the difference for my card? I am very amateur at…
-
How to show week-by-week comparisons in grouped vertical bar cards where the weeks roll-over years?
When I got into work this morning, the Grouped Vertical Bar cards which I had built to show week-by-week comparisons of THIS year's values versus LAST year's values were all broken. The Beast Modes that I had created to differentiate by week were all malfunctioning because today is Wednesday, January 2, 2019, and the end…
-
Nested UPDATE statement not populating column
I am trying to update a dataflow with MySQL. I have a report being pulled into DOMO from Salesforce and I altered it as follows: * connected Salesforce report to DOMO * Used ETL to filter the data into five buckets. (Marketing Channels) * Created a new column: 'Sub Channel' - value: NULL * Output as its own ETL dataflow I…
-
number of days in a month
I have a monthly amount that I need to spread equally over the number of days in the month. The data looks like this: Month Value 01-Jan-2012 100000 01-Feb-2012 121002 01-Mar-2012 123123 01-Apr-2012 118239 I have to spread the Jan amount over 31 days, the Feb amount over 29 days and the March amount over 31 days. So I can…
-
Beastmode to manually add annual target - entered value is not appearing on card
Hi, I'm trying to use a beastmode to add annual target lines to a bullet chart. Below is my case statement: Case When `fiscalyear`='2018' then '1900000' When `fiscalyear`='2017' then '1500000' When `fiscalyear`='2016' then '1500000' End We have fiscal year defined in our DOMO configuration and I've selected it on the card.…
-
Redshift Performance Problem
I have call center data that I pull in through inContact and I need to add a date field from a date/time field in order to not have problems with time. To do this, I've made a redshift flow that selects all the fields and truncates the date/time field to a date field: Select field1, field2, ...,…
-
Using IN Beast Mode for multiple matches won't SUM
I've got a Beast Mode I built and it calculates as expected except that instead of returning the sum value of all matches it returns a row for each match. Here is the Beast Mode: SUM(Case when `title`IN ('Metal Technician','Refinish Technician','Frame Technician','Prepper','Mechanic') then (Case when…
-
A column in this calculation does not exist when it does
Hello guys, I am trying to get a calculated field with case when. However, the calculation keeps saying that a column does not exist (when it obviously does) Do you guys know what might have caused this problems? Thank you!
-
Days since last Wednesday
Hello. I'd like to make a calculated fiield to show datediff('end date','last thursday'). how do I represent 'last thursday' in that? The 'end date' is a sate in my data.
-
Combine multiple results into one row/cell
How to take multiple results and combine them into one row, see attached.
-
Replacing IFNull value based on a separate key
Hello and thanks to anyone who responds to this in advance. I'm relatively new to using DOMO and have been experiencing issues trying to replace null values with the corresponding data. The report that I am using was exported in a weird manner due to how our back end is structured. The primary key (Project ID) exports 2…
-
Beast Mode Help: Summary number to show % of transaction type
I have a dataset where there is a column name 'Ship Via Group' that contains three distinct values. One of which, "Counter / WC" I need to show in the summary number for the card - "What percentage of orders are Counter / WC?" Sample data is attached, note that order number may appear multiple times because orders may have…
-
Removing duplicate from group by strings separated by comma
Using the ETL tool, I've got a column that is ALMOST exactly what I need. I'm trying to identify the sales type mix of a customer's basket with the number of units in the basket, see image for example. What I'd like to do, though, is remove the duplicates from that column. For instance, in the row that has '2' units with…
-
Missing value for divisor in formula
Hi all, I work in a consultancy firm and for us a key metric is billable utilisation (amount of billable hours in a period / available working hours in a period). I have three data sets which get connected and transformed through an ETL: - Input 1. Time report - which includes all hours reported by our consultants…