Skip to Content
0
Former Member
Dec 01, 2009 at 11:20 AM

How to show two queries/ aggregation levels in one Chart in Web Template

14 Views

Hi Experts,

I have a question regarding showing a graph in a Web Application template.

The graph has two elements on it. The key figure is average number of working days, but the requirement is to compare number of working days for a granular data level (time spent in each process stage per month) to the average across all process stages across the entire month.

So essentially what we have is a chart with one constant horizontal line across it, which is the overall average, across all process stages, for the whole month, and then underneath this horizontal line, a series of columns showing the average for each process stage, broken down.

I am having trouble getting the base query right for this requirement. It feels like for each process stage, I need two key figures (for the two data series); one average per stage, and the other should be the overall average, populated once for each stage.

I couldn't make this work using cells or replacement path, and I assume that you can only use one data provider per chart in the WAD.

Can anyone help me? Please let me know if you need more info. It's a shame I can't post a picture of the required graph in this post.

Thanks

Mischa