30/60/90 day forecast chart expressions

[dawgfather]

I am trying to create a chart that will give me the counts of things that are within the next 30/60/90 days.

I have different Order types so my dimension would be OrderType and then I would need a couple Expressions that in layman's terms would look like or do the following:

30 days = COUNT(Order where DeliveryDate is between Today and Today+30  )
60 days = COUNT(Order where DeliveryDate is between Today+31 and Today+60 )
90 days = COUNT(Order where DeliveryDate is between Today+61 and Today+90 )

What I am hoping to get is a chart like the below (Given that "today" is 4/15/2016):

OrderType    30    60    90
Retail            22    11     2
Wholesale .....

Direct       ......

based on the data below - (only Retail provided here)

OrderType Order DeliveryDate
Retail Order1 04/15/2016
Retail Order2 04/16/2016
Retail Order3 04/17/2016
Retail Order4 04/21/2016
Retail Order5 04/22/2016
Retail Order6 04/23/2016
Retail Order7 04/24/2016
Retail Order8 04/25/2016
Retail Order9 04/26/2016
Retail Order10 04/27/2016
Retail Order11 04/28/2016
Retail Order12 04/30/2016
Retail Order13 05/01/2016
Retail Order14 05/02/2016
Retail Order15 05/03/2016
Retail Order16 05/04/2016
Retail Order17 05/05/2016
Retail Order18 05/06/2016
Retail Order19 05/07/2016
Retail Order20 05/09/2016
Retail Order21 05/11/2016
Retail Order22 05/14/2016
Retail Order23 05/15/2016
Retail Order24 05/18/2016
Retail Order25 05/20/2016
Retail Order26 05/21/2016
Retail Order27 05/22/2016
Retail Order28 05/24/2016
Retail Order29 05/28/2016
Retail Order30 06/02/2016
Retail Order31 06/03/2016
Retail Order32 06/04/2016
Retail Order33 06/11/2016
Retail Order34 06/16/2016
Retail Order35 06/17/2016

I am not sure how to calculate or do the expressions. I have tried a few things and not been successful with the "between" type calculations.

Can anyone help?

[sunny_talwar · Accepted solution]

May be this:

=Count({<DeliveryDate = {"$(='>=' & Date(Today() + 0 , 'MM/DD/YYYY') & '<=' & Date(Today() + 30, 'MM/DD/YYYY'))"}>}Order)

=Count({<DeliveryDate = {"$(='>=' & Date(Today() + 31, 'MM/DD/YYYY') & '<=' & Date(Today() + 60, 'MM/DD/YYYY'))"}>}Order)

=Count({<DeliveryDate = {"$(='>=' & Date(Today() + 61, 'MM/DD/YYYY') & '<=' & Date(Today() + 90, 'MM/DD/YYYY'))"}>}Order)