Hey @Aaron_Cole!
According to your description, you currently have a Clients table. Even if you have also created a Created Date field on it, that will not be enough to "aggregate" the count of clients per day. Airtable does not work like a spreadsheet.
In order to solve your issue:
1. As @TheTimeSavingCo mentioned, you need to create yet another table -in his example, it is called "Record Counts", or you could also call it "Days".
2. On this new table, you'll want to have the primary field (that of the far left) to be a "Date" field where you will have one record, with its corresponding date, for every single day of the year(s).
3. Also on this new table, you'll have to create a "Clients" field (which should be a "Link to another record" field type).
4. Now, for linking all historic clients to their corresponding date, you'll have to copy all values from the "Created Date" field, and paste it on the field which links the Clients table with the Dates table. In this way, all existing records will be automatically linked.
5. Now on your Dates table, create a new field called "Count" (of field type Count), which should count all linked records linked to the clients table.
6. On your chart, you'll have field "Date" (primary field) as X axis, and Count field as y axis.
For last, for automatically creating new dates, and linking new clients to such dates, you can use an automation as suggested by @TheTimeSavingCo.
Please let me know if this helps!
Mike, Consultant @ Automatic Nation
