Skip to Content
0
Dec 20, 2018 at 10:10 PM

Fetch min date irrespective of the report date range in Webi

89 Views Last edit Dec 21, 2018 at 04:59 PM 3 rev

I am trying to fetch min date in my report in webi.The report is build from 01/01/2018 till 10/31/2018 for two different promos. But these promos began and ended beyond report start and end dates ie 01/01/2018 till 10/31/2018.

I have tried different functions but nothing has worked.

<code>="Promo # "+[Promo Number]+": "+Min([Date]) In([Promo Number])+" - 
"+Max([Date]) In([Promo Number])
//what should i edit here

Min date gets defaulted to report start date 01/01/2018 and max date to 10/31/2018.

But in actual min date is 03/05/2016 and max date is 11/30/2018.

Actual Result:

Promo # 183: 1/1/2018 - 4/14/2018(end date is correct since its in the report date range)

Promo # 200: 5/1/2018(start date is correct since its in the report date range) - 10/31/2018

Expected Result:

Promo # 183: 03/05/2016 - 4/14/2018

Promo # 200: 5/1/2018 - 11/30/2018

Report dates should not affect the start and end date for promos

Attachments

question.jpg (63.1 kB)