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; } } }

Transposing Columns to Rows Best methods

jimseconde

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

Find more posts tagged with

Comments

Hans_vd

You can create a crosstab and then right-click -> "Create chart view"
 
Does that do the trick for you?

jimseconde

It's not liking the dataset it's being given at the moment - which in the crosstab is correct.
 
Data Preview for the chart view is still viewing all of the crosstabbed columns as columns as it were rather than transposing them to rows. I also can't define the axis, though I'm not sure whether you're supposed to be able to do that.

jimseconde

To follow up-
 
According to the layout of the bar chart, the above data would need to look like this:
 
Dist TOTAL
100 1008
100-500 1001
500-1000 588
 
So that I drop 'Dist' into the Y-Axis and TOTAL into the X-Axis.
 
This takes about 1 minute in Excel. Are we saying BIRT isn't able to total rows and put them in a bar chart?

JFreeman

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.
 
Also, are you sure you are wanting 'Dist' as the Y-Axis and 'TOTAL' as the X-Axis? This seems backwards to me.

jimseconde

Hi,
 
Thanks for the reply.
Yes, sorry I got my axes mixed up: 'Dist' is X, Total numbers are Y.
 
Transposing is still a problem, but a different beast now. I got so bored finding workarounds for CSV/Excel transposing (without transposing at source which would take 5 mins to be honest) that I switched to JDBC and am now fighting transposing with SQL connecting to an Oracle 10g database.
 
So, as my solution and problems change there's not really much need to attach what I was working on.
 
Transposing data rather than crosstabbing seems to be involved in almost everything I'm doing at the moment, yet it seems to be the least friendly aspect of data drilling/manipulation in BIRT....

JFreeman

Thanks for the update and details.
Let us know if you have any additional specific questions.