Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Column values to row values for a chart
Migrateduser
Hi,<br />
<br />
I need some advice on how to proceed with a problem with converting a single row of data to two columns for use in a bar chart. One column containing the category and one containing the value. So the result from the data set looks a little like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
col_1_10 col_11_20 col_21_30 col_31_40 col_41_50 ....
12 45 75 81 104
</pre>
<br />
So to create a chart I need something like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
Percentage Value
10 12
20 45
30 75
40 81
50 104
...
</pre>
<br />
I have tried constructing a table using the above structure and then trying to use that as a chart's data source, but this does not work as the chart sees the original table bindings.<br />
<br />
This appears to be a classic example of translating data from the database world to the BIRT world. Anyone got any suggestions?<br />
<br />
Thanks in advance,<br />
Stephen
Find more posts tagged with
Comments
There are no comments yet