Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Venkatsj ,
Please use count(distinct organization name)
Hi @Venkatsj,
It is a little confusing to understand the required output.
Table representation of output would be helpful to understand and to help.
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.
Hi @Venkatsj ,
Please use count(distinct organization name)