17 Replies Latest reply: May 19, 2016 4:58 AM by Kumar Pramod RSS

    Passing dynamic values to set analysis

    Kumar Pramod

      Hi all,

       

      I have table where campaign_id is a field which has many values, each week campaigns are created on client and batch specific.

       

      For ex: batch_id = 1 has 4 campaigns and batch_id = 2 has 3 campaigns every week.

       

      I need sum of user completed on batch specific. for ex:

       

      Sum({$<batch_id = {'1'}, campaign_id = {"Need to pass dynamic values to here depending on week"}>}user_completed)

       

      If i want current week campaigns i need to pass the current week campaigns, If last week i need to pass last week campaigns.

       

      campaign_start_date    batch_id      campaign_id

           05-17-2016                 1                  400

          05-17-2016                 1                  401

          05-17-2016                 1                  402

          05-17-2016                 1                  403

       

       

      Now i need to include these 4 campaign_id's to above set analysis how can i achieve this.

       

      Regards,

      Pramod

       

      Message was edited by: Kumar Pramod