Help on Scatter/Grid

[#1]

HI All,

I have two scenarios:

1st Case:

I have a field called ABS.

In the Bubble chart on X axis i should show the Location and Y axis is Category.

Bubble size is Count of the Products. But when user selects a value from the field ABS then the bubble size should be count of the Parts which are having ABS more than or equal to selected ABS value.

2nd case :

When user selects Selected range of values from ABS then the Bubble size should be Count of products which fall under the selected range of ABS.

Can anyone help me on this?

More over should I go for Scatter chart or Grid Chart?

[mdmukramali]

Dear,

Can you attache the sample file. so that it's easy to help you.

Thanks,

Mukram

[#3]

HI Ali,

I am unable to attach the file.

AM i not clear on the requirement?

Just I need how to handle the situation.

BR,

Neehu

[rubenmarin · Accepted solution]

Hi, if I correctly understand this, you only need to add conditional expressions fro the 3rd expression (bubble size):

Condition: GetSelectedCount(ABS)=0

Expression: Count(Distinct Product)

Condition: GetSelectedCount(ABS)=1

Expression: Count({<ABS={">=$(=ABS)"} Distinct Product)

Condition: GetSelectedCount(ABS)>1

Expression: Count({<ABS={">=$(=Min(ABS))<=$(=Max(ABS))"} Distinct Product)

[#5]

HI Marin,

I am using the below expression but it is not working. Giving an error. ANy syntax error I am making?

= IF( GetSelectedCount(ABS)=0 , Count(Product),

IF( GetSelectedCount(ABS)=1, Count({<ABS={">=$(=ABS)">} Product),

IF(GetSelectedCount(ABS)>1 , Count({<ABS={">=$(=Min(ABS))<=$(=Max(ABS))">} Product))))

The error I am getting in the chart is

"Error in set modifier ad hoc element list: ',' or ')' expected"

[#6]

Hi Marin,

Got the issue. Missing "}".  Thank s a lot