Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count(Distinct urfield)
Not sure I completely understand what you are trying to do? Can you elaborate or provide a sample?
may be remove distinct from expression?
Still not clear, how data you are having in fields, could you post a sample?
If you have PIPPO then why you are using VAR?
Sorry PIPPO = VAR
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.
What do you get if you just use the expression without Count?
SubStringCount(PIPPO, 111111)
SubStringCount(PIPPO, 222222)
SubStringCount(PIPPO, 333333)
if i just use the expression without Count
SubStringCount(PIPPO, 111111)
SubStringCount(PIPPO, 222222)
SubStringCount(PIPPO, 333333)
i get Nothing, all blank.