Activity   Bob Bill
Open        1   3  
Help        1   0    
Close       1   0
Active Days X   X    
 

ACCT1 01/01/2013 Open Bob
ACCT2 01/01/2013 Help Bob
ACCT3 01/01/2013 Close Bob
ACCT4 01/01/2013 Open Bill
ACCT5 01/02/2013 Open Bill
ACCT6 01/03/2013 Open Bill

quote:

Originally posted by susannah:
so are you saying that the value 1 for OPEN and the value 1 for HELP and the value 1 for CLOSE all together just mean that BOB gets a total count of 1?
But if BOB had 3 different dates
and 3 different activities, his data
would still be 1,1,1, but the total in this case would be 3?
Is that right?

  
-SET &ECHO=ALL;
-* File rep01.fex

FILEDEF REP DISK REP.FTM
-RUN
-WRITE REP ACCT1 01/01/2013 Open  Bob 
-WRITE REP ACCT2 01/01/2013 Help  Bob 
-WRITE REP ACCT3 01/01/2013 Close Bob 
-WRITE REP ACCT4 01/01/2013 Open  Bill
-WRITE REP ACCT5 01/02/2013 Open  Bill
-WRITE REP ACCT6 01/03/2013 Open  Bill
-RUN
EX -LINES 8 EDAPUT MASTER,REP,C,MEM
FILENAME=REP, SUFFIX=FIX
SEGNAME=REP, SEGTYPE=S0
FIELDNAME=ACC, USAGE=A6, ACTUAL=A6, $
FIELDNAME=ADATE, USAGE=A10, ACTUAL=A10, $
FIELDNAME=F1, USAGE=A1, ACTUAL=A1, $
FIELDNAME=ACTIVITY, USAGE=A6, ACTUAL=A6, $
FIELDNAME=NAME, USAGE=A4, ACTUAL=A4, $
-RUN
SET MSG=ON, HOLDLIST=PRINTONLY, ASNAMES=ON
TABLE FILE REP
SUM CNT.ADATE AS NUM ADATE
-* Note: the superfluous ADATE is due to the fact that later on CNT.DST will add this field to the file
-* Why? I have no idea!
BY NAME
BY ACTIVITY
ON TABLE HOLD AS H1 FORMAT ALPHA
END
?FF H1
-RUN
FILEDEF H1 DISK H1.FTM (APPEND
DEFINE FILE REP
ACTIVE/A6='Active';
END
TABLE FILE REP
SUM CNT.DST.ADATE AS NUM
BY NAME
BY ACTIVE
ON TABLE SAVE AS H1
END
-RUN
TABLE FILE H1
SUM NUM
BY ACTIVITY
ACROSS NAME
ON TABLE SET NODATA '0'
END