[Anonymous]

Hi,

There is requirement in our project that we need a chartview for each list item in custom list , where the all columns will have only three values as Started,Not Started,Completed.

For each listitem we need a chart ,

Example: List has 6 columns say col1=”started”,col2=”not started”,col3 =”completed” ,col4=”started”,col5=”not started”,col6 =”completed”

Now, i need a chart for each list item with sum of all the column similar values,

Count (Started)=2

Count (Not Started)=2

Count (completed)=2

for each list Item.

Please provide some example , if its possbile with quest QchartView.

thanks,

Aniketh

[Anonymous]

Hi Aniketh,

  I'd recommend you to normalize the list.

Instead of having the status as a column name use it as an item value. Then the chart would do the counting for you and build the chart.

Original structure

Started    Not Started…                      

to

Status

Started

Not Started

.

.

[Author]

Posts