One Client has many Visits
A "new" Client as of last month is one where the # of Visits last month = number of visits.
Create a summary field for the [# of visits].
Create another summary field for the [# of visits last month] where visit date is during the previous 1 month.
Run a Report on Clients where [# of visits] = [# of visits last month].
If you also need a report on going during the month of number of clients in the current month then do something similar but make a summary field for [# of visits this month]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 08-02-2022 19:41
From: Alex Bartholomew
Subject: Unique Individuals
Hello Everyone,
I am trying to create a summary report that shows a list of clients that are not repeated clients. The date range is from 8/1/22 - 7/31/23. Starting in August all clients are new, however when September happens I need to see only new clients. I was thinking about creating a formula in the summary report but have not idea on how to isolate new clients or to check the previous month to see if the client has already come in.
Does anyone have any ideas on how I can solve this or any suggestions? I have clients that have been listed from previous years but this report is to focus on the next 12 months.
------------------------------
Alex Bartholomew
------------------------------