Use two different dimensions as alternate filters for the same chart ?

[#1]

Hi,

I'm trying to use two different dimensions as alternate filters for the same bubble chart.

e.g. 1st scenario : "Type" filter selected which has categories like Type 1, Type 2 and Type 3

The chart shows segregation of data by "Type" and shows Type 1, Type 2 and Type 3  in the legend.

2nd scenario: " Status" Filter selected which has categories like "New", "In Progress" and " Close"

The same chart would show the segregation of data by "Status" and should show New, In Progress and Close in the legend.

Please advise.

[prabir_c]

Hello,

Do you trying something like this?

In script...

LOAD * INLINE [

    Type, Status, Value

    Type1, New,40

    Type2, Close,50

    Type3, In Progress,60

    Type4, Close,20

    Type5, In Progress,30

    Type6, New,100

];

I have used a Grid chart, 1. Dimensions: status, Type.  2.Expression =Value

Other properties are default.

[Colin-Albert]

Have a look at Cyclic Groups.

You can access this from the Edit Groups button on the Chart Dimensions sheet.

[Colin-Albert]

There is a video on Cyclic & Drill Down Groups here  Creating Cycle and Drill Groups