Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So what i want to is make the selected points on a scatter chart a different color than the other points.
The equation here works if only select one point, but not more due to getfieldselections returning a string
if([nameField]=getfieldselections([nameField]),rgb(50,205,50),rgb(0,0,128))
I was thinking of writing an equation like this:
if ( *nameField* = getfieldselections(nameField) , color1, color2)
The idea being that if the nameField matches any part of the getFieldSelections string, then it returns color1.
to clarify the scatterplot it static and includes all points even with filters
Maybe like
=If(SubStringCount(GetFieldSelections(nameField,'|'),nameField), rgb(50,205,50),rgb(0,0,128))
This is what I've used before as color expression
colormix1(count(distinct nameField)/count({1} distinct nameField),LightGray(),green())