Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Transposing columns to rows with totals for bar chart
Transposing columns to rows with totals for bar chart [message #1638872] Fri, 27 February 2015 10:35 Go to next message
Jim Seconde is currently offline Jim SecondeFriend
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
Re: Transposing columns to rows with totals for bar chart [message #1647133 is a reply to message #1638872] Tue, 03 March 2015 09:14 Go to previous messageGo to next message
Jim Seconde is currently offline Jim SecondeFriend
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...
Re: Transposing columns to rows with totals for bar chart [message #1650341 is a reply to message #1647133] Wed, 04 March 2015 19:48 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
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.
Re: Transposing columns to rows with totals for bar chart [message #1660928 is a reply to message #1650341] Mon, 09 March 2015 11:55 Go to previous message
Jim Seconde is currently offline Jim SecondeFriend
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
Previous Topic:Exception when displaying a Report (as html)
Next Topic:Newbie - Reading in data basics
Goto Forum:
  


Current Time: Tue Jul 23 15:13:52 GMT 2024

Powered by FUDForum. Page generated in 0.04089 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top