[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 
Highchart: hiding series [CLOSED]  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
cofla.spw



Joined: 20/09/2011 14:30:26
Messages: 9
Offline

Hi,

- I'm building a chart using the HighChart library and related SpagoBI xml templates. It loads data from a database,
- The query I get from the database contains a variable amount of columns (I use a stored procedure): from 2 (min) to ~24 (max),
- The first column contains date information while the other contain sold quantities. I use the 1st column as X-axis and the other cols as Y-axis,
- As I don't think it is possible to generate an Highchart XML template with a variable amount of Y-axis, I have created one that contains only 12,
- Often the number of returned columns is < 12, so it means that many of these 12 Y-axis are not always in use.

=> Would it be possible to hide the unused Y-axis or at least to keep them unselected (grey)?

Thank you very much for your answers!

Regards,

This message was edited 1 time. Last update was at 12/10/2011 08:43:53

cofla.spw



Joined: 20/09/2011 14:30:26
Messages: 9
Offline

Hi again,

I have taken screen-shots of the problem, take a look: the number of series containing data is 5, still all series (12) are shown and I would like the 7 series that do not contain data/do not have any related column on the returned query to be unselected/grey.

CHART AND SERIES:

mospinel

SpagoBI friend
[Avatar]

Joined: 14/07/2010 10:14:20
Messages: 91
Offline

Hi,
with the Highcharts API is not possible, at the moment, disable the series with value 0. When you define a series the chart displayed it in an active way, even if his value is 0.
cofla.spw



Joined: 20/09/2011 14:30:26
Messages: 9
Offline

Hi mospinel,

thanks for your answer. In fact I reach the same conclusions than you after having "played" a bit with the Highchart modules: the series are always active, they can be unselected only manually. This is a Highchart "problem", SpagoBI does not have any incidence on this.

Hopefully, a later version of Highchart will contain an option that will handle this case. Not a blocking problem anyway. I'll mark this problem as CLOSED (even though it is not yet solved/not solvable).

Regards,

This message was edited 1 time. Last update was at 12/10/2011 08:46:20

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