Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
Creator II

## Average and Sum of column in separate KPI text box?

How do I get the average of Carton Efficiency and Pieces Efficiency in separate KPI box? Also, Sum of Total Cartons and Total Pieces in separate KPI box?

The formula for each row of the columns are:

Total Cartons : Count(distinct CASE#)

Total Pieces: num(sum(UNITS#),'#,##0')

Carton Efficiency: num(Count(TOTAL <USER_NAME> DISTINCT CASE#)/(HOURS*29),'#.# %')

Pieces Efficiency: num(SUM(TOTAL <USER_NAME> DISTINCT UNITS#)/(HOURS*29),'#.# %')

Thank you.

1 Solution

Accepted Solutions
Master III

Maybe try like this in the text box

Total Cartons : =SUM(aggr(Count(distinct CASE#),DATE,SUPERVISOR,ASSOCIATE))

Carton Efficiency :

=Avg(Aggr(

num(Count(TOTAL <USER_NAME> DISTINCT CASE#)/(HOURS*29),'#.# %')

,DATE,SUPERVISOR,ASSOCIATE))

4 Replies
Master II

Master III

Maybe try like this in the text box

Total Cartons : =SUM(aggr(Count(distinct CASE#),DATE,SUPERVISOR,ASSOCIATE))

Carton Efficiency :

=Avg(Aggr(

num(Count(TOTAL <USER_NAME> DISTINCT CASE#)/(HOURS*29),'#.# %')

,DATE,SUPERVISOR,ASSOCIATE))

Creator II
Author

Thank you Settu. Can you help me here too please?

How do I get Sum for each column?

Creator II
Author

Hi Arjun,

Settu has given me the answer. Thank you for the response.

Community Browser