3 Replies Latest reply on Aug 28, 2017 11:41 PM by Zhouyi Zhang

    How to create a custom Dimension/Measure based on Date comparison

    Rajeshwari Guddeti

      Hi Everyone,

       

      I have below data:

       

      CategoryOrder Date
      Test A4-Jun-17
      Test B4-Jul-17

       

      This is just one set of data.. I want to create a new dimension as below:

       

      CategoryOrder DateNew Dimension
      Test A4-Jun-17Executed
      Test B4-Jul-17Completed

       

      'New Dimension' should be created based on values in 'Category' and 'Order Date'..

       

      IF [Category]='Test A' and [Order Date]=Min([Order Date]) then 'Executed' END

       

      But when I create such calculation, it gives me error saying cannot mix aggregates and non-aggregates.

       

      I have tried using LoD's as well but of no use.

       

      Can any of you please suggest solution for this..

       

      Regards,

      Rajeshwari.