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


Recent Events
  • 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.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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, 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?
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, 1 Month ago Karma: 667
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, 1 Month ago Karma: 0
worked like a charm
thanks
The administrator has disabled public write access.
 
Go to topPage: 1