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 the same thing with a tile, it wont spit out any data. Any recommendations?
If this helps, feel free to agree, accept or awesome it!
Answers
-
Hi @damen does it return no rows when you save and run the dataflow, or just when you run a preview? If you haven't done so already, try running the entire dataflow and see if you get different results.
Previews do not process every row in order to save processing power, so it is possible that the more recent rows are not being included in your preview. You can also adjust how many rows your want to include in your preview using the drop-down on the top of the ETL editor.
2 -
@MichelleH That worked. But it was doing both. I tried to save and run it and it returned 0 rows with that same filter. I just changed the row limit and although there aren't even 10k rows (thats why i was trying to filter, to reduce the rows) changing the view to 400k worked. Weird. Thank you tho!!
If this helps, feel free to agree, accept or awesome it!
0 -
@MichelleH Ok new question
So I am trying to recreate this pivot table but do it in a way that it just creates the data table using an ETL
Here is what i have done so far
Here is what I am getting
How come the formula that is supposed to be grouped by instrument_name is returning a 100%?
I have tried to group by fallout_reason as well and that doesnt change the withdraw_percent numbers
If this helps, feel free to agree, accept or awesome it!
0 -
@damen In your formula, instead of doing COUNT('withdrawn'), do this:
SUM(case when 'fallout_reason' = 'withdrawn' then 1 else 0 end)
As you have it now, the numerator is essentially creating a "column" with the string 'withdrawn' in every row, so the numerator is doing the same thing as your denominator. You need to identify the column your aggregation should be looking at and what the condition is.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
4 -
@damen to be more specific, you should (probably) impelment the metric @RobSomers is describing as a Beast Mode in Analyzer.
Typically we recommend against preaggregating datasets in ETL if we don't have to.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"4 -
@RobSomers Awesome. I don't quite understand that 2nd part but I used that syntax and it worked well. Thank you both
If this helps, feel free to agree, accept or awesome it!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive