3 Replies Latest reply: Jul 2, 2015 10:40 AM by Ramon Covarrubias RSS

    Comparative analysis with Alternate States

      Hi everybody. It's the first time i wrote here.

      I read many discussions but i didn't find the solutions.

       

      I have this problem.

       

      I have two different states (A and B) with selected years (2014, 2015).

      The expressions to calculate active customers of a selected shop (nomeNegozio) in different years (2014 and 2015) are:

       

      Count ({statoA<KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

      Count ({statoB<KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

       

      Now i would like to calculate customers that were active in 2014 but not in 2015. I tried many expressions but nothingI

       

      Count({statoB-statoA <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

       

      or

       

      Count({statoA <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>-statoB <KidTipoMov={2},TipoMovimento={INTERNI}, nomeNegozio=$::nomeNegozio>} DISTINCT KidCustomer)

       

       

      Anyone could help me please?

       

      Thank you

      R.