I'm trying to put together a report that shows rate of support calls/submissions by clients, as a ratio of calls/submissions to # of members by individual client. The totals are eventually grouped by different "alliances" or groups of clients. From the data here:
Company A
Alliance X
E-Mail
10/1/2013
6
110
Company A
Alliance X
Fax
10/1/2013
4
110
Company A
Alliance X
Online Forms
10/1/2013
12
110
Company A
Alliance X
Call
10/1/2013
2
110
Company B
Alliance X
Online Forms
10/1/2013
4
94
Company C
Alliance X
E-Mail
10/1/2013
24
195
Company C
Alliance X
Fax
10/1/2013
2
195
Company C
Alliance X
Online Forms
10/1/2013
6
195
Company C
Alliance X
Call
10/1/2013
4
195
Company D
Alliance X
E-Mail
10/1/2013
23
168
Company D
Alliance X
Fax
10/1/2013
13
168
Company D
Alliance X
Online Forms
10/1/2013
10
168
Company D
Alliance X
Call
10/1/2013
4
168
Company E
Alliance X
Online Forms
10/1/2013
2
51
Company E
Alliance X
Call
10/1/2013
1
51
Company F
Alliance X
Online Forms
10/1/2013
1
265
I am expecting my results for October 2013 and Alliance X to be 118 submissions, and 883 members (which would result in ~0.134). Does this make sense? I'm a bit new to Qlikview, so I don't know if there's a formula to group by and then sum?
