Issue with Graph

[#1]

Dear all,

I have a combo chart as attached. while selecting a grade all the providers are showing in one line. will it be possible to show different providers in different lines for a single Grade.

the qvw has been attached for your reference.

Thanks in advance..

[manideep78]

Hi Reena,

What exactly do you mean by different line for different provider? I mean is it the Axis lines that you want as different lines? If So, you are taking grade as X-axis. So if you select a grade all the providers will lie on the same Axis line.

[bertdijks]

Hi Reena,

Attached you will find a possible (raw) solution

I add the Grade dimension, so that depending on the level of drill-down/filtering the order of the dimension is changed:

If Grade is not selected (default) the first Grade is shown because of the conditional formula

if(GetSelectedCount(Grade)=1,0,1)

When Grade is selected (so selected count=1), then the first one is not shown, but the second is.

Hope this helps.

Kind regard,

Bert

[#4]

Hi,

if i select more than 1 grade, is it possible to do the same??

[rajat2392]

You can create a DRILL-DOWN Dimension group of Grade and Provider. So when you click on any grade, the dimension will become provider, and for that grade only the providers will be shown in different line.

[#6]

hi,

The requirement is like,without any selection also it should show grade wise 3 providers in 3 different axis lines. is i possible to achieve that. by default the for each grade there should be 3 lines.

[rajat2392]

No, if you are giving 2 dimensions, then also the axis lines will be for the first dimension only. Whichever is first, axis lines will be according to that only.