How to display calculated indicator in number of days order rather than calendar date

There are cases that you want you chart x-axis to display the number of days for a particular event, rather than the calendar date. For example, if you are running a marketing campaign from 2013-08-01 to 2013-10-01, you want to display 2013-08-01 to be "Day 01", 2012-08-02 to be "Day 02", and 2013-10-01 to be "Day 62" and so on.

This use case is going to show you how you could make it if you only have the date in your data set.

• Create a new attribute called "campaign_day" in the data set, write the transformation script as below:

int days= daysBetween(rowDate(), date('2013-08-01')) + 1;

String campaign_days = days.toString();

if(length(campaign_days) == 1) {
  return '0' + campaign_days;
}else {
  return campaign_days;
}

This will return you the number of days in terms of the campaign starting time in the format of 00 to 62.

• At the report level, set the "campaign_day" as the drill down and calculate the indicator as below:

dateInterval('2013-08-01', '2013-08-01' + ' + ' + memberValue() + 'd') { 
  crossValue('ALL_SMS_2_JOINED.ALL_SMS_2_JOINED', 'L_MSISDN_DCOUNT') 
}