Trying to filter data by new referrals in last 7 days

I am trying to build out a really basic admin dashboard that reports the number of new referrals in the last 7 days. I cannot seem to figure out how to filter this referral data down to just the last 7 days. I’ve figured out how to report all referrals but am unable to filter. I’m new to bubble and just trying to figure it out, any help would be appreciated. Thank you.

On your search for referrals, use the following constraint:

created date > Current date and time + (-7 days)

Hi Jacob,
Thank you for your response. Should I use this constraint on the search or a filter after the search? Below is what I have so far?Screen Shot 2020-03-24 at 10.05.20 AM

Hey Jason,

I would use it on the search itself. The field “referral_count” is probably redundant because you can just count the number of results that your search returns using the :count method

So, Do a search for referrals (and set up the constraints that I mentioned in the last message.)

The expression should look like this when you’re finished: “Do a search for referrals:count”

Hi Jacob,
Ok, so this is what I tried but I am getting a “0” when the correct number should be 6. What am I missing here? Really appreciate your help.

Screen Shot 2020-03-24 at 10.11.42 AM

Screen Shot 2020-03-24 at 10.10.37 AM

Almost there, just make sure it’s “-7” instead of “7” :wink:

Bingo! Thank you very much!

No worries. Happy to help :slight_smile: If you run into some issues later and need some help, I offer a consulting service too:

This topic was automatically closed after 70 days. New replies are no longer allowed.