5 Replies Latest reply on Apr 18, 2018 10:26 AM by Amit Naik

    Convert to Dimension not available

    Amit Naik

      I want Count distinct of Customers by ASR but the issue is I am not able to convert ASR Grouping into Dimension.

       

      I have a calculation

      Avg Subscriber Revenue

      sum(if [ORDERSTATUS] = "Shipped" AND [SHIPMENTNUMBER] > 0 AND [TRANSACTION_TYPE] = 'ORDER'
      then [ORDER_AMOUNT]
      else 0
      END)
      /
      COUNTD(if [ORDERSTATUS] = "Shipped" AND [SHIPMENTNUMBER] > 0 AND [TRANSACTION_TYPE] = 'ORDER'
      then [CUSTOMERNUMBER]
      else 0
      END)

       

      ASR Grouping

      if [Avg Subscriber Revenue] > 278

      then '> 278'

      elseif [Avg Subscriber Revenue] >= 167 AND [Avg Subscriber Revenue] <= 278

      then '167 - 278'

      ELSEIF [Avg Subscriber Revenue] < 167

      then '< 167'

      else 'N/A'

      END

       

      Hence total Customers for 167-278 = 398

       

       

      But after going Distinct Count of Customer Number it vanishes because the grain is at higher level

       

      The LOD is having issue