Pie Chart

[Former Member]

Which fields in the Data Mapping tabs should be used while creating a pie chart? I have two columns:

DamageCode Frequency

A 2

B 1

C 1

D 4

How would I plot this on a pie chart.

Thanks.

[Former Member · Accepted solution]

Ah, actually, the Pie Charts look at only one row of data. So your data should look something like this:

Columns:

DateTime | DamageCodeA | DamageCodeB | DamageCodeC | DamageCodeD

Row:

some date | 2 | 1 | 1 | 4

Instead of two columns, and many rows, it should be many columns and one row.

Hope this helps.

[Former Member]

Hi Mahwish,

Frequency column should be mapped to Value Column and DamageCode should be mapped to the Label Column.

This should work without mapping anything however. Sometimes you get lucky.

Don't forget to clear the java cache.

[Former Member]

Hi Ryan,

I tried that already, but when I look at the dynamic page generator with the query , nothing shows up on the chart. Are there any other parameters I have to change on pen details etc.

Thanks,

Mahwish

[Former Member]

Hi Mahesh,

Map the <b>damage code</b> Column to <i>Label columns</i> and <b>frequency column</b> to <i>Value columns</i>. Is there any other column you are mapping? Are you changing any default parameters?

Clear your java cache and try the same. It is working for me...

If you change the structure like this means

DamageCode A B C D

Frequency 1 2 3 4

Map A, B, C, D columns to the Value Columns.

Both will give the same result.

Regards,

Kishore kumar P.S.