[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 
Parameter based on field names [CLOSED]  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
cmoloney.spw



Joined: 24/04/2015 17:26:53
Messages: 4
Offline

Hi,

I want to create a chart that is Metric vs. Time. However I want to be able to change the metric according to what is selected as a Parameter. So for example I have Sales vs. Time but then select Revenue from a dropdown to replace sales. Is this possible?

This message was edited 1 time. Last update was at 18/05/2015 09:14:28

cmoloney.spw



Joined: 24/04/2015 17:26:53
Messages: 4
Offline

Does anyone have an ideas for this? I tried setting the data type to Generic when creating the dataset, and this seemed to work when viewing a preview of the dataset, but when I went to use it in the chart I'm getting an error saying sum on non-numeric data not allowed (is there a way I can make it numeric?). I think I'm getting this error because it seems to be passing a % as the values of the data
cmoloney.spw



Joined: 24/04/2015 17:26:53
Messages: 4
Offline

Does anyone have an ideas for this? I tried setting the data type to Generic when creating the dataset, and this seemed to work when viewing a preview of the dataset, but when I went to use it in the chart I'm getting an error saying sum on non-numeric data not allowed (is there a way I can make it numeric?). I think I'm getting this error because it seems to be passing a % as the values of the data
giachino

SpagoBI hero
[Avatar]

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

Yes, probably the problem is that values aren't numbers.

Anyway could you post the template?


Antonella Giachino
SpagoBI Consultant
[Email]
cmoloney.spw



Joined: 24/04/2015 17:26:53
Messages: 4
Offline

I managed to get it working in the end. Thanks!
 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team