V
Viswanathan S
Hi all!
I am a Customer Service Rep and trying to design a report
for the Customer Satisfaction reports.
There are 2 fields
1> CSAT with values 1-5
2> TPR with values 1-5
If CSAT is 4 or 5, the CSAT is 100% else 0%
If TPR is 1 then the TPR is 100% else 0%
For this I added fields in the table Block1 and Block2
Block1 (values 0 or 1) for CSAT. If CSAT is 4 or 5 Block1
is 1 else 0 and similarly for Block2.
Now for the Report.
I am trying to group the report week wise with summary of
CSAT % =(Number of CSAT with values 4 or 5 (Block1 = 1))/
(Total Number of CSAT entries)
and similar for TPR also.
I do not want the Block1 or Block2 to be displayed very
blatantly on report.
Can yoy please help me....
Thank you.
Viswanathan S
I am a Customer Service Rep and trying to design a report
for the Customer Satisfaction reports.
There are 2 fields
1> CSAT with values 1-5
2> TPR with values 1-5
If CSAT is 4 or 5, the CSAT is 100% else 0%
If TPR is 1 then the TPR is 100% else 0%
For this I added fields in the table Block1 and Block2
Block1 (values 0 or 1) for CSAT. If CSAT is 4 or 5 Block1
is 1 else 0 and similarly for Block2.
Now for the Report.
I am trying to group the report week wise with summary of
CSAT % =(Number of CSAT with values 4 or 5 (Block1 = 1))/
(Total Number of CSAT entries)
and similar for TPR also.
I do not want the Block1 or Block2 to be displayed very
blatantly on report.
Can yoy please help me....
Thank you.
Viswanathan S