% of total count

[ranibosch]

good day,

i have the following data:

Type	Complain date	Customer Compliant Ref#	Origin of Complaint
Complaint	31 Jul 15	20150730-328805082	Gauteng
Complaint	30 Mar 16	20160322-339979656	KZN
Complaint	30 Mar 16	20160323-340012663	Eastern Cape
Complaint	14 Apr 16	20160412-340904856	Gauteng

On my chart I basicallly want it to show me the % of each region's complaint.

Example:

Gauteng = 50% (which is 2 out of the 4 complaints)

i have 2  dimensions:

1. Complaint year

2. Origin of complaint

stalwar1‌

[sunny_talwar]

May be this

Count([Origin of Complaint])/Count(TOTAL [Origin of Complaint])

[ranibosch]

Hi Sunny,

Thanks for that, the formula you provided works if you want to look at the ratio in total, but not if you split it up into the "year" dimension.

Please find attached a detailed explanation of what I need.

Thank you! !

[sunny_talwar]

I guess Year is one of the dimensions, right? Try this

Count([Origin of Complaint])/Count(TOTAL <Year> [Origin of Complaint])

[sunny_talwar · Accepted solution]

Sample image and qvw attached

[ranibosch]

Thanks Sunny,  can I add a set analysis in front of this as well?

I have 2 types of entries:

1. Complaint

2. Inquiry

I was thinking something like this:

Count ( { < Type = {"Complaint"} > } ([Customer Compliant Ref#]))

/

Count ( { < Type = {"Complaint"} > } TOTAL <Year> ([Customer Compliant Ref#]))

[sunny_talwar]

Sure thing