Search

Use date fields in Dashboard cards

Easily organize the data captured by date fields into a specific time range to visualize trends in a Bar, Pie, Battery, or Line chart. You can select a Date Custom Field or task date fields like Date created and Due date.

Create a Dashboard to show how many articles each team published per month this year. Or quickly see the number of new hires in the past 90 days by week.

Card feature availability and limits vary by plan and user role. Learn more

Supported date fields and cards

Both date fields and date Custom Fields can be used on supported cards.

To use Date Custom Fields, you'll need a Date Custom Field in the selected Spaces, Folders, and Lists.

You can update your preferred date format for date Custom Fields in My Settings.

The following cards support using dates:

Card Fields that support dates Additional settings that apply to the date field

Bar Chart

 

X Axis: Measure
  • Time Range:
    • All available dates
    • This year
    • This month
    • This week
    • Rolling period
    • Range
  • Group by:
    • Days
    • Weeks
    • Months

Y Axis: Group by
  • Time Range:
    • All available dates
    • This year
    • This month
    • This week
    • Rolling period
    • Range
  • Step:
    • Days
    • Weeks
    • Months

Battery Chart

Data: Group by

 None

Pie Chart

Data: Group by
  • Time Range:
    • All available dates
    • This year
    • This month
    • This week
    • Rolling period
    • Range
Line Chart

X Axis: Measure
  • Time Range:
    • This year
    • This month
    • This week
    • Rolling period
    • Range
  • Group by:
    • Days
    • Weeks
    • Months

Y Axis: Group by
  • Time Range:
    • This year
    • This month
    • This week
    • Rolling period
    • Range
  • Step:
    • Days
    • Weeks
    • Months

Use a date field

To use a date field or date Custom Field:

  1. From a Dashboard, in the upper-left, click the toggle to enable Edit mode.
  2. Click the settings cog to edit card settings.
  3. Click a supported field.
  4. Click Dates to see the available date fields.
  5. Hover over a Date Custom Field's name to see how many locations contain the Custom Field.
  6. Click a date field.
  7. Set your time range and group by or step options.
  8. Your card will be instantly updated.

Show tasks by date created and date done

Let's sa you want to see when tasks are created and their date done to see how long they've taken.

Create a Bar Chart that measures the date created on the x-axis.

For the X-Axis, select Time Range of This month and Group by Days.

On the Y-Axis, measure the Number of Tasks.

Each column shows how many tasks were created each day this month.

Next, set the Y-Axis group by option to Date Done.

Each column now has a segment representing the date done for the tasks created each day.

Set the Y-Axis Step to Months so you can quickly see if tasks created early in the month were completed in the same calendar month.

Was this article helpful?