Skip to content

    • Beast Mode

    Beast Mode

    MTD & MTD Last Year Beastmode that calculate the ratio

    Member
    in Beast Mode

    so I have a beast mode that calculates the ratio of committed orders 

    1. % committed count = SUM(CASE WHEN % complete > 0 THEN 1 ELSE 0 END) / COUNT(Order #)

    but I want to create a Beast Mode to calculate the same ratio but just for this MTD, so I tried this, but it return 0

    1. CASE
    2. WHEN YEAR(CURDATE()) = YEAR(MONTH_END_DATE) AND MONTH(CURDATE()) = MONTH(MONTH_END_DATE) 
    3. THEN
    4.  % committed count
    5. ELSE 0
    6. END
    Tagged:

    Answers

    • Coach

      @verytiredgirl If you haven't already, I suggest reading @GrantSmith's write up on this topic: https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

    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