Different value for any group

[Anonymous]

Hello,

if i have PIPPO contain :

value 111111  5 times

value 22222 4 times

value 333333 7 times

value 44444 12 times

In expression section add :

count(distinct SubStringCount (VAR, 111111))

count(distinct SubStringCount (VAR, 22222))

count(distinct SubStringCount (VAR, 333333))

count(distinct SubStringCount (VAR, 444444))

the chart i obtain i have just one same (and only one) value and i need a value for any count.

Thanks

Mario Brozi

[Chanty4u]

count(Distinct urfield)

[sunny_talwar]

Not sure I completely understand what you are trying to do? Can you elaborate or provide a sample?

[Anonymous]

may be remove distinct from expression?

Still not clear, how data you are having in fields, could you post a sample?

[Anonymous]

If you have PIPPO then why you are using VAR?

[Anonymous]

Sorry PIPPO = VAR

[Anonymous]

How you can see the value blue and red in the graph are the same but they aren't.
If i use DISTINCT the value (green) isn't showed.

[sunny_talwar]

What do you get if you just use the expression without Count?

SubStringCount(PIPPO, 111111)

SubStringCount(PIPPO, 222222)

SubStringCount(PIPPO, 333333)

[Anonymous]

if i just use the expression without Count

SubStringCount(PIPPO, 111111)

SubStringCount(PIPPO, 222222)

SubStringCount(PIPPO, 333333)

i get Nothing, all blank.