Hello, my problem is that I have on few visualizations query strings on top of the fusion chart after the lat update! The chart looks ok! Any Idea?
here is the link to a test chart: https://www.proopps.com/index.php/tesz-geo
thanks
regards jnskst
ELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_third_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_next_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_current_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY label
here is the link to a test chart: https://www.proopps.com/index.php/tesz-geo
thanks
regards jnskst
ELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_third_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_next_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY labelSELECT SUM(value) AS value, label FROM (SELECT DISTINCT `M_forecast_dashboard`.`id`, M_forecast_dashboard.sum_current_fiscal_year AS value, 'calc' AS label FROM `M_forecast_dashboard` LEFT JOIN `market_segments` AS `market_segments` ON `market_segments`.`id` = `M_forecast_dashboard`.`segment` LEFT JOIN `activity_status` AS `activity_status` ON `activity_status`.`status_id` = `M_forecast_dashboard`.`opp_status` LEFT JOIN `#__users` AS `q8rp9_users` ON `q8rp9_users`.`id` = `M_forecast_dashboard`.`sales` WHERE ( M_forecast_dashboard.region = (SELECT `region` FROM `user` WHERE `user_id`=42) )) AS t GROUP BY label