how to filter this one?

[Chinnu3]

Hi All

Lead name	team member	id
Sai	v1	1
Sai	v2	2
Sai	-	3
Thomas		4
Nick	c1	5
Nick	c2	6

I want only Lead name which there is no team member and i want to see that which "id" is assigned to that lead in a bar chart.

Results I need like Thomas has no member and "id" 4 is assigned only

thanks in advance. 

[vinieme12]

as below

LOAD * INLINE
[
Leadname,teammember,id
Sai,v1,1
Sai,v2,2
Sai,-,3
Thomas,,4
Nick,c1,5
Nick,c2,6
];
exit Script;

Dual(concat({<id={"=len(teammember)<1"}>}distinct id,','), count({<id={"=len(teammember)<1"}>}teammember))

[Chinnu3]

Thanks for your response But i want that in only front end in bar chart without disturbing any script.

Thanks in advance. 

[vinieme12]

I haven't changed anything in the script!

i simply loaded your sample data to test the given expression

so if that sample is how your data is structured the below expression will work for you

Dual(concat({<id={"=len(teammember)<1"}>}distinct id,','), count({<id={"=len(teammember)<1"}>}teammember))

[Chinnu3]

I want to show that in a bar chart, 

create date	Lead name	team member	id
1/15/2022	Sai	v1	1
1/16/2022	Sai	v2	2
1/17/2022	Sai	-	3
1/18/2022	Thomas		4
1/19/2022	Nick	c1	5
1/20/2022	Nick	c2	6

create date as Dimension and measure as Count(ID) i want to see.

How many ID's are assigned to a "Lead name" which does't have "team members"?

Thank you.