Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have created a trellis chart with two dimensions:
1: quarteryear
2: client
I have expression avg(perfomance)
so each quarter is now a chart which shows the performance per client in bar-charts.
But now I would like to add the average performance per client independent of quarter over all the quarter charts as a line. The line should only respond to the second dimension (client) and not the firsl dimension (quarteryear).
So it should be the same line over all charts.
is this possible?
avg({1} performance) or avg(total(performance)) does not work.
your help would be much appreciated
regards
Peter
Try:
avg(total <client> performance)