I need to create a dynamic report that shows me data between 2 and 5 days ago

I've tried a variety of methods but can't get seem to get it accurate. Any help would be appreicated.



  • Hi @Mike_Shrift ,

    One thing you can do is to make a filter. So if you have a card that is a table, you can write a formula/beast mode like


    WHEN `date`>=(Curdate()-5) AND `date`<=(Curdate()-2) then 1 end

    Then you'd filter on 1s.

    Make sense?

    John Le

    You're only one dashboard away. 

    More video solutions at: https://www.dashboarddudes.com/pantry