PDA

View Full Version : % of whole bar chart



dherzog
09-24-2007, 04:55 PM
Good afternoon-

I have a result set taken from an XACTION that I'd like to use as input to a stacked bar chart. That works. Now, what I'd like to do is graph each chart as a stacked 100% bar chart (where each item is plotted as a percentage of the whole in that category; see attachment for mockup done in Excel).

Does Pentaho have a chart type that allows for that? Or do I have to perform that calculation using the SQL query?

Since I have my query working properly now, is this something that can be done with an XACTION? (I understand you can take one XACTION and use that as input to another to transform/filter the data). I'm good enough at SQL, but doing anything complicated with the XACTION's is mystifying me so far.


Thanks,

-Daniel