3 Replies Latest reply on Jun 29, 2018 8:08 AM by Edward Walker

    Create last 7 days, last 14 days, last 28 days etc. drop down filter for dashboard

    Edward Walker

      Hello,

       

      I'm attempting to create a drop down filter for my dashboard that allows users to filter for data for the last 7/14/28 days etc. I have created in my SQL binary (1/0) indicators for whether a booking happened within the last 7 days, another column for last 14 days etc. but I'm not sure if this is a good approach to take. Any suggestions?

       

      Thanks,

      Ed