0 Replies Latest reply: Oct 15, 2012 9:35 PM by Jonathan Morales RSS

    Alternate States (drill down versus cyclic)

    Jonathan Morales

      I have a chart that compares sales from one period to another period.

       

      The overall app is in the default state. This means that the dimension is in the default state.

      one period is in [Alternate State 1]

      the other period is [Alternate State 2]

       

      I have separate date selectors for each state.

       

      This works perfectly when using a drill down but does NOT work when I use a cyclic.

       

      I have one dimension (with cyclic) and  one expression.  The calculation for the expression is as follows

       

      COUNT({[Alternate State 2]<[Call Type] = {'Inbound'}>} DISTINCT [SalesID])
      -
      COUNT({[Alternate State 1]<[Call Type] = {'Inbound'}>} DISTINCT [SalesID])


       

      example.jpg

       

      Any Ideas?