Getting counts of dynamic values

[berryandcherry6]

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

[berryandcherry6]

Hi,

Is there anything i could make it to work

Thanks,

Supriya

[CELAMBARASAN]

If you have the correct date format it should work, Without seeing the application I cannot comment on that.

May be the below expression works

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

campaign_id = p({<batch_meta_data_id = {23, 24}, current_start_date = {"=current_start_date=Date(WeekStart(Today()) + 1,'MM-DD-YYYY')"}>} campaign_id)

>} invitation_id)