Here's a simple trick to show the Most Recent Days using SET. Note that this will show a fix number of days only.


For this particular example, we will filter the data set based on the most recent days, ex. most recent 3 days.

set final.JPG


1. Create SET using the DATE field. Just right click the dimension DATE and select CREATE SET.

Sets 1.JPG

2. The Edit Set Box will show up.

     a. GENERAL Tab, select USE ALL

     b. CONDITION Tab, select NONE

     c. TOP tab, select the TOP 3 based on MAXIMUM DATE (as shown below). Name the set as Recent 3 Days then click Apply.



3. Lastly, use the newly create SET as filter. Drag to Filters box.


sets final 2.JPG