Eclipse Community Forums: BIRT » Transposing columns to rows with totals for bar chart

Help

Home

Home » Archived » BIRT » Transposing columns to rows with totals for bar chart

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

Transposing columns to rows with totals for bar chart [message #1638872]

Fri, 27 February 2015 10:35

Jim Seconde

Messages: 19
Registered: February 2015

Junior Member

Hi,

There seems to be several ways to achieve what I'm trying to do, but it's not entirely clear to me (I'm only just getting the hang of crosstabbing and dimensions)

I have data laid out like so:

Month 100 100-500 500-1000
Jan 342 423 234
Feb 133 234 123
Mar 533 344 231

What I'm trying to get out of this dataset is a bar chart, with the columns as the X-Axis and the total value as the Y-Axis.

Transposing the columns to rows is doable in a crosstab, but how can I do it for the dataset in order for the data to be used correctly in each axis of a bar chart?

Thanks in advance

Report message to a moderator

Re: Transposing columns to rows with totals for bar chart [message #1647133 is a reply to message #1638872]

Tue, 03 March 2015 09:14

Jim Seconde

Messages: 19
Registered: February 2015

Junior Member

It seems that transposing data is either very fiddley (after looking at practises involving scripted datasets) or is just a question not asked regularly.

Is there really no simple way of making totals of some column rows add up to one new row then displaying the columns in the X-Axis of a bar chart? From a background in Excel reporting, this shouldn't be as hard as I imagined it would be...

Report message to a moderator

Re: Transposing columns to rows with totals for bar chart [message #1650341 is a reply to message #1647133]

Wed, 04 March 2015 19:48

Jesse Freeman

Messages: 184
Registered: January 2015

Senior Member

Can you attach a sample report with a flat file data source that demonstrates your data configuration and data set you are wanting to created into a bar chart?

I am not clear from your description the way this is configured.

Report message to a moderator

Re: Transposing columns to rows with totals for bar chart [message #1660928 is a reply to message #1650341]

Mon, 09 March 2015 11:55

Jim Seconde

Messages: 19
Registered: February 2015

Junior Member

Hi, sorry for the delay in responding. This has been sorted by changing the data source and getting Oracle SQL to pivot the data using MAX(DECODE).
Thanks

Report message to a moderator

Previous Topic:	Exception when displaying a Report (as html)
Next Topic:	Newbie - Reading in data basics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 15:27:59 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter