Using fixed dates (date range picker) mode

In Cloudera Data Visualization, the fixed dates mode in a date filter enables you to select a subset range of dates for visualizing your data.

These steps show you how to use the date range picker option of a date and time filter. The instructions use a calendar heatmap visual as an example.

  • You have created a calendar heat map visual using the SFPD Incidents dataset. For more information on this visual type, see Calendar heat maps.
  • You have added this visual to a dashboard.
  1. Open your dashboard that contains the heatmap visual in Edit mode.
  2. Switch to the Filters tab on the Dashboard Designer side menu bar.
  3. Under Dimensions, click the date field.

    This adds a filter to the dashboard. This filter is based directly on the date field and has a timestamp type.

    The dashboard filter contains the date range for the entire dataset; in this case, it is from 2003-01-01 through 2014-12-31.

  4. To use the date range picker interface, click the Calendar icon on the filter, and select Fixed Dates from the menu.

    You can also click the date field of the dashboard filter to see the date range picker interface.

    You can change the date range in various ways:

    • By selecting the default options:
      • Today
      • Yesterday
      • Last 7 Days
      • Last Week
      • Last 30 Days
      • This Month
      • Last Month
    • By changing the date entries for FROM and TO fields
    • By picking the start and end dates directly on the calendar interface
  5. Change the date range to 2010-01-01 through 2010-12-31, and click APPLY.

The visual output is now limited to the 2010 calendar year and the application filter shows this new date range.