14 Replies Latest reply: Apr 29, 2014 4:18 PM by Dariusz Mielczarek

Graphing multiple Expressions for multiple selections on a Dimension.

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?

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

can you please share the qvw?

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

Maybe trellis chart?

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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.

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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)?

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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.

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

A possible workaround...

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

Example:

=Dimension1 & Dimension2

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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:

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

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

You have 2 + 2

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

Another way,

Two overlayed line graphs, each one with one expression.,the top one, with transparente background and hidden axes

• Re: Graphing multiple Expressions for multiple selections on a Dimension.

Hi Clever, That is exactly what I was trying to avoid....read original thread.  I am hoping there is a far more elegant solution in QV for this problem      It can easily be accomplished with Excel and also Tableau.....

• Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Lewis,

i hope you like it

Let me know if it is what you are looking for.

regards

Darek

• Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Hello Dariusz, I like it!   Absolutly Brilliant!!!!   It worked

You solution was definitely elegant, but seems to me that QV should have a more straightforward way of handling this scenario.

Anyway, many thanks!!!

-Lew

• Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Lewis,

if it will be too easy, i will have no work

as a workaround there is always Community ....

And, next time you will know and not somebody else, so your value grows up

regards

Darek