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.
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.
dateInterval('2013-08-01', '2013-08-01' + ' + ' + memberValue() + 'd') { crossValue('ALL_SMS_2_JOINED.ALL_SMS_2_JOINED', 'L_MSISDN_DCOUNT') } |
It is recommended that you get familiar with + Datetime Functions +. |
Remember that Cross Reference does not take drill down into consideration, so you are able to calculate the cumulated value. Here is how you use cross reference magically! |