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

Mike_Shrift

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

DashboardDude

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