Skip to main content

Intro

Date Selector Cards display a calendar-style range of dates. When you add them to a Domo dashboard, dashboard viewers can select a range of dates from the calendar as a filter. Alternatively, they can choose from several preset date filters such as Last year and Last 2 months. The date filter you choose is applied to all other cards on the dashboard. Date Selector Cards have a 25,000-row limit. For example, if you select all dates from April 1st – July 31st on the calendar, all other cards on the dashboard are filtered to show just the data for these dates.
date_selector.gif

Date Selector Cards are a type of Filter Cards. Learn about the other Filter Card types:

Power Date Selector Cards

In Analyzer, creating a Date Selector Card requires two columns or rows of data from your DataSet. One is a date column. Drag a date column to the Date field above the chart. The other required column/row belongs in the Group By field. Though this field is required to power the card, it doesn’t necessarily matter what column/row you place here. If you need to aggregate the data, you can use this field to do so. For example, if the date column is duplicated in your DataSet, you can make the dates unique by aggregating.
Calendar.png
Learn more about choosing data columns in Applying DataSet Columns to Your Chart. Learn how to format charts in Analyzer in our Analyzer documentation.

Customize Date Selector Cards

You can customize the appearance of a Date Selector Card by editing its chart properties. Learn about all available Chart Properties. This table details the unique properties of Date Selector Cards:

Property

Description

Example

General > Selected Color

Lets you change the highlight color used when you select a range of calendar dates in the card.

date_selector_selection_color.png

Calendar view > Highlight today

When checked, a box appears around today’s date in the calendar. In the example at right, the date of “July 25” is highlighted.

date_selector_highlighted_today.png

Calendar view > View

Determines the calendar view that is used. The following options are available:

  • Auto (Default) — The view is determined automatically based on your data. For example, if you had at least a year’s worth of data in your date column, a yearly view would be used.

  • Last Year Rolling — The calendar shows dates from a year ago up until the current month. This is the option shown in the example at right.

  • Next Year Rolling — The calendar shows dates from the current month up until a year from now.

  • Year The current year is shown.

  • Month — The current month is shown.

date_selector_rolling_year.png

Calendar view > Dates from

Specifies whether the dates that appear in the calendar are based on the current date, are automatically determined based on your data, or are user-specified (in which case, you will enter the date parameters in the Year , Selected Year , and Month fields.

Calendar view > Year

Determines whether the year shown in the calendar is the current year, the previous year, or the next year. You can also specify a year by selecting Specified and entering the desired year in the Selected Year field. This option is only available when Dates From is set to User Specified .

Calendar view > Selected year

Lets you enter a specific year to be shown in the calendar. This option is only available when Dates From is set to User Specified and Year is set to Specified .

Calendar view > Month

Lets you enter a specific month to be shown in the calendar. This option is only available when Dates From is set to User Specified and View is set to Month .

Calendar view > First day of week

Lets you select the first day of the week to be shown in your calendar. In the example at right, the first day of the week is Monday.

date_selector_first_day_of_week.png

Calendar view > First month displayed

Lets you select the first month of the year to be shown in your calendar. This option is only available when Year is selected in the View menu.