Values not getting displayed in textbox

[berryandcherry6]

Hi all,

I am trying to get  current_campaign_id  based on batch_meta_data_id  and current_start_date.But here i am not able to get anyvalues when i put this expression inside textbox.

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

even i tried on this

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

>} current_campaign_id, ', ')

but no luck

Please help me on this.

Thanks,

Supriya

[sunny_talwar]

Try this:

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

>} current_campaign_id, ', ')

[berryandcherry6]

Hi Sunny,

Putting this in set analysis expression,its giving me zero count .

i have modified expresion to  below to pass it to set analysis.()

campaignid = (=chr(39) & Concat(DISTINCT {<campaignid = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})

>} campaignid, chr(39)& ',' &chr(39) )& chr(39))

Whole Expression becomes

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

campaignid = $(=chr(39) & Concat(DISTINCT {<campaignid = p({<batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"}>})

>} campaignid, chr(39)& ',' &chr(39) )& chr(39))

>} course_completed)

[sunny_talwar]

Is 14 the number you are looking to get?

Try this:

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

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

[berryandcherry6]

HI,

No,this as to give count as 1.This result can be seen when we filter in table according to condition.

In count expression it gives count of whole campaign course completed count present in batches 23 and 24.Since count remains same with date condition and without it.

Regards

[sunny_talwar]

May be this:

Count(DISTINCT {$<DateType= {'completion'}, final_test_status={'passed'}, batch_meta_data_id = {23, 24}, current_start_date = {"$(=Date(WeekStart(Today()) + 1, 'MM-DD-YYYY'))"},

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

[berryandcherry6]

Hi,

I am not getting counts correctly.I have to get 13 as count. I think below equation is not fetching required campaign id,to get correct counts.

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

Please help me on this.

Regards,

Supriya

[sunny_talwar]

But in your previous post, you mentioned you wanted to get a 1? Now how did the count change to 13?

[berryandcherry6]

Hi,

That was wrong count as i was on assumption that count got based on filtered values in table should be the count.

13, This count is from server db,even if i put above equation in server it gives me same count as 1.

This below condition just have to fetch required campaign ids,to expression,may it is not fetching those id's

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

[sunny_talwar]

Based on the application attached it was giving us 4 campaignid (102, 103, 104 and 105). Do you see anything wrong with them? I mean should there be another one or is there one which should not have been there?

[berryandcherry6]

Hi,

No they are perfectly right,That logic working well to get campaign_id

But issue is in count.