Skip to content

    • Magic ETL

    Magic ETL

    Ignore filter on a calculated field

    Member
    in Magic ETL

    Hello, I'm wondering if it's possible to create a BeastMode that ignores date filtering...

     

    I have a dataset that contains the following information

     

    ID#   CUSTOMERNAME   STATE    FullDate    Logins    Errors    %

     

    The card I'm building should only display the data from yesterday BUT, I want to add a field that calculates how many times the customer shows up on the list based on the % being over 10 for all time. Below is what I have to calculate the field which works to put a 1 on the current day but does not take into account the rest of the days. 

     

    1. sum(CASE WHEN `%` >= 10 THEN 1 END)

     

    Any Assistance would be appreciated.

     

    Tagged:

    Best Answer

    • Member
      Answer ✓

      I was actually able to accomplish this by using an ETL Grouping process. Appreciate the help. 

    Answers

    • Contributor

      Hello,

       

      If you are filtering to yesterday then you will not be able to do what you are looking for via beastmode. You will have to write some syntax in a MySQL flow for a cumulative sum.

       

      It's very easy to do and this article should help you.

       

      https://discourse.looker.com/t/cumulative-sum-in-mysql/807

       

      Thanks,

       

      Brian


      **Please mark "Accept as Solution" if this post solves your problem
      **Say "Thanks" by clicking the "heart" in the post that helped you.
    • Member
      Answer ✓

      I was actually able to accomplish this by using an ETL Grouping process. Appreciate the help. 

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories