Selecting correct data while creating a meter chart.

[Edzzio]

Hello,

I'm completely new to BIRT (the version of BIRT that I'm using is 4.8) and I'm not a computer scientist. Currently I'm tasked with creating different types of reports using data from an outside database. I'll be using different types of charts (in this case, a meter chart) to display data, but I've come across a problem.

Selecting the correct type of data to display is the main issue, here are some screenshots with brief explanations for each:

Firstly, I created some computed columns showing the number of open tasks to do, as well as tasks with significant delays in between its inception and its completion.

Here is a preview of the aforementioned data:

The two outer columns are the ones that interest us, 14 and 13 or the numbers I want to display on my meter chart.. I used aggregations to indicate the highest values (since displaying a list of numbers on a meter chart seems illogical, if I'm wrong, please correct me) and created new variables to display the data, an example is below:

This is a code for the "numberInterv" column, it will increment "open_inter" by +1 everytime there is an open task. It seems to be working correctly as showcased by the previous screenshot.

While selecting the data for the chart, and previewing it I've come to this:

The same columns (weirdly it states "row" and not "column") that I've chosen are now empty, 14 and 13 are no longer attributed to those columns.

What I've tried to do:

• Try using the VARIABLES (instead of the column values) to display data
• Created report parameters, but those are not available while creating the meter chart (they are, but despite my report parameter working, it's not correctly displaying)

I thank you in advance for the answers, and I wish you all a wonderful day.