-
Convert Hex to Decimal
I have a hex data point that I need to parse and convert to numeric values. Has anyone done this and what would someone recommend? SQL?
-
ETL so much faster than SQL at joining
Not so much a question but a statement of my experience with DOMO I am not a SQL person (if that is a thing). I had only been using SQL to join datasets where ETL would run into the 10 000 repeats limit that would prevent it from running a Left Join. I later realised that you cna go around the 10000 limit by using a Right…
-
CountIf in BeastMode or ETL ?
Good Morning Community I have a 5M+ row dataset where I need to develop a "COUNTIF" function based on a 'Category" column (image enclosed/table below). Any help would be appreciate Data contains too many distinct categories to list individually in beast-mode by name - kindly assist. DatePriceCategoryReportCOUNTIF…
-
Is it possible to import Python packages outside of what's given in the ETL?
I'm trying to import the lifetimes package but I guess it's not included in the default python packages. Is there a way to import that or am I out of luck on this one?
-
Multiple filters in dataset with AND & OR conditions
NameCityTroopsSupportAXYZ10YBXYZ30NCPQR20YDPQR40NEMNO30YFMNO10NAMNO20YBPQR40NCXYZ25YDMNO35NEPQR45YFXYZ5NAPQR40YBXYZ25NCMNO35YDPQR45NEXYZ5YFMNO20N My dataset looks something like this with lot many rows. I want to find the sum of troops A has with Support (Support is Y) and for only XYZ and MNO Cities. I have tried…
-
Ifnull fails
I'm trying to work with Null values but not getting the result I expected. I want to display 0 when The Last Package date field is null, but when I do it, the card fails. IFNULL(LAST_PACKAGE_DATE,0) Here is a video showing that: https://drive.google.com/file/d/1kmObFFgnQ54lPLLcFh3N-3bUmB8NChrZ/view Any suggestions? I've…
-
Adding percentage to total but cannot apply a 'Sub Total' in table
Hi, I have added a beast mode to calculate the % of the total in the table (refer to far left column). Beast mode formula: SUM(`EP`)/SUM(SUM(`EP`)) OVER () However, it now gives me an error when I insert a sub total in the table. How can I fix this issue so it can show the sub-total or total row in the table? Thank you.
-
Beast Mode not available to add to Summary Number
I have a simple question that is frustrating me. I want to create a Customized Summary Number. So I tried creating a simple beast mode using Concat. It was something real basic such as: CONCAT(`Total_Sales`,' Total Sales and',`Total_ROs`,' Total ROs for all') And this Beast Mode is not available to be selected as a Summary…
-
'OR' condition possible with ETL Join function?
To report on video engagement by project, I need to join Workfront project field data set with a Brightcove data set. There are 15 video ID fields in the Workfront data set and one video ID field in the Brightcove data set. If the Brightcove video ID field value matches one of the fifteen video ID field values from…
-
Edit String in Beastmode or ETL
Hello friends. I have a field where there are outputs like this: "Electronics | Computers & Accessories | Computer Accessories | Printer Ink & Toner" I want to only display the text after the last | separator. So the field would display only: "Printer Ink & Toner" Should I do this in ETL or Beastmode? And how do I do it?…
-
Reduce loading time of input dataset in Magic ETL
I have a Magic ETL dataflow using an input dataset with 10M rows. It takes around 20 mins just to prepare this input dataset, and consumes most of the ETL processing time. This ETL is used by a custom app, so ideally we would like it to finish as fast as possible. Currently it is running way too long and the bottleneck…
-
Case Statement Question - multiple results
I'm trying to use a quick filter to select sales people associated with specific branches. There is some overlap in assignment, in other words two branches are assigned to two different people. Here is my current case statement: case when `Customer Home Branch` IN ('207500','208500') then 'Brad' when `Customer Home Branch`…
-
Ignore Filter in Beast Mode
I am building a report in a table in Domo. I am trying to compare a calculation result to a calculation result from the same day a year prior. I am currently filtering on a specific date, so that our employees can view the report for the date that they select. The first calculation…
-
Date Filter for last day/week/month
I have a dataset. I want to create a Filter Date Card which has options such as "Today","Yesterday","Last one week", "Last one month". Can anyone tell how I can create this?
-
How do I find out who owns a beast mode calc?
Hi! Domo newbie here. I'm trying to document some datasets prior to roll-out and I see some beast mode calcs on it. Quite a few cards have been created using these datasets. Is there a quick way to find out which card a beast mode calc came from? Or who owns it?
-
Changing text format via beast mode in Pivot Tables
Is it possible to change the text of a font via a beast mode calculation in the new Pivot table card? I was able to format the text in a standard table, but with no aggregation. For the Pivot table, I have my values set to default. When I switch from standard to the pivot table, the html code appears in the cell itself.…
-
Calculations based on Page sync time
Is there a way to calculate a beast mode based on page sync time, or some other way to calculate a time difference that is live?
-
YoY Percentage Delta Calculation in Nested Bar Charts
Hello, Is there a way to calculate on the fly the percentage delta within a nested bar chart? Instead of displaying year's totals, I would like to disply the perscentage deltas in the graph below. Any ideas? Thanks!
-
DATE_FORMAT SQL Issue
Hi There, I'm tyring to convert my date field from a 12 hour time stamp, to a 24 hour timestamp. I tried using DATE_FORMAT(`Date Field`, '%Y-%m-%d %H:%m:%s') but it gives me a completely different date AND time than what the actual value is. Has anyone ever encountred a similar issue and have any advice. Thanks!
-
Postal Tracking Numbers in beastmode that link to google or website
Hello, I am working with a number of clients that attached their BOL or tracking numbers to their invoices and I was curious if anyone has figured out to make that field clickable to where it will either go link to the tracking number of the carrier or at least google to go from there? Would be great to open another window…
-
Counts for 2 separate dates columns in a single month (SQL Dataflow)
Good afternoon. We had previously requested something very similar and accomplished it via Magic ETL but want to do the same thing, only this time using a MySQL dataflow instead of Magic ETL (previous thread - split & reappend a dataset). We've looked for documentation but unable to find anything; can anyone direct us to…
-
Set Data Type by Row
Hi, Is it at all possible to set data types by row or specified account? We are trying to build a card that shows a P&L view, which would require importing accounts that have multiple data types (i.e., $ for Gross Margin, % for Gross Margin %). Thanks!
-
Add new columns in MySQL based on dates in table
I'm trying to add two new columns to a dataset, each based on certain conditions across 3 existing date columns in the input table. This either needs to be a MySQL or Magic ETL dataflow as it gets used to join with another dataset vs. directly powering a card. Existing Columns: 'Created Date' 'Converted Date' 'Last…
-
Multiple Case When Statements
I am trying to build a multiple case when statement but can't seem to get it to work. I want to show revenue buckets by either the Owner's name (for specific named users), 'CSG' for specific named users and then "No current sales rep" for all other users (the ELSE part). This is what I have so far: CASE WHEN `Owner.Name` =…
-
Applying calculations to hundreds of columns in a dataset - best practice?
I have a dataset that has ~1,200 columns and I need to perform calculations on 495 of those columns (simple multiplication and division) and create a new column for each with the calculated value... Trying to do this in ETL will take forever to setup (would need 3 calculators, 2 of which will have all of the the 495…
-
Multiply Values from each Series - Manufacturing Yield by Station
Hello! I am trying to determine the overall yield of a manufacturing line. The data columns include the date, the station, which is a column of row labels representing each station in the manufacturing line, the number produced, and the number of defects. I am able to find the yield by station, by creating a yield function…
-
Find Count Distinct w. Multiple Factors
Hello! I need to find ‘new initial customers’ by sales agent at the campaign level. For the purpose of this report, we define a ‘new initial customer’ as a customer (Customer_ID) who entered into a campaign (Campaign_ID) within a specified time range (by calendar month). I need to only count Customer_IDs the first time…
-
How to select a descriptive value based on MAX value of another column (Beast Mode)
I have a two columns. One contains Marks, and the other contains Names of students. I want to return the name of the student who has highest marks (I want to use this name in a card). How do I do this in the Beast Mode?
-
Utilization Calculation
Hello Team, I'm trying to calculation utilization that has the ability to roll up or down. Currently, our team is based on a 32 hour work week. I have a measure in my data set that sum our hours entered by day. I was able to get the caculation to work using this logic SUM(`Hours`/32) but I need the abilitiy or create a…
-
distinct count not working
Hi all - I just want to know why the distinct count in beast mode is not working.. in the screenshot, I have a count distinct on the resource names, but there are still duplicates appearing and being recognized as distinct. I am using this formula COUNT(DISTINCT CONCAT(trim(`Test Taker: Resource Name`))) any thoughts?