Graphing multiple Expressions for multiple selections on a Dimension.

[#1]

Is there a way to chart multiple expression that share the same dimensions for multiple selections without resorting to overlay charts?  For example my dimensions are SYS_DATE and SYSTEM with an Expression of (AVG_DAILY_BUSY).   With one expression I can select 1 or multiple SYSTEMs and each will get its own line on the chart.  With the addition of a second expression (MAX_HOURLY_BUSY) when I select a System it charts both expressions for the SYSTEM dimension, but one can no longer chart multiple systems, in fact selecting multiple systems now results in a blank chart.

With one expression:

With two expressions one dimesion selected:

With two expresions multiple dimensions selected:

What I really want is to be able to select one to multiple Systems and chart both expressions for all selected.  I know I can do this with overlays, but thinking there is a much more elegant solution here?

[MarcoWedel]

can you please share the qvw?

[#3]

Maybe trellis chart?

[Clever_Anjos]

Not using line chart, because it does not stack.

Another point is that a graph with more than 7 or 8 lines can be very messy and hard to understand

[#5]

Here is what my graph looks like in EXCEL, this is what I wish to duplicate with my QV Dashboard:

As you can see the expression are such that the groupings will alway be seperate and quite clear.  Seems there should be a simple way to do this in QV...    I'm actually graphing three Expression in this example.

[Greg_Williams]

Have you tried to associate in the Axis tab (chart properties) - the appropriate expressions with the Primary or Secondary axis (i.e. left and right axes)?

[#7]

Hi Greg, You did teach me something new as I was unaware of this feature , but it doesn't solve my problem.  Setting the primary expression position to left and secondary expression position to right on the Axes Tab resulted in seperate scales for each, but did not enable graphing of multiple selected dimension for each expression.

[Clever_Anjos]

A possible workaround...

Instead of having two dimensions, please use only one calculated, concatenating dimensions.

Example:

=Dimension1 & Dimension2

[#9]

Hi Clever, not sure I understand what you are proposing here.  My Dimensions currently are SYSDATE and SYSTEM and myExpressions are AVE_DAILY_BUSY MAX_HOURLY_BUSY.

  

Concatinating my Dimensions results in a graph like this, which accumulates the values for the SYSTEM Dimension rather than graphing each SYSTEM as a seperate line:

[Clever_Anjos]

Sorry my fault, I was wondering 3 dimensions + 1 expression..

You have 2 + 2