Count Distinct for Bar Chart

[Venkatsj]

Hi please help with expression for the below,

Group A	Name	Company Name
A	Doll	Amc
A	Bill	AMC
E		BMC
A	Bill
C		Max
A	Grudge
A	Vasing
B		Box
D		Exist
D		Box
A	Max
D

Dimension for the bar chart is Group : A, B, C, D, E

I need to count distinct Name and company Name where "A" refers to Name Column and remaining "B,C, D,E" refers to categories in Company Name column.

Where Group "A" should count(distinct) only "Name" column

Remaining Groups should count ( distinct) only e.g. "B" should count only company name "Box".

Kindly support, Thanks in advance

[abhijitnalekar]

Hi @Venkatsj,

It is a little confusing to understand the required output.

Table representation of output would be helpful to understand and to help.

[Venkatsj]

Hi Abhijit,

find the table below,

Country	Group	Organisation name
BE	HCP	Max
BL	HCP	William
CR	HCP	George
CR	HCP	Ronald
CR	HCP	Kris
RE	HCO	Max pvt lt
RE	HCO	Ruby Pvt
RE	HCO	Nios ltd
RE	HCO	Rocker feller Ltd
NL	Supplr	Bricks Ltd
NL	Supplr	Bricks Ltd
FR	Supplr	Macrow Ltd

From the above table i would like to create a Bar & Area chart where Country is Dimension 1 and dimension 2 is Group. My measure will be count(distinct) of organization name for each group. Please ignore the above question, Thank you.

[abhijitnalekar · Accepted solution]

Hi @Venkatsj ,

Please use count(distinct organization name)