Forum Discussion

kai_krueger's avatar
kai_krueger
New Member
9 years ago

Color in Scatter Chart

Dear all,

 

I have a problem with my scatter charts.

Within the Chart there are several data points. Each data points has information in further columns.

Now what I am trying to do is the following:

Depending on the filters I set for the report, I would like to color of the scatter to change.

 

E.g.: All points which "meets" the filter criteria shall have one color, the other ones shall have a different color.

One Example.

1) X = 10, Y = 10, Info_1 = A, Info 2=B

2) X = 20, Y = 10, Info_1 = B, Info 2=B

 

Now I set filters to Info_1 = A and Info_2 = B.

Then I would like (1) to have red color and (2) to be grey (because (1) meets the filter criteria but (2) does not).

 

Is that possible? Could you please explain this to me?

Thanks a lot in anticipation

Kai

 

 

7 Replies

    • kai_krueger's avatar
      kai_krueger
      New Member
      9 years ago

      Thanks, that was helpful.

      So now I am trying to use the "Legend" to define the color.

      Is there a possibility to have a "dynamic" measure?

      In my report I would like to set the filters.

      Then based on the set filters the measure should for each data point calculate where it is suffering the filter or not.

      Then I could colorcode the "not suffering" data points and this would be the solution

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi

         

         Yes. You can use the legend for colour. 

         

         you can write an IF condition and define a new column and use that in legend. In formatting pane, you can set red and grey as a colour.