Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am using FirstSortedValue in Bar Chart, to get data for latest expired campaign for batch
I am confused using it in Bar chart,
If latest expired campaign exist for batch it shows data otherwise it shows nothing. i need it to show 0 value if no latest expired campaign exists(i.e if no data exists)
$(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}
Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), -Aggr(campaign_end_date, campaign_end_date)))
I tried using alt, but it is not working
alt(($(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}
Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), -Aggr(campaign_end_date, campaign_end_date)))),0)
Hi,
maybe so
$(=FirstSortedValue({$<batch_meta_data_id={'53'}, campaign_end_date = {"$(='<' & Date(Today(),'MM-DD-YYYY'))"}>}
Aggr(Sum({$<batch_meta_data_id={'53'}>}sign_up), campaign_end_date), Rank(-Aggr(campaign_end_date, campaign_end_date), 1)))
Regards,
Andrey