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

Mike_Shrift
Mike_Shrift ⚪️
in Beastmode & Analytics

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

Tagged:

Answers

  • DashboardDude
    DashboardDude Chicago 🟢

    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

    CASE

    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

Categories