[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 
Dash with PieChart problem  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
luizcf14.spw

Newby

Joined: 26/01/2012 22:42:41
Messages: 10
Offline

Good afternoon to everyone, I'm trying to put together a dashboard with JFreeChart, I've read various topics on the wiki on how to do but I am confused on how to structure the database to a pie-shaped graph
Thanks for the help and collaboration of all!
gigavard

SpagoBI supporter
[Avatar]

Joined: 05/07/2010 13:30:10
Messages: 148
Location: Padova
Offline

Hi,
you can find your answer here
https://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Pie+charts

Anyway in brief this is the dataset form, where each column gives the value of the pie slice, the name of the column is the name of the cateogry

select 30 as January, 20 as February, 50 as March from dual

greetings
luizcf14.spw

Newby

Joined: 26/01/2012 22:42:41
Messages: 10
Offline

Thanks , i'm try use Jpivot in query but this not function look:


Jpivot transformation screen:


But this don't affect my query in preview.
Thanks for Help friend.
2017anuj.spw

Newby

Joined: 16/10/2017 11:46:30
Messages: 36
Offline

Medium Length hairstyles
Mens haircuts
Easy hairstyles
Portable blood pressure monitor
omron blood pressure monitor price
 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team