Hello,

I have a table of events with a start date/time and an end date/time.  I am trying to get the average of daily total time for the events and I am not sure how to do this in Zoho.  I have a calculated column of total time in seconds for each event.  I need the system to sum those numbers for each calendar day and then average those daily numbers for the period specified.  I am looking to create a KPI widgets that say things like "Average total event time per day this quarter" as well as charts that track this average over time by day,week,quarter, etc. 

I am looking at aggregate formulas and this just seems to have too many layers to work.  Is this possible?