Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
what i mean it is currently giving me the total, i want to average
Hi,
In Expression tab->total Mode->Select (Sum )of Rows
Or
Expression tab->total Mode->Select (Avg )of Rows
it just greyed out, can not choose it
Hi,
I am considering that you are using Straight table
regards,
It seems you are using a Pivot Table. Convert it to a Straight Table and the option should be available to you.
Rgds,
SK