Skip to content

    • Beast Mode

    Beast Mode

    Beast mode to find last working day

    Member
    in Beast Mode

    Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday.

    If there is a better way to do this other than a beast mode open to that as well.

    Best Answer

    • Coach
      Answer ✓

      @RTM Try this beast mode to include data from 3 days ago if today is Monday or yesterday if today is not Monday. If your users need to look at the data over the weekend, then you will need to add an additional line to subtract 2 days if today is Sunday.

      1. case 
      2.   when DAYNAME(CURRENT_DATE()) = 'Monday' and `Date` = DATE_SUB(CURRENT_DATE(),3) then 'Include'
      3.   when `Date` = DATE_SUB(CURRENT_DATE(),1) then 'Include' 
      4.   else 'Exclude'
      5. end

    Answers

    • Coach
      Answer ✓

      @RTM Try this beast mode to include data from 3 days ago if today is Monday or yesterday if today is not Monday. If your users need to look at the data over the weekend, then you will need to add an additional line to subtract 2 days if today is Sunday.

      1. case 
      2.   when DAYNAME(CURRENT_DATE()) = 'Monday' and `Date` = DATE_SUB(CURRENT_DATE(),3) then 'Include'
      3.   when `Date` = DATE_SUB(CURRENT_DATE(),1) then 'Include' 
      4.   else 'Exclude'
      5. end
    • Member

      Thank you. Tried it and it seems to be working.

    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