Colon separated values - reports and charts
719404Nov 6 2009 — edited Nov 7 2009Data from a checkbox item is stored in a column separated by colons.
When users try to use the report builder function to chart it is not grouping as we expected.
For example the column contains the following rows:
A:B:C
A:B
C
C
We want the sum of distinct values. For example
A = 2
B = 2
C = 3
Instead we get:
A:B:C = 1
A:B =1
C =2
How can we acheive this?
Nan