| [NEWBIE]: Help on making a template [message #1580604] |
Fri, 23 January 2015 10:52  |
Eclipse User |
|
|
|
Hello dear eclipse birt users.
I'm fairly new to birt and reporting in general, and I'm struggling with a customer request I don't know how to accomplish.
I hope some of you will have time and willing to read this post and give me an hand.
I have to make a line chart with multiple series, i.e. multiple lines on the same chart.
I'm trying to simplyfy my problem to focus on what I cannot (because I'm not able to) achieve.
My template accept as input a variable named applicationlist=app1,app2,app3,...,appN , and I succeffully run a (rather complex) query returning me a dataset like the following:
NAME | TIME | MEASURE
-------------------------------------
app1 | 00:00:00 | 0.18
app1 | 00:00:01 | 0.28
app1 | 00:00:02 | 0.35
app2 | 00:00:00 | 0.51
app2 | 00:00:01 | 0.73
app2 | 00:00:02 | 1.06
app3 | 00:00:00 | 0.93
app3 | 00:00:01 | 0.25
app3 | 00:00:02 | 0.13
...
appN | 00:00:00 | 0.93
appN | 00:00:01 | 0.25
appN | 00:00:02 | 0.13
Now what I would like is to make one chart where X-axis is TIME, Y-axis is MEASURE, and several (N) series, one for each application.
I don't know how I can say to eclipse BiRT chart to dynamically create series based on distinct NAME values.
Is it possible to achive the goal I need to with eclipse birt ? how ?
thank you for any help.
best regards
G.N.
|
|
|
| Re: [NEWBIE]: Help on making a template [message #1580783 is a reply to message #1580604] |
Fri, 23 January 2015 13:15  |
| Eclipse User |
|
|
|
|
If you use your time field for the x-axis and your measure field for the y-axis, you should be able to use your name field for the optional y-series grouping field. This will create a series in your chart for each value in the name column. Hope this helps.
|
|
|
Powered by
FUDForum. Page generated in 0.03762 seconds
Home