27 Replies Latest reply: Jul 16, 2014 8:23 AM by Kristof Jacobs RSS

    aggr by customer not efficient - suggestion for expression?

    Kristof Jacobs



      In my model I have customers who used several kinds of transportation each month.

      I want to have a expression that can give me how many customers used a combination of transportation.

      I should also be able to select a few months and that the expressions keeps these months in account.


      It works with an aggregation by customer but when I use the expression on 4 million customers it takes hours to calculate.


      Any suggestion for an expression or another model?


      In the qvw I made 2 models.

      I used the model where each transportation is in a different column.

      The other model would be better because there I have more details like the color.