how to use the counting function to see the times they re repeated?

[nevilledhamsiri]

How the counting function is used? Data looks like below.

ref_Number               Value

Raccc125                  500

Raccc125                 500

Raccc126                  300

Raccc127                  250

Raccc128                  150

[kaushiknsolanki]

Hi,

You can use the count() function to count a value in a field.

Like

Count(Ref_Number) this will count all values (Not the distinct)

For distinct count

Count(Distinct Ref_Number)

Regards,

Kaushik Solanki

[sunny_talwar]

What is they here? ref_Number repetitions or ref_Number and Value repetitions?

[effinty2112 · Accepted solution]

Hi,

try this straight table with dimension ref_Number:

ref_Number	count(ref_Number)-1
Raccc125	1

This shows that the only ref_Number that repeated was Raccc125 which repeated once.

To see how many repeats of ref_Number and Value add Value as a dimension. Normally Values we treat as the basis for an expression but in this case it makes sense to treat as a dimension.

ref_Number	Value	count(ref_Number)-1
Raccc125	500	1

Cheers

Andrew