2 Replies Latest reply: Oct 8, 2011 9:41 AM by Michael Solomovich RSS

    Set Analysis in Date Dimension

      Is it possible to put a set modifier in a date dimension?

       

      i.e. date({$<Step={4}>} Date, 'MM-DD-YY')

       

      An order can go through many steps, but i want all of the order's information to report on the date that step 4 occurs.

       

      My problem occurs when I'm doing a stacked graph comparing the data of each step, so data that occurs on step 5 reports on the date of step 5, not step 4.

       

      Please help!