When working with data that includes a date/time column, there are now more options for filtering the data. For example, showing SSL certificates that are expiring in the next 30 days, or showing Jira tickets closed in the last week.
You can now filter dates using three new operators:
  • is more than [x] [days/weeks/months] [ago/from now]
  • within last [x] [days/weeks/months]
  • within next [x] [days/weeks/months]
This now covers many more use cases and enables greater control over the data you're visualizing. If you've got additional cases that aren't covered by these new operators then drop us an email, or try SQL Analytics for complete control over your datasets.
image