Using fixed dates, date picker, mode

In CDP Data Visualization, the fixed date mode in a date filter enables you to select a subset range of dates for visualization.

Follow these steps to a date picker in a calendar heat map visual built on the SFPD Incidents dataset. For more information on this visual type, see Calendar heat maps.

  1. Open SFPD Incidents - Calendar Heat Map, created according to the instructions in Calendar heat maps.
  2. Under Dimensions, select date, drag it to the Filters shelf of the visual and drop it to add it to the shelf.
  3. To start a new dashboard, click New Dashboard.
  4. In the Visual Designer, in the left menu area, click the Shared Visuals tab.
  5. Ensure that you are using the SFPD Incidents dataset, and click the SFPD Incidents - Calendar Heat Map visual.

    The visual appears in the main area of the interface.

  6. In the menu area, click the Filters tab.
  7. Under the Dimensions category, click the date field.

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

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

    To see the date picker interface, on the filter, click the Calendar icon, and select the Fixed Dates option from the menu.

  9. Optional: You can also click the date dashboard filter to see the date picker interface.
  10. Optional: 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
  11. 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 that the application filter shows this new date range.

  12. Name and save the application.
    In nthis example, the name SFPD Incidents Date Picker has been used.