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.

How to show grouped aggregation data in line chart?

Hi everbody,

This is my first question in this platfrom. I have grouped date in my birt report and all grouped data also has aggregation. I have added and image. ı need to show the grouped aggregation data in line chart. But I could't be successfull. Chart does not show the correct data as its calculated in grouped aggregation data.

I also added report document. Please help me to show aggregated data in chart as month by month

Comments

  • edited February 20

    Try temporarily adding 2 columns to the table for testing. Add a data element in the detail row of each of the columns. For the data element expressions, copy the expressions from the two chart series. Then add a PercentSum aggregation to the footer of the new columns and run the report. Being able to see all of the numbers in the table should make it easier to tell what is happening.

    Jeff F.
    Customer Support Engineer I
    OpenText
Sign In or Register to comment.