How to Filter Data for Last N Days, Weeks, Months, or Years

There are many ways you can filter the data based on date and time information. One of the common requirements is something like filtering the data for the last 30 days, the last 4 weeks, etc.

Here is how.

Sample Data

We’ll use the 2016 US Election TV Advertisement Campaign data, which was originally hosted at Political Ad Archive and I have cleaned up and shared it here. You can download it as either CSV or EDF (Exploratory Data Format) and import it into Exploratory.

Filtering Data for the Last 8 Weeks (Days, Months, Years)

Let’s say we are interested in the data for the last 8 weeks.

You can select ‘Filter’ -> ‘later than or equal to’ -> ‘Weeks Ago’ from the column header menu.

And type 8 for the Value.