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

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
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...

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 9 Years, 1 Month 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 9 Years, 1 Month ago Karma: 765

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