-
Why are my filters not working in Magic ETL?
Hi all, I'm confused as to why my magic ELT filters are not working properly. Is it something I am doing wrong? How do I go about fixing this? In the first picture, I am in the data set and have set a filter on the 'time_stamp' column and its filtering the data just fine. For whatever reason, when I go to magic ETL and do…
-
MySQL Indexing Issues
When setting up Indexes in my SQL dataflow, I notice sometimes that a few columns in the join are not made available for indexing. Why is that? What can I do to fix this? I suspect without the indexing, my dataflow is taking an inordinate amount of time. Also, in the Domo help on optimizing data flows with indexing, the…
-
Period over Period help
@GrantSmith Hi Grant, I have used your date dimension solution for lots of PoP charts but like you have mentioned on your post doing month over month can be tricky. Thanks for your help so far on my domo journey. My problem. I have daily data and have a period type of 'Last Month' and 'This Month' I have the data in a…
-
Google Analytics - Referrals
Hello, I am trying to create a graph using Google Analytics, specifically on referrals (Acquisition -> All Traffic -> Referrals). However, when I connect and select which data to include, I am not pulling the right numbers. Does anyone have advice on which metrics to pull in? Thanks!
-
"current year, current month" and "previous year, current month" Beast Modes
Hi, I'm trying to create a 'current year, current month' and 'previous year, current month' beast mode. To this point I have created a current year to date but am not sure of the syntax. I have watch multiple videos and have searched high and low through domos resources. Any help with the syntax would be helpful Here is…
-
Fiscal Year Comparison
Hi, I am trying to create a running total of fiscal year 2023 vs the same time in FY 2022 and FY 2021 but all on the same chart. Right now, I currently have this Essentially what I am trying to do is take the three green bars from July 1 of this year, combine them into one column and then do the same for the pink and blue.…
-
Correcting date format in Magic ETL
Hi all, First time posting here. I need to know how to correct date formatting within a dataset. The dataset was pulled from Google sheets. As you can see, in ETL the formatting is wrong and inconsistent. How can I correct the format in ETL and make everything streamlined and compatible in the analyzer? Thanks
-
Magic ETL Help
Hi, I am going through the Data specialist practical test and am running into troubles. Here are my instructions: Up to this point, this is what I have done: Because I am not an admin on my company network, for those familiar to this test, I was unable to complete the join on the workbench due to accessibility issues.…
-
Multiple Columns with Multiple Yes fields
I have a datasource that looks like this (with ~50 different products, so having just four separate filters would not work): What I need is a table, filterable by product (using OR functionality, if C & A are chosen Customers 1, 3, and 4 should show), with the number of software seats for that customer, and a grand total…
-
Year over year cumulative average
I am trying to create a line chart with the year as a series. The data points are per month with a cumulative average. Data: Year Month Closed Cases Total Cases % Cumulative % (Cum. Math) 2022 1 50 100 50% 50% (50/100) 2022 2 100 150 75% 60% (150/250) 2023 3 100 100 100% 71.43% (250/350) etc. across multiple years where…