[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
HighCharts - multi lines chart [SOLVED]  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
guillaume.spw

Newby

Joined: 27/10/2011 11:20:31
Messages: 38
Offline

Hi,

Is it possible to create a chart with several lines, each line defined by a variable ?
For example, I have three columns a , b and c, where a is the line number, b is the abscissa x and c is the y.

In your examples, from a dataset point of view, I feel that there is a common column (the abscissa ) and for each line, there is a column. If I have 5 lines, so I will have 1 + 5 columns. Is it possible to reduce that number to three as I read explained above?

Thanks,

This message was edited 1 time. Last update was at 28/11/2011 14:23:06

giachino

SpagoBI hero
[Avatar]

Joined: 05/07/2010 15:41:54
Messages: 355
Location: Turin, Italy
Offline

Hi guillame,
the engine wants a serie definition for each line, so the dataset should return a column for each one.

Told this, you could semplify your original query applying the pivot tranformation on its result.

Other informations at http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/data_set#HTransformations

Hope this help,

Antonella


Antonella Giachino
SpagoBI Consultant
[Email]
guillaume.spw

Newby

Joined: 27/10/2011 11:20:31
Messages: 38
Offline

Hi,

It works,

Thanks
 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team