I am assuming that you are charting only one event at a time.
Only thing that I can think of is a variation of what you didn't want to do:
Use a script to set up a related table with one record for each date. Set up a global field to use to match to your current table by event type. Define a relationship matching records by date and global event type field.
Then a calculation field can compute the count of the related records to provide a count for each day and will provide a 0 count when there are no records of that event type for that date. You'd select event types from a value list on your global field to chart different events in your chart.
It been a while since I visited this. Thanks Phil for the input. You confirmed what I suspected.
Each chart displays one measure, and there may be new measures in the data that need to have a chart displayed from the first of the year.. I ended up doing was adding a section into my data import script to look at the current date and for each of the measures being imported it either:
- for new measures, creates a record for each date from the beginning of the year to the current date
- for existing measures, it updates the data to add new dates from the last record for the specific measure to the current date.
Adds a little time to the import, but gives me what I need.