I have set up a bar chart and I am trying to get it to graph the data for the maximum date available in each month (this is not always the last date of the month).
My dimension is (aggr(max(perioddate),month_var)) where month_var is a variable displaying the month of the perioddate variable.
My expression is sum({ $<perioddate= {'=aggr(max(perioddate),month_var)'}>} actual) where actual is the name of the variable I want to display in the bars.
Currently this is actually graphing the data value that corresponds to the minimum date each month but labelling it as the maximum date.
