Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an ID field which is linked to multiple part type.
For eg : id 10607 is linked to part type like zsp1,zret,zlab etc
id 10608 is linked to part type like zret,zlab etc
id 10609 is linked to part type like zret
Now i want to take the count of part type where zsp1 is not there.
It is counting 3 for id 10607 & not as 1 for zsp1.
i have tried this formula
=count(distinct if(part_type<>'zsp1',id))
=count(distinct if(part_type='zret' or part_type='zlab',id))
But i get all the calls where it has zsp1 also there after specifying te above condition.
Is it possible to take individulal line count ????
Can someone help me on this issue????
You can use following set analysis expression.
Count(Distinct {<Part_Type -={"zsp1"}>}id)
hi sunil,
thanks for ur response, but this not working ,
as it has to take any id having zsp1 ,zret,zlab,zshm should not consider zsp1 for calculation & should give individual count as zret=1
zlab=1
zshm=4
& should not come 4 as overall.
I think your code is write
=count(distinct if(part_type<>'zsp1',id))
if not work then you can try in script--
in script
write code-
load
id,
part_type
from table
where part_type<>'zsp1';
then in chart-
count(Distinct id)
Hi,
Did you try this yet
Count({$<Part_Type -={'zsp1'}>} Distinct id)
Regards,
Sokkorn
Hi,
Thank you for the response,it is not working fine
i can give an example of the actual problem below:
part_type | id |
ZRET | 108826 |
ZLAB | 108826 |
zsp1 | 108826 |
ZRET | 108827 |
ZLAB | 108827 |
zsp1 | 108827 |
zsp1 | 108828 |
zlab | 108828 |
zret | 108829 |
zlab | 108829 |