
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show count of order for last 30 days
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)
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, does your expression work when you hard-code the value? >=25-Feb-19?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with
GetFieldSelections(),
Thanks and Regards,
Naveen

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
GetFieldSelections(AVG({<DATA_DATE1={">=$(=DATE(Max(DATA_DATE1),'DD-MMM-YY')-30)"}>} order))
It was giving - data

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You got the solution.
Regards,
Naveen

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
no, when i am using getfieldselection, i am getting no data as '-'

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So tell me you have date field as a filter.

- « Previous Replies
-
- 1
- 2
- Next Replies »