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

WizardOz
WizardOz 🟠
in Charting
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)

Comments

  • Valiant
    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.

     

    Sincerely,
    Valiant

     

    **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 🟠

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

     

    Olivia

This discussion has been closed.

Categories