[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 
Pie Chart: Data labels missing sometimes  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
hemgoyal.spw

SpagoBI friend

Joined: 07/09/2011 17:35:07
Messages: 88
Offline

Hi Guys,

I m facing a very strange problem with pie chart.

Sometimes data labels are not shown on the pie chart. I changed the query and it starts showing.

Is there any specific reason for it ??

Thanks

This message was edited 1 time. Last update was at 29/09/2011 14:45:14

mfcanovas.spw

SpagoBI friend

Joined: 20/09/2010 11:14:49
Messages: 59
Offline

Check the data type of the labels column. It can cause problems if it is not type string.
buffy.spw

Newby

Joined: 01/06/2012 17:17:14
Messages: 20
Offline

Hello,

I have the same problem. I have set a string type but still it doesn't work.
Sometime I have data label on pie charts, in others charts I have. I couldn't found out where is the problem.

Have you found out how resolve this problem.

Regards,
buffy
hemgoyal.spw

SpagoBI friend

Joined: 07/09/2011 17:35:07
Messages: 88
Offline

Hi Buffy,

I haven't find solution for this problem.

I think we should share the result dataset..so that we can find any similarities.

Thanks
pullad.spw



Joined: 18/04/2013 23:34:54
Messages: 2
Offline


I was facing the same issue and it became a show stopper for us. I had multiple charts and one of it not showing the labels. I had two columns one title and other count. One title was "Other" and other title "fact". This it will not work, but if I replace "fact" to "title fact", it work. So I concluded may be Spago did not like "f words". Later I had a title start with "a" and same issue. if I start this with "s" it work. Then I spent half day and found the solution.

The fix is the pie expects the count to be in descending order. In query we need to give "order by COUNT DESC". For my example above title "Other" had high value and other two has less count. So when I change title to "title fact or start with "s" on default ordering on title these two goes below of row with "Other" title, so it work.

Hope this will help others, I will report this bug to Spago support.

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