UPDATE: I added sample:
load script loads excel file with date / value 1
this is shown in first chart: together with internal average line.
and i need to know this average value to use it in a second chart:
e.g. this second chart uses other values but those values need to be coloured if they are higher or lower than the average value of the first diagram ?
My question is: can we get this value within module scripts ?
how can I use a chart average (trend line) value in another diagramme ?
is there any possibility to read this average value (trend line) within a macro ? like Chart.properties and then the average value ?
I could not find any solution.
Thanks for your help.
Is this what you are looking for?
Where the avg line is created using this expression:
Avg(TOTAL Aggr(Sum([Messwert 1]), Datum))
and background color using this:
If(Column(1) > Column(2), LightGreen(), LightRed())
Where Column(1) is your expression for the bar [Messwert 2] and Column(2) is the Avg expression from above (Avg(TOTAL Aggr(Sum([Messwert 1]), Datum)))
thanks for your help.
however I have still one question about conditional coloring of the chart rows:
I know tha in diemnsion or expression I can use background coloring in an if expression.
BUT: I have 5 rows in a chart.
each row-value has to be compared to the value of a related variable.
so: field1 (of row1) compared to variable1, field2 (of row2) compared to variable2 ....
how is this possible:
with the expression RowNo and building nested if clauses ?
or which are the options,