ARI Soft - [SOLVED] Pie chart shows only one column

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

[SOLVED] Pie chart shows only one column

(1 viewing) (1) Guest

Page: 1

TOPIC: [SOLVED] Pie chart shows only one column

Forum Tools

#58448

[SOLVED] Pie chart shows only one column 7 Years, 7 Months ago Karma: 0

I'm trying to do a split between male/female and this is my query:

Code:

select

count(case when datipersonali.id_uomo_donna='1' then 1 end) as Uomini,

  count(case when datipersonali.id_uomo_donna='2' then 1 end) as Donne from datipersonali

where datipersonali.con_stato = '1'

it only shows the first column as 100% and only one in the legend.
what am I missing here?

vladimir84

Last Edit: 2016/09/08 11:53 By vladimir84.

The administrator has disabled public write access.

#58451

Re:Pie chart shows only one column 7 Years, 7 Months ago Karma: 747

Use the following SQL query and set "Revert data" parameter to "Yes":

Code:



SELECT

  'Count',

  COUNT(case when datipersonali.id_uomo_donna='1' then 1 end) AS Uomini,

  COUNT(case when datipersonali.id_uomo_donna='2' then 1 end) AS Donne 

FROM 

  datipersonali

WHERE 

  datipersonali.con_stato = '1'

Regards,
ARI Soft

admin