0 Replies Latest reply: Nov 21, 2011 11:44 AM by n7575193 RSS

    Display data for maximum date per month

      Hi,

       

      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.

       

      Can anyone help me fix this?

       

      Thanks