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.
Kranredundanzen_v10.2.twbx 38.4 KB
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".
Updated my post with the link, see if it helps.
Sorry Armin, I've spent quite a bit of time to come up with a logic. I will leave this to someone else.
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.