Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
scripting a sum value
Migrateduser
HI <br />
I have this query:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
select 'threatened' as type_menace, count(*) from tv_taxon_observe_commune
where tao_id_taxon in (select tao_id_taxon from tv_taxons_qualif_menaces)
and gez_id_geom_zonage = 217609
union
select 'less threatened' as type_menace, count(*) from tv_taxon_observe_commune
where tao_id_taxon in (select tao_id_taxon from tv_taxons_qualif_less_menaces)
and gez_id_geom_zonage = 217609
union
select 'non threatened' as type_menace, count(*) from tv_taxon_observe_commune
where tao_id_taxon in (select tao_id_taxon from tv_taxons_qualif_non_menaces)
and gez_id_geom_zonage = 217609
union
select 'non evaluated' as type_menace, count(*) from tv_taxon_observe_commune
where tao_id_taxon in (select tao_id_taxon from tv_taxons_qualif_non_evalues)
and gez_id_geom_zonage = 217609
</pre>
<br />
I have done a pie chart from the above query, a similar result is shown in the attached picture.<br />
Now the number 240 mentionned on the report means the sum of all the count i have in my query.<br />
How can I do this sum usig a script?<br />
Thank's for your help
Find more posts tagged with
Comments
There are no comments yet