Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


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




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

[SOLVED] Pie chart shows only one column
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: [SOLVED] Pie chart shows only one column
#58448
[SOLVED] Pie chart shows only one column 1 Year, 4 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?
Last Edit: 2016/09/08 05:53 By vladimir84.
The administrator has disabled public write access.
 
#58451
Re:Pie chart shows only one column 1 Year, 4 Months ago Karma: 672
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
The administrator has disabled public write access.
 
#58452
Re:Pie chart shows only one column 1 Year, 4 Months ago Karma: 0
worked like a charm
thanks
The administrator has disabled public write access.
 
Go to topPage: 1