manipulating list data before chart is created


https://www.nevron.com/Forum/Topic3645.aspx 		Print Topic | Close Window

By Oliver Andrews - 14 Years Ago

Hi All,

I need to know if it's possible to manipulate data before creating the chart?

e.g. I have a list with a single column of strings. I want to create a graph of this using all distinct entries for the x-axis and the count of that entry on the y axis.

I've not managed to find anything in the online docs or forum so far.

Any help greatly appreciated.

Cheer,

Olly
By Nevron Support - 14 Years Ago
Hi Oliver,

Yes you can make this chart. Lets say you have the following list:

Country

USA
USA
China
Germany
China
USA
Germany
France
France

1. In the pivot page - drag and drop the Country field in the categories drop spot
(e.g. group by the Country field).

2. Set the category label to be the following expression:
=Fields!Country

3. In the pivot page - create a single Value (select the Values tab and click the Add button).

4. Enter the following expression in the Value field:
=Fields![RowCount]

You must see a chart with 4 bars. The category labels must be set to:
USA, China, Germany, France

The bar values must be:
3, 2, 2, 2

Hope this helps - questions or comments - please feel free...