Show count of order for last 30 days

[beskqlik]

Hi 

i am trying to get count of orders for last 30 days. When  using belwo expression, i am getting zero.DATA_DATE , formatting is also taken care of the expression.

Count({$<DATA_DATE={">=$(=Date(max(DATA_DATE)-30, 'DD-MMM-YY'))"}>}order)

[sunny_talwar]

So, does your expression work when you hard-code the value? >=25-Feb-19?

[beskqlik]

I changed my expression as below and it worked. Thanks for your reply

COUNT({<DATA_DATE={">=$(=DATE(Max(DATA_DATE),'DD-MMM-YY')-30)"}>} Order)

[naveen409 · Accepted solution]

Hi 

1) Create a variable: -

VMax= Date(max(Date_Field)-30,'DD-MM-YYYY')

where you will roll back to a month.

2) Try This:

=Count({$<DATA_Field={"$(=VMax)"}>}order).

But Tell me how is your date format. So That we can help

Thanks 

Naveen

[beskqlik]

THanks, it worked.

My date format is 'DD-MMM-YY'

BUt i have one request. By default report is showing 30 days data. But when i select one date at filter, report is bringing only that one dates data, but i need 30 days data previous to the selected date.

[naveen409]

Try with

GetFieldSelections(),

Thanks and Regards,

Naveen

[beskqlik]

GetFieldSelections(AVG({<DATA_DATE1={">=$(=DATE(Max(DATA_DATE1),'DD-MMM-YY')-30)"}>} order))

It was giving - data

[naveen409]

You got the solution.

Regards,

Naveen

[beskqlik]

no, when i am using getfieldselection, i am getting no data as '-'

[naveen409]

So tell me you have date field as a filter.