-
DataFusion Colorblind
I am wondering if there is a way to activate a colorblind mode for DataFusion? Or is there a way to change the coloring or the dataset columns. I am not able to differentiate between the red and green ones.
-
Help with Replace Text Regex
Hi! Struggling to figure out how to replace this: { "value":"Email", "id":"13469" } with this: Email Any ideas?
-
Data Flow help
Hello, Experts, I am humbly reaching out for some help. I have a vendor sending a snapshot of a database table every day and not sending me diffs. I am trying to determine the diffs. The connector type is SFTP CSV. The file they send daily is overwritten daily. I currently have the data connector appending the data from…
-
Using Percentiles to Bucketize in Beast Mode Query
Hi All, I have a table with a text dimension (Name) and an associated measure (Score). I wish to do the following: Calculate if the Score for each Name is in the top 20th percentile of all entities (highest) If the Name is inside the 20th percentile, do not update the Name. If the name is outside of the 20th percentile,…
-
Grouping using two criteria / subgroups / subtotals
I have a dataset that works a bit like my first picture here: What I need is an output that looks something like this: By that, I mean that I don't simply want a total of how many drinks were sold overall by each person, or how many of each drink were sold (which I could do with the group function in Magic ETL). I need to…
-
Date Diff beast mode calculation with multiple variables
Hi, I am trying to write a beast mode that provides the number of days between when a file was received and when it was completed, if the file was received after the expiration date then date received is used to calculate the number of days, if the file was received before the expiration date then the expiration date is…
-
Magic ETL - Change column types and merge files
Hi, I am merging 7 data sets into one. I would like to change the column types on all 7 of the source files before merging into the output data set. 2 columns in each file are "text" columns, but I wish to change them to date type. Some of the data contains "n/a" as a string. When I ran a simple Set Column Type ETL on this…
-
Mitigating V2 - Federated source limitation in Magic ETL
Hi All, Not a support question but we are running into an issue and would like to get guidance on how others mitigated this issue. We have a Subscriber instance provisioned to one of our clients, who have created ETLs on top of the sources we had published to that instance. This was in Publish V1. Now with V2, Federated…
-
Extract Y-M-D from BATCH_LAST_RUN
Hi, I need to extract the year-month-day from the timezone column. The column BATCH_LAST_RUN has values like: `2021-06-24 07:15:04 AM UTC`, what I need is to convert the date to est zone and just have the values like: 2021-06-24 I tried: DATE_FORMAT(MAX(DATE_SUB(`_BATCH_LAST_RUN_`)), '%Y-%m-%d ')) Also, tried to apply…
-
How to extract Date from TimeStamp1, Time from TimeStamp2, and then combine the two?
So I have two fields, "DateV2" and "EventTime V2". I am trying to extract out the Date portion (2018-11-16) from "DateV2" and combining that with the Time portion (12:07:00) from "EventTime V2". I am trying to do this in Magic 2.0. Here is my beast mode/formula in the Formula Tile: DATE_FORMAT(CONCAT(DATE_FORMAT(`Date…
-
Share dataflow and dataset owned by me to other author in the same organisation
Is there any easy way to share everything so that the other authors can see my work? I need to click share each time for each dataflow or dataset or cards that I created. How can I work more collaboratively with other author in our instance so we know what's the progress from each other? Thanks Sherry
-
Are "Joins" case sensitive
As we all know, Salesforce record IDs are case-sensitive. Has anyone done a join on Record ID? Are joins case sensitive?
-
Creating Repayment Rate by Group
I want to create a chart that shows repayment rate by each customer segment Repayment Rate = Repayment/Outstanding I followed this topic (https://dojo.domo.com/discussion/comment/47384/#Comment_47384) because I found a similar solution there, however it didn't show how you'd do it if there's multiple groups you'd like to…
-
Google Ads
Hi Team, Does anyone know which connector I should use for google ads? Thanks, Yuvraj Chavan
-
New addition to Webform not flowing through all dataflows
I have a webform that houses in different columns site level details like store name, Region, and Site ID's across multiple sources. I use this to join with datasets so it makes it easy to filter for things like Region and Site's. I recently added a new site, and all the other details to this webform. if has flowed through…
-
Show last 12 months dynamically using beast mode calculation?
I wanted to show last 12 months from June 2020 - May 2021 dynamically using beast mode calculation. Any help is appreciated! Thanks in advance
-
Beast Mode to Add "Warning" for Data Point
I have the Beast Mode below for a card that reflects IsShortAbandon "Good" when <=.07, else "Bad". I want to add "if .06 - .069 then "Warning". I am struggling a bit with the logic and appreciate in advance any assistance. Thanks Michael
-
Append a dataset without using recursive design
Is there any other way to append to a dataset without using a recursive design in Magic ETL?
-
Magic ETL error message
Hello, can someone help me figure out how to fix this error in my ETL "failed to convert data '$0.00' to type BigNumber for column 'Gross charge' Thank you.
-
Stop a Dataflow That is Running
As you can see from the screenshot I have a dataflow that has been running for 16h+. Nothing in it is that advanced so I'm not sure why it has been going for this long but either way I want to make a change and rerun it (put it back to the version that took 4 minutes to run) but I can't find a way to stop it. I set the old…
-
Sum specific product sales from one e-mailadress
I've a data file which contains customer purchases. Something like: Product 1 - Email1 Product 2 - Email2 Product 3 - Email3 Product 1 - Email4 Product 2 - Email1 Product 3 - Email1 If the specific e-mailadress purchased both product 1 and product 2 (the bold lines above) the answer should be 1. It doesn't matter if he…
-
OneDrive Writeback Connector
Is anyone using the onedrive writeback connector, and if so, are you able to write to excel tables? Same question for SharePoint excel files.
-
Beast Mode exclude or include
I have the below beast mode. (CASE when `vessel`like('%RB%') then 'exclude' when `vessel`like('%ROLL%') then 'exclude' when `vessel`like('%ADV%') then 'exclude' when `vessel`like('%REQ%') then 'exclude' when `vessel`='' then 'exclude' else 'include' end) It is working except it is not excluding blank cells. I thought…
-
Exclude first Value - Rank & Window
I am currently calculating the contribution for my dataset and have already sorted my values in descending order using the rank tile with date and group for my partitions. What I'm hoping to do is sum the previous value + the following value until my last value would be the grand total. In theory, I thought using the rank…
-
Seeing more rows in ETL preview
Hi all, This is likely a basic questions, but I can't figure it out. . When I run a preview on my ETL, regardless of how many rows I chose to run it on, I can only see 100 rows. Is there a way to see more? There are anomalies that I need to be sure are accounted for in my algorithm and the preview doesn't always show these…
-
How would I filter date field for only the most recent date?
How would I configure a BeastMode to filter only the most recent date? My data is machine name / last_sync, which is creating duplicates for the machine name and each reported last_sync date. I only want to capture the most recent date, which should also display one machine name per date. Thanks, Michael
-
Dataflow fail notification bug
Hi, Over the last few weeks I've been getting notifications that various dataflows are failing. However, there's no failure metadata and the same version runs successfully moments later. Any idea as to why this is happening? It's not a huge deal but I need to be able to distinguish between true failures that need action…
-
Is there a Beastmode I can configure for Rolling 30 period?
The caveat is the 30 day period I want to configure is Previous Month Second Tuesday to Current Month Second Tuesday. Any assistance is appreciated in advance. Thanks Michael
-
Dynamic Report with Ranking
Hi, I wanted to create a report that shows sales rank of each product by Store. However, because there are more than one transaction for each model, there are multiple rows for the same product in the dataset. As a result, I have multiple ranking numbers for the same model, when I use the rank & window feature in ETL. Is…
-
Comparing two variables and measuring variance
So, I am working with a dataset that contains questions from a form filled by two different users. Now I want to compare the results of these two fills based on the 'answer value' field - meaning what did user 1 select and what did user 2 select. My goal is to find the bias or variance between these two users in these…