Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you for the response, I realy appreciate you trying to help me.
Kind regards,
Monique