Adding Trendline with value 99%

[amber2000]

Hello everbody,

I've been browsing through the questions about creating trendlines and find it difficult to implenment into my example.

Does someone have any idea on how I can add a trendline in the Bar_chart where the value should of the trendline is always 99% ?

If the data results drops below 99% it should be marked in red, if its 99% or higher it should be marked in green.

I've added a simple testfile so it's easyer to follow what I mean.

I hope anyone can help me please.

Kind regards,

Monique

[amber2000]

Hello Michael,

Can I ask one more thing please, I would like to add a trendline with the average total %.

I tried to put it in an expression but the line doesn't show at all.

Can you tell me what's wrong with it please?

This is the expression I'm using:

Avg(Sum(Absolute)/Sum(Gecontroleerde_Colli))

Monique

[Anonymous]

Monique,

You cannot use one aggregated function within another this way - you have sum() inside avg().  In situation like this, you must use aggr() function:
avg(aggr((Sum(Absolute)/Sum(Gecontroleerde_Colli)),<some fields here>))

I can't tell for sure what field(s) to use for aggregation in your case, it depends on what you want to see.  See "help" for advanced aggregation.

Regards,

Michael

PS: It is a rather different question.  I recommend to open a new discussion, so someone else can answer while I'm busy with my regular work

[amber2000]

Thank you for the response, I realy appreciate you trying to help me.

Kind regards,

Monique