Eclipse Community Forums: BIRT » format of data for a bar chart

Help

Home

Home » Archived » BIRT » format of data for a bar chart(how should my sql table look to create a bar chart)

Show: Today's Messages :: Show Polls :: Message Navigator

format of data for a bar chart [message #734344]

Fri, 07 October 2011 14:00

Missing name Missing name

Messages: 5
Registered: September 2011

Junior Member

Hi All,

I have a simple chart I would like to display from my JBOSS application.
For each day, I keep track of events and I want to display the number of events each day in a bar chart. The number of events can be zero events to 30ish events.
The bar should represent the day of the week, and be either 0 or up to 30 high.

If I create a sql tabel with just one int column and put each days data in a separate row and create 7 rows, then use the int column as the x axis it does not draw the chart correctly.
It appears I need some way to index the day as well as the data for that day.
Do I need a separate column, called dayIndex that would that references the day?

Sorry if this question seems vague, I don't have any working exampls of the sql data to look at to draw a simple bar chart.

Thanks

Bruce

Report message to a moderator

Re: format of data for a bar chart [message #734405 is a reply to message #734344]

Fri, 07 October 2011 16:08

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Bruce

the int column should be on the y axis and then either use RowNum as the
x-axis or add a new column for the day of the week.

Jason

On 10/7/2011 10:00 AM, heathb wrote:
> Hi All,
>
> I have a simple chart I would like to display from my JBOSS application.
> For each day, I keep track of events and I want to display the number of
> events each day in a bar chart. The number of events can be zero events
> to 30ish events.
> The bar should represent the day of the week, and be either 0 or up to
> 30 high.
>
> If I create a sql tabel with just one int column and put each days data
> in a separate row and create 7 rows, then use the int column as the x
> axis it does not draw the chart correctly.
> It appears I need some way to index the day as well as the data for that
> day.
> Do I need a separate column, called dayIndex that would that references
> the day?
>
> Sorry if this question seems vague, I don't have any working exampls of
> the sql data to look at to draw a simple bar chart.
> Thanks
>
> Bruce

Report message to a moderator