8 Replies Latest reply on Oct 11, 2018 10:09 PM by Armin Rauscher

# Coloring scatter plot based on parameters

Hello,

I am now trying since hours how I could colour my scatter plot based on a parameter.

I have created a parameter which is called "Investsumme" and I have a calculated field called "Abstand" which has calculated the distance of each scatter from the zero point.

Now i would find the scatters which have the highest distance but only as long till the sum of the costs (Detail information for each scatters) this scatters is closest but below the parameter.

Has someone an idea how to do?

Thanks, Armin

• ###### 1. Re: Coloring scatter plot based on parameters

Armin- If I understand your question correctly, the colors of the data points should change as they fall above or below the line correct?

If so, you'll have to condition the parameter using a calc. Something like this,

And place this calc in color,

Here's the approach - Color Scatter Plot

Is this how you want? Or let us know if this didn't help.

Thanks,

Shiva.

• ###### 2. Re: Coloring scatter plot based on parameters

Hello,

No thats not correct.

The two parameters "Gefahr50" and "Einsatz50" are only for the horizontal and vertical line within the scatter plot.

I want to color these points red which there calculated field "Abstand" is the highest but only as long as the sum(Kosten) for these scatters is below the parameter "Investsumme".

Thanks.

• ###### 3. Re: Coloring scatter plot based on parameters

Updated my post with the link, see if it helps.

• ###### 4. Re: Coloring scatter plot based on parameters

Hello,

This link i allready know but it will not help me in my case.

Take an example.

The parameter "investsumme"=40.000 then i would like to color the marked 8 points in the screenshot because the measure "Abstand" are the Top N and the especially the sum(Kosten) is exactly the parameter value.

• ###### 5. Re: Coloring scatter plot based on parameters

Sorry Armin, I've spent quite a bit of time to come up with a logic. I will leave this to someone else.

• ###### 6. Re: Coloring scatter plot based on parameters

TTT

• ###### 7. Re: Coloring scatter plot based on parameters

Not exactly sure but does this help?

Thanks,

Shin

• ###### 8. Re: Coloring scatter plot based on parameters

Hello,

Sorry no, this would also not help me.

I try it again to explain it how i would think i would do it manually:

1. Calculate the value "Abstand" which is already done

2. rank the calculated field "Abstand" descending from highest to lowest

3. based on this rank take as much scatter point till sum(Kosten) is still below or equal parameter "Investstumme"

this means if i choose Investsumme = 12000 then the scatters with Abstand 117,4564 must be marked because the sum(Kosten) of this 2 is 10000 and below investsumme. If i would take also the scatter with Abstand 116,000 then sum(Kosten) is 15000 and above the parameter Investstumme

if investstumme=31000 then the scatter with Abstand 117,4564 (2 points) with 116,000 (2points) and 114,56 (2 points) must be marked because sum(Kosten) is 30000 and the next point will be above 31000.