5 Replies Latest reply: Oct 19, 2016 5:59 AM by Supriya R RSS

    Load inline using variables

    Supriya R

      HI,

       

      MetricsDims:

      LOAD * INLINE [

            Metrics  , value

          Invitations1 , $('Count({$<DateType={''signed''},user_signed={1}, client_name = {''Repair.com''},CanonicalDate = {<=$'&'(=WeekEnd(today(),-1))"}>}invitation_id)')

          Invitations2 , $(=vInvitation_count)

          Invitations3 , $(vInvitation_count)

      Invitations4 , =$(vInvitation_count)

      ];

       

      where let vInvitation_count = 'Count({$<DateType={''signed''},user_signed={1}, client_name = {''Repair.com''},

      CanonicalDate = {"<=$' &'(=WeekEnd(today(),-1))"}>}invitation_id)';

       

      None of them display value. How should i achieve this?

       

      Note : Equations in column two differs