

Partner - Creator
2017-02-06
03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count of products for the last 3 days i.e today, yesterday & a day before yesterday using set analysis ??
Hello Everyone,
I would like to find the "Count of Products" for the last 3 days i.e today, yesterday and a day before yesterday
using set analysis. It should be dynamic so that as the days change I can get the information of the current day
and the previous 2 days as well.
Thanks in advance.
Regards,
Kshitija Shinde
- Tags:
- set anlsyis
560 Views
2 Replies

MVP
2017-02-06
04:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=COUNT({<Date= {">=$(=Date(Today()-2))<=$(=Date(Today()))"}>}Products)
or
=COUNT(Distinct {<Date= {">=$(=Date(Today()-2))<=$(=Date(Today()))"}>}Products)
Change field names accordingly


Creator III
2017-02-06
04:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The below expression will give the expected ans.
COUNT(Distinct {<Date= {">=$(=Date(Max(Date)-2))<=$(=Date(Max(Date)))"}>} Products)
Date - Change the column as per your convenience.
469 Views
