-
'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?
-
Is there a way to annotate ETL dataflows?
Is there a way to annotate ETL dataflows? I can see what I did, but I don't always remember "why" I added some steps. The step name isn't always long enough to capture the rationale behind the action. (For example: In Alteryx, you can add a text box on the canvas.)
-
Employee Retention Rate over time
Hi, I'm trying to calculate employee retention rate over time (in quarters ideally). The data that I'm pulling in has each employee's start date and end date (if they've left). The equation for retention I think I want to use is: (headcount (Q-1) - sum(leavers))/headcount (Q-1) Any ideas how to do this? I'm struggling to…
-
chart data creation question
hi all - I would just like to know how to add the highlighted section in DOMO(column B) . I have the column C coming from a Dataset. Also, the first number in column B (1504) is a static number that will be built upon... how can I put that in there? also,
-
filter rows
I am trying to run a filter rows operation on one of my datasets for when field gn_id = '2013159', but when I do this nothing comes up....I'm getting duplicate Id's and thought if I could narrow down to that order I could find my duplicate problem, but when I add my filter nothing comes up....all I have is gn_id = 'a…
-
Modifying a Summary Number
I have a column in my data sheet with values like 0.202321. I display the AVERAGE of those values but when I select the NUMBER FORMAT as PERCENTAGE in the SUMMARY NUMBER, I get something like 20.2% when in fact the percentage should looke like 0.20%. How would you go about transforming these values? One idea I had was…
-
Date Format
Hi, The date in my data set is formatted as YYYY-DD-MM. As shown below: By default domo assumes the date is YYYY-MM-DD. Therefore all my data is grouped as Jan 2016. Is there a beast mode calculation to reformat the date? Thanks, Angel
-
calculate exactly like Pivot tables in sql
Hello, I have sanpshot coming daily which gives the information of how and what sales we did for that day and it all formulates under ship to fiscal week, year , product, invoices, amount, etc. So what shall be my best approach to make it automated. I know we have distinct function in SQL which gives me quick win, so I…
-
Time Intelligence in DOMO
Hello, Is time intelligence possible through Beast Mode? Meaning is row level context possible - if the date on the current row is 1/1/2019 can a measure effectively be instructed to go back exactly one year and grab that value and insert it in the row? Attached is an example data set where I would want a PY measure. I've…