<p>I want a percentage of sum(numValue) / sum(denValue)<br><br>
with my query being SELECT numValue, denValue, ... area, state, organization ...<br>
I don't think I can do any type of sum in my query<br><br>
in the chart GUI there is expression builder but I don't see any type of expressions to do sum</p>
<p>and in the aggregate expression drop down just below the series there is these<br>
None<br>
Moving Average<br>
Running Sum<br>
Running NPV<br>
Rank<br>
is...<br>
Percent Rank<br>
Percent Sum<br>
Running Count<br><br><br>
this calculation is basically the percentage of the num/den of the data that will be shown - but the data will have to be filtered to certain area, or state, or org etc<br><br>
if you say the calculation has to be done in the query I don't see how I can group data by say or by org on the fly if those values are in the query.<br><br>
</p>
