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

Average and Sum of column in separate KPI text box?

SS.PNG

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
settu_periasamy
Master III
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))

View solution in original post

4 Replies
qlikviewwizard
Master II
Master II

Please upload sample file with the dummy data.

settu_periasamy
Master III
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))

haneeshmarella
Creator II
Creator II
Author

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

How do I get Sum for each column?

haneeshmarella
Creator II
Creator II
Author

Hi Arjun,

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