Data for 30 days

How can I get 30 days of data irespective of month through Beast Mode? it could be 20 days of April & 10 days of May.

Comments

  • AS
    AS Coach

    I would do something like:

    CASE WHEN DATEDIFF(CURDATE(),`trx_date`) <= 30 THEN 'Yes' ELSE 'No' END

    Then bring that value into your filters, choosing only the "Yes" rows.  That would give you all transactions within 30 days.

    Do you have transactions forward-looking, or just in the past?  That may affect how you implement logic like this.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"