1 Reply Latest reply: Apr 12, 2017 9:53 AM by Sunny Talwar RSS

    Set analysis with if (Bucketing)

    Dhirander Kumar Srivastava

      Hi,

      I am creating a chart with calculated dimension and using the following formula. I have a field "RuleNo" Which have values i.e 1,2,3...

      I want to filter for RuleNo 1 and create bucket.

      =({<RuleNo={1}>} if(C_DIFFDAYS_PO_VS_PR_Date<0, 'PR Date < PO Date', if(C_DIFFDAYS_PO_VS_PR_Date>0,'PR Date > PO Date','PR Date = PO Date')))

       

      It's not working. How can I achieve this?

        • Re: Set analysis with if (Bucketing)
          Sunny Talwar

          Leave your calculated dimension as is, but apply set analysis to the expression

          =if(C_DIFFDAYS_PO_VS_PR_Date<0, 'PR Date < PO Date',

          if(C_DIFFDAYS_PO_VS_PR_Date>0,'PR Date > PO Date','PR Date = PO Date')))

           

          Sum({<RuleNo={1}>}Measure)

           

          Or use if statement

          =If(RuleNo = 1,

               if(C_DIFFDAYS_PO_VS_PR_Date<0, 'PR Date < PO Date',

               if(C_DIFFDAYS_PO_VS_PR_Date>0,'PR Date > PO Date','PR Date = PO Date'))))