Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to create a report to measure the Client Satisfaction Index (CSI) for each month region wise. which is calculated using the below formula:
1 - (complaints received for each month for each region / Inquiry received for each month in each region)
I get the data from these two table:
1) Complaint_table:
2) Inquiry_table:
Now I have associated these two tables on Year_month. I am stuck after this as I also want to associate over Region as otherwise how will I map the same two regions with each other.
Finally I want to create a pivot table with region as rows and columns as Year month and the measure as the CSI formula described above.
For e.g
Sep-18 Oct-18
Region CSI CSI
A 40% 50%
B 50% 67%
C 67% 0%
D 67% 67%
E 33% 50%
I am not sure how to do this analysis, Please help me out.
Thank You
I agree with Lisa_P, that's what I would do too.