Creating Filters Using Date Questions

From Q
Jump to navigation Jump to search

When creating filters, date questions have options that allow you to specify both fixed date periods (e.g., 1st of July 2014 to 31st of July 2014), and relative time periods (e.g., last 6 months, as illustrated below).

When using relative time periods, Q first aggregates the data and then computes the filter. For example, if your most recent data is from the 1st of September, and you create a filter for three months, it will take the data from July, August, and September, even though that data only contains two months and one day. An alternative, if wanting to specify the last three months, is to instead specify the lat 90 days. Or, you can write some JavaScript.