cancel
Showing results for 
Search instead for 
Did you mean: 

Fetch min date irrespective of the report date range in Webi

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

Report behavior is correct as per your date range condition.you need to increase the date range values in prompt to get the data from 2016.

Former Member
0 Kudos

Yeah that's what I assumed but the as per the requirement. The start date for promo 183 and end date for promo 200 should not get affected even if the report is fetched for a certain range. Like promo 183 began some time in 2016 so it should always give a start date from 2016 irrespective of report range. Is it something than can be workaround for this situation?