[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 
How to use multiple X-AXIS alias? [CLOSED]  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
paraiso96.spw



Joined: 14/05/2015 09:53:50
Messages: 2
Offline

Hi,

I have a dataset like this:


I pass the year, month, business_center with 3 LOVs that work correctly, but I don´t know how to put these parameters in the SERIES LIST. I I tested this without success:
<SERIES_LIST>
<SERIES name="Product A Amount" alias="(YEAR,MONTH,BUSINESS_CENTER),PRODUCT_A_AMOUNT" color="#004080" type="column"/>
<SERIES name="Product B Amount" alias="(YEAR,MONTH,BUSINESS_CENTER),PRODUCT_B_AMOUNT" color="#ff8000" type="column"/>
<SERIES name="Product C Amount" alias="(YEAR,MONTH,BUSINESS_CENTER),PRODUCT_C_AMOUNT" color="#008000" type="column"/>
</SERIES_LIST>

If I put various parameters in the X-AXIS alias, some bars doesn´t appear beacuse they have the same value, for these reason I need to declare them in the SERIES LIST. Also the name of the X-AXIS bars are 1,2,3,4,5,6,7 instead of the value of the parameters (2013-January-1001):


Therefore I need to group them in categories if it´s possible, like this:


Thanks!

This message was edited 1 time. Last update was at 25/06/2015 09:16:04

giachino

SpagoBI hero
[Avatar]

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

Hi,
multiple axes are available for values's axes, not for categories. For the same reason you cannot to group by on more categories.

So, I think that you can concatenate categories throught the query and show the result on the chart .

Hope this help,

Antonella

Antonella Giachino
SpagoBI Consultant
[Email]
paraiso96.spw



Joined: 14/05/2015 09:53:50
Messages: 2
Offline

It's not what I wanted to hear , but thank you very much for your quick response.
 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team