10 Replies Latest reply: Aug 12, 2016 8:22 AM by Supriya R RSS

    Set Analysis Expression issue

    Supriya R

      Hi,

       

      I have a Expression

       

      Count({$<DateType={completion},final_test_status={"passed"},

      YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}invitation_id)

       

      For this i am adding to filter it by  Canonical_Month={'Month_Last_Canon_Year'} .

       

      Canonical_Month    Month_Last_Canon_Year

             Jan                                 May

             Feb                                 June  

            MAr                                  July

             Apr                                  Aug

            MAy

            June

             July

             Aug

              Sep

              Oct

              Nov

              Dec

       

      So my expression becomes 

      Count({$<DateType={completion},final_test_status={"passed"},

      YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"},Canonical_Month={'Month_Last_Canon_Year'}>}invitation_id)

       

      But  this Canonical_Month={'Month_Last_Canon_Year'}  is not getting applied. Count gives Zero.

       

      Please help me on this.