How to create statistics for each employee who add records through form?
Dear developers and colleagues!
I am just one month zoho user. Even I have not yet discovered all the abilities of Creator I believe I can develop exactly what I want: simple and effective application.
By now I am almost done, but there is one thing left which I never thought I could stuck at...a super primitive statistic report showing performance of each employee who added records in certain date range, e.g. Today, Current month, Last Month, Total.
Showing the count of both, total records added (Sent leads) and those based on certain criteria (Response, Rejected, Manuscript) like on the picture below:
Tried pivot table but no chance, feel like got lost and desoriented.
I will appreciate any suggestions on that