Average in Line Graph

[#1]

Hello. I'm trying to add a line to my combo chart which represents an average by period. Very simple data model. The bars represent total value for the period. The line should represent days_avail (a weighted average). The line only appears as a dot. Can someone take a look? I tried adding the set expression from the value expression to the days_avail expression, but that doesn't seem to work.

Period is single select. If I change it to multi select and select all the periods, the days_avail line appears fine.

[Anonymous]

Removing the aggr and adding set analysis like this :

=sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} value)

/ sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} total value)

* sum({<period={">=$(=Max(period)-1)<=$(=Max(period))"}>} days_avail)

Give you a line, but I not sure if it is what you actually are after.

[#3]

Thanks, but that doesn't work. The days_avail changes for a given period as different periods are selected...