Display every value of a field in a combo chart

[#1]

Hi everybody,

i have the following situation:

I am using a combo chart with the dimension age and an expression avg(salary). The result is a chart that displays for every value of the field age an average salary (as seen below).

But my goal is to display every value of the field salary as a point in the combo chart combined with a polynomial of 2nd degree. I have tried different and/or several expressions but none of that was of success.

Can you help me?

Kind regards,

Markus

[#2 · Accepted solution]

Hi Markus

Maybe use a scatter chart  with

dimension :   yourIdfield

expression 1 :   sum( Age)

expression 2  :  Avg(Salary)

Then create a trendline with 2nd degree polynom

JJ

[#3]

Hi JJ

Thanks, it works that way!

Markus