Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

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

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

  • edited October 21, 2019

    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.

    Regards,
    Jeff F.
    Sr. Technical Support Specialist
    OpenText
  • it helps. Thank you

  • Great!

    Regards,
    Jeff F.
    Sr. Technical Support Specialist
    OpenText
Sign In or Register to comment.