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

    aggr by customer not efficient - suggestion for expression?

    Kristof Jacobs

      Hi   

       

      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.