nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bar chart report series values

sivagv1

Hello, 
 
I am very new to birt reporting, I have a bar chart report like this

Find more posts tagged with

Comments

pricher

Hi,
 
Assuming you have Series1 and Series2 as two columns in your data set:

sivagv1

Hi Richer,
 
Thanks for the reply, I have followed the steps suggested by you.
But it is not displaying the expected results.

pricher

Hi,
 
Can you share more details about your data? It's hard to diagnose by just looking at the screenshot.
 
Thanks,
 
P.

sivagv1

Hi, 
 
Here is my query to get the data for chart 

<pre class="_prettyXprint">
select 'YES' compliance, to_date(to_char(targcompdate, 'Mon YY'), 'Mon YY') month,
1 as compcnt, 1 as totcomp from workorder wher clause....

Union

select 'NO' compliance, to_date(to_char(targcompdate, 'Mon YY'), 'Mon YY') month,
0 as compcnt, 1 as totcomp from workorder where clause...</pre>
Category X-Axis : row["month"] grouping on MONTH
Y-Axis Series-1 : row["totcomp"]
 Series-2: row["compcnt"]
 
and I have given ( row["compcnt"]/ row["totcomp"])*100 for secondary Y-Axis and it is not giving the expected results.

pricher

Hi,
 
My example worked with data already aggregated in the query. If you rely on BIRT to aggregate your data, then this modified example will help you.
 
In this new example, DataSet1 does not aggregate Series1 and Series2. I create a hidden table, grouped on Order Date, where I create SUM aggregations for Series1 and Series2 at the Order Date level. In the chart, use data coming from the hidden table (you have to name the table, in this case MyTable) and use the group and aggregations created in the table.
 
Hope this helps,
 
P.

sivagv1

Thank you, it really helped me.