This is probably trivial and I bet lots of users have faced this before, but I can't seem to find a relevant discussion on this.
I want to be able to show in a line chart both the daily values and a stepped line showing the monthly (or weekely) average.
The current application analyzes the times spent by employees in the office.
The data is based on gates access timestamps, and the transactions table looks like this:
So for each ID, for each day, I have multiple gate access times.
With a reasonable approximation I will consider the time spent by each employee as the Max-Min for each day. I will then need to aggregate this further up at Month level or Department Level based on the Median