BIRT- IMPORTANT!!!!!, How to display multiple columns in a chart (ex. Pie chart

Khaled228
edited February 11, 2022 in Analytics #1

Hello everyone,
I'm working on Report where i have a dataset that includes three columns ( col1,col2,col3). the three columns are computed columns which based on a columns named (value).

Is there a way where i can display the three values in a pie Chart?

please see attached pic for better Understanding.

Please note that the dataset retrieve the data from an XML-Data source which has a fixed row to coulmn relationship

I would be grateful if i could get any help

Regards

Comments

  • jfranken
    edited October 21, 2019 #2

    The data set is not correct for the pie chart described. A different data set is needed. Add two columns to the data set- "computation_type" and "computation_amount". To convert the existing rows of data to the new rows, loop through all of the existing rows and do the following for each row in the current data set:

    1. Add a row to the new data set
    2. Set computation_type = "Average_failed"
    3. Set computation_value equal to the "Average_failed" value in the current row
    4. Add a row to the new data set
    5. Set computation_type = "Variance"
    6. Set computation_value equal to the "Variance" value in the current row
    7. Add a row to the new data set
    8. Set computation_type = "STDDEV"
    9. Set computation_value equal to the "STDDEV" value in the current row

    You will be adding three rows to the new data set for each row in the current data set, so the new data set will have 3 times as many rows as the current data set. Create a pie chart with the category set to the computation_type column and the slice set to the computation_amount column.

    Warning No formatter is installed for the format ipb
  • it helps. Thank you

  • Great!

    Warning No formatter is installed for the format ipb