21 Replies Latest reply: May 20, 2016 4:09 AM by Celambarasan Adhimulam RSS

    Getting counts of dynamic values

    Supriya R

      Hi all,

       

      i am trying to get current_campaign_id by putting  where condition to CurrentCampaignData.and then passing current_campaign_id  to set analysis.

       

      CurrentCampaignData:

      Load

      batch_meta_data_id,

      campaignid as current_campaign_id

      Resident CAMPAIGN

      WHERE ( current_start_date = Date( weekstart (Num ( today() ) )+1)) and match(batch_meta_data_id ,'23','24');

       

      count({$<DateType= {'completion'},final_test_status={'passed'},campaign_id = P(current_campaign_id)>} course_completed)


      This works fine, but  i want to put this same logic in expression instead of loading in script .How could i do this.?

       

      Please help me in this regard.


      Thanks