Use Date fields in Dashboard cards

Easily organize the data captured by Date Custom Fields into a specific time range to visualize trends in a Bar, Pie, or Battery chart.

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.

You can also organize the data captured by task dates like Date created and Due date. 

What you'll need

  • 100 uses of Dashboards are available on the Free Forever Plan. Uses include the following actions:
    • Create a Dashboard
    • View a Dashboard
    • Add a card
    • Edit a card
    • Remove a card
    • Remove a Dashboard
  • Unlimited uses of Dashboards are available on the Unlimited Plan and above.
  • Some cards are only available on the Business Plan and above (which ones?).
  • The Dashboards ClickApp is enabled in every new Workspace by default, but a Workspace owner or admin may disable the ClickApp.
  • Guests can be invited to specific Dashboards with view-only permissions.
  • Certain cards can be exported on the Business Plan and above.
  • Reporting and Time Tracking cards are only available for the Unlimited Plan and above.
  • Dashboards Hub is only available on ClickUp 3.0.

Create a Date Custom Field

To use this feature, you'll need a Date Custom Field in the locations containing the data you're reporting on.

Custom Fields are a ClickApp that must be enabled by an owner or admin. A Date Custom Field uses a custom date and time that's formatted the same way as other dates in ClickUp.

To create a Date Custom Field:

  1. Create a Custom Field from the Space, Folder, or List. Or create a Custom Field with Custom Field Manager.
  2. From the modal, select Date.   
  3. Customize the field.
    • To make sure that the necessary data is recorded, you can require this Custom Field.
  4. Click Create.

Use Date Custom Fields in a Dashboard card

To report on Date fields in a Dashboard card, create or use an existing Date Custom Field.

  1. Create or edit an existing Bar, Pie, or Battery card.
  2. Select the locations containing the data you're reporting on.
  3. Select your Custom Field. 
    • Bar card: From the X Axis dropdown select Dates then your Date Custom Field.Screenshot showing a Bar chart card. Dates is being selected for the X Axis and two Date Custom Fields are shown.
    • Pie and Battery cards: The Group by option is the x-axis for these cards. From the Group by dropdown select Dates then your Date Custom Field.
  4. Under Time range, click the first dropdown to set one of the following time ranges:
    • This yearThis month, or This week: Select a time range of this year, month, or week.
    • Choose rolling period: Select a relative time range between 1 and 365 days. The card will automatically continue to report on that same range of time.
    • Range: Select a custom range of dates.
      Screenshot of a Bar chart card showing the options described above.
  5. Under Time range, click the second dropdown to choose to view y-axis data by day, week, or month for the time range selected in the first dropdown. 
  6. Select any optional settings or filters.
    • Bar chart cards also have the option to show dates that have no data.
      For example, your Dashboard shows the number of new hires in the past 90 days by week. There were no hires in the last week of December. If you don't want to see this week in the Dashboard, you can deselect Show empty dates

  7. Click Add card.  

Updated

Was this article helpful?