Row wise count required for for Duplicate values,Speacial Char,Blank Rows

[Anonymous]

Prodcut	Attribute1	Attribute 2	Attribute 3	Attribute 4
A	1	3	1	1	Count(Duplicate values required)
B	@	@	&	@	count(special characters)
C			W	W	count(Blank rows)

1] For the product A Need Count of Duplicate values

2]For Product B Specail Characters count required

3] For Product C Blank & Null Characters count required

Message was edited by: Anil Kadiri

[Anonymous]

Experts Could pls suggest me some solution for the above

[jerem1234 · Accepted solution]

Please find attached. Depending on how your data model is, the attached might work for you. I did it two ways, one where your attributes are all one field and the other where they are separate fields. Also I only did the specials characters @, &. If you want to add more, you can.

PFA

Hope this helps!

[Anonymous]

Awesome work.thank youso much for your great effort

[Anonymous]

For this expression count should be 3 but it is showing 2 .

=count({<Product={A}>}Value) - count({<Product={A}>}distinct Value)

I Need Reptead count

Ans:3.

How can i achive this ?

[jerem1234]

That is a littler trickier. There are 3 instances of one in your example, but there are 2 distinct values. What that equation is doing is counting the number of repeated values after the first instance. So there are 3 instances of one, but then it is repeated twice.

If you are looking for the number of times a duplicated number appears, then that would be 3. Took a little bit of work, but I think this formula will suffice:

=count({<Product={A}>}if(aggr(nodistinct count(Value), Value) >1,Value))

Hope this helps!

[Anonymous]

Thank u.Its working.