Calculating a moving month within 3 months

gbrown
gbrown Member
in Beast Mode

I am trying to calculate a moving 90 day period based on month. For example what I would like to see now is the date rolled up into DEC,JAN,FEB and as we move to next month I would expect to see JAN,FEB,MAR.

I know the current month function to get only the current month moving but having trouble integrating the following two months as well with it.


Let me know your thoughts...


Thanks

Answers

  • G_Grey
    G_Grey Contributor

    The quickest way I would solve for this is by putting a date range into the analyzer like so

    image.png

    Alternatively you could probably do something like this as a beastmode then filter if NOT 'not my date'

    image.png


Categories