Charts with count of Distinct Records

[#1]

Hi Friends ,

I have a requirement

Country	LIST TYPE	MAR
AE	BIC	BMCADR1
AE	CIL	BMCADR1
AE	BIC	BMCADR3
AE	CIL	BMCADR4
AU	BIC	BMCADR5
AU	CIL	BMCADR6
AU	AUM	BMCADR6
IND	AUM	BMCADR8
IND	BIC	BMCADR9
IND	BIC	BMCADR10

In the Above data , i have to build a chart based on the Country code as Dimension and Count (List Type) as Expression

Condition : I should Consider the List Type with only DISTINCT MAR (Out of 10 MAR , only 8 are distinct)

Regards,

Senthil

[robert_mika]

Count(DISTINCT MAR)

[satishqlik]

Hi Senthil,

Dim--->Country

EXP--->Count(List Type) based on Count(Distinct Mar)

I think with your source data, it doesn't make sense So kindly recheck and revert ASAP.