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?
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.
Almost there, just make sure it’s “-7” instead of “7” 
Bingo! Thank you very much!
No worries. Happy to help 
If you run into some issues later and need some help, I offer a consulting service too: https://tekademy.co/
This topic was automatically closed after 70 days. New replies are no longer allowed.