beast mode for last 15 days associated with page filter on Date

hello, I want to create a beast mode to calculate the downloads for the last 15 days when a user selected a Date from page filter, my current one is based on today's date. How to set up my beast mode? Thank you. Olivia SUM ( CASE WHEN `Date`> (CURDATE()-15) THEN `Download` END)


  • Valiant

    The only way I can think to do this at the page level would be to use the Date Filter card type and have the user drag a date range over the 15 days in question. 


    I don't believe there is a way to pass a user selection on a filter into a beast mode.




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

  • WizardOz
    WizardOz Contributor

    Thank you. Valiant.  I will try Date Filter Card.



This discussion has been closed.