Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vitaliichupryna
Creator III
Creator III

GetFieldSelections in scatter plot chart

Hi,
In my scatter plot chart I have ABBRC field as bubble and X and Y as axises. Also I had field CHK in my data model.
Client wants mark selected ABBRC in green bubble, other bubbles should be marked based on CHK field, below you can see my expression:
IF(ABBRC = GetFieldSelections(ABBRC), Green(),
IF(CHK = 1, Red(), Blue()))
As I want to show all ABBRC I use following expression for X and Y:
sum({<ABBRC=>}X)
sum({<ABBRC=>}Y)
For some reason my color expression doesn't show correct color when I make selections in the ABBRC column.
It shows selected ABBRC as green bubble, other bubbles are grey.
When I deselect ABBRC chart shows colors based on CHK column

Thanks,
Vitalii

1 Reply
rubenmarin

Hi, looks like the selection in ABBRC doesn't allow to reach CHK in those bubbles, try with:
IF(Only({<ABBRC=>}CHK) = 1, Red(), Blue()))