Skip to main content


Eclipse Community Forums

      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 05:35 Go to next message
Eclipse UserFriend
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 04:14 Go to previous messageGo to next message
Eclipse UserFriend
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 14:48 Go to previous messageGo to next message
Eclipse UserFriend
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 07:55 Go to previous message
Eclipse UserFriend
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: Sun Aug 31 00:12:33 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly