How many payments within 10 days, 20 days etc.

[bwisealiahmad]

Hi,

Trying to solve an issue here.

Company A has 3 different campaigns with different start dates. What I am trying to do is see how many payments came were received 10 days of sending out the campaign, 20 days etc from the starting date.

The idea is when you pick lets say Campaign X you can then see with bar charts how many payments were received within 10 days, within 20 days, and so on.

Any ideas? I've been thinking the class function.

[amayuresh]

I think this answer your question,

Output

Expression: Amount =sum({<Date={'>=$(=Date(aggr(Max(Date),Complain)-$(vDays)))'}>}Amount)