hi
i worked out a table like below by each timepoint, the expression is "
(
sum(aggr(if(Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)
/
Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Assigned', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)<>1,1,0),PLAvailability_TimeSlot,PLAvailability_InsertDate)))
/
24
"
| LodingTime | DAY1 % of Available Slot |
| 1/2/2014 0:02 | 4.20% |
| 1/4/2014 18:02 | 4.20% |
| 1/6/2014 12:02 | 4.20% |
| 1/6/2014 18:02 | 4.20% |
| 1/7/2014 6:02 | 4.20% |
| 1/7/2014 12:02 | 4.20% |
| 1/8/2014 6:02 | 4.20% |
| 1/8/2014 18:02 | 4.20% |
| 1/9/2014 0:02 | 4.20% |
| 1/9/2014 6:02 | 4.20% |
| 1/10/2014 0:02 | 4.20% |
| 1/13/2014 0:02 | 4.20% |
| 1/13/2014 6:02 | 4.20% |
| 1/14/2014 6:02 | 4.20% |
now i want to show the average number by year month
| YearMonth | LodingTime | DAY1 % of Available Slot |
| 201401 | 1/2/2014 0:02 | 4.20% |
| 1/4/2014 18:02 | 4.20% |
| 1/6/2014 12:02 | 4.20% |
| 1/6/2014 18:02 | 4.20% |
| 1/7/2014 6:02 | 4.20% |
| 1/7/2014 12:02 | 4.20% |
| 1/8/2014 6:02 | 4.20% |
| 1/8/2014 18:02 | 4.20% |
| 1/9/2014 0:02 | 4.20% |
| 1/9/2014 6:02 | 4.20% |
| 1/10/2014 0:02 | 4.20% |
| 1/13/2014 0:02 | 4.20% |
| 1/13/2014 6:02 | 4.20% |
| 1/14/2014 6:02 | 4.20% |
| 1/15/2014 6:02 | 8.30% |
| 1/16/2014 0:02 | 4.20% |
| 1/16/2014 6:02 | 4.20% |
| 1/17/2014 6:02 | 4.20% |
| 1/17/2014 18:02 | 8.30% |
| 1/18/2014 0:02 | 4.20% |
| 1/19/2014 6:02 | 4.20% |
| 1/19/2014 12:02 | 4.20% |
| 1/21/2014 6:02 | 4.20% |
| 1/22/2014 0:02 | 4.20% |
| 1/23/2014 6:02 | 4.20% |
| 1/25/2014 0:02 | 4.20% |
| 1/26/2014 6:02 | 4.20% |
| 1/26/2014 12:02 | 4.20% |
| 1/27/2014 6:02 | 8.30% |
| 1/28/2014 6:02 | 4.20% |
| 1/29/2014 6:02 | 4.20% |
| Total | | 141.70% |
i just want to Total to be the average of those numbers , how can i do that?
