Why are my filters not working in Magic ETL?

damen
damen Contributor

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!

Tagged:

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.


  • damen
    damen Contributor

    @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!

  • @damen That's definitely odd! I'm glad it worked!

  • damen
    damen Contributor

    @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!

  • @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!**

  • @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"
  • damen
    damen Contributor

    @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!