6 Replies Latest reply: Mar 20, 2018 9:05 AM by Supriya R RSS

    Aggr records of first record in the selection

    Supriya R

      Hi,


      I have a requirement where when user selects batches in filterpane, based on batch selected, only first campiagn(i.e min campaign ID) of selected batch's count of invitation have to be displayed


      For this i have used below set analysis:

      Count({$<DateTimeType = {'open_time'},campaign_id={"$(=min(campaign_id))"},opened = {'1'},client_id = {'12'},batch_id={'2','3','6'}>}distinct invitation_id)


      But this is taking first campaign(i.e min campaign ID) of client and giving count of that campaign regardless of batch selection.


      I want count of invitation of first campaign of the batch selected. How could i do this?