3 Replies Latest reply: Oct 26, 2011 1:18 PM by Tjeerd Wieberdink RSS

    Aggregation with variable Periods

    Bastian Trompetter

      Hello,

      I have the following diagramm

      error loading image

      It shows the average gross sales depending on the selected period. The period could be day, week and month. I can create three diagramms for every period. But I don't like it. So is it possible to make an aggr function wich use a variable for the period?

      Something like this:

      aggr( sum(Sales / count(AD_ID_COUNT)), Year, $(=vPeriod) )

      but this didn't work.

      Do you have any solution for this problem?

      Thanks for help.

      regards

      Bastian