Explore recipe: Displaying the current date in your dashboard

What's my plan?

With thanks to Philippa Booth​

This report provides a quick way to display the current date on your dashboard.

What you'll need

Skill level: Easy

Time required: 20 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)
• Ticket and agent data in Zendesk Support

How to create the report in Explore

Use the following steps to create this report in Explore.

1. In Zendesk Explore, click the reports ( ) icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
4. Next, add a metric, the thing you want to measure, in this case, the number of tickets. In the Metrics panel, click Add.
5. From the list of metrics, choose Tickets > Tickets, then click Apply. Notice that COUNT(Tickets) is displayed in the Metrics panel and Explore automatically displays the count of tickets in the main section of the page.

   

6. Next, add a custom attribute that displays the current date. In the Calculations ( ) menu, choose Standard calculated attribute. 
7. On the Standard calculated attribute panel, add the following formula:
   

   DATE_FORMAT(TODAY(),"DD-MM-YYYY")

8. Add a title for your new attribute. In this example, the attribute was named Today.
9. When you are finished, click Save.
10. Next, add the custom attribute that will show the current date. In the Rows section, click Add.
11. From the list of attributes, choose Calculated attributes > Today, then click Apply. This shows the number of tickets and today's date.
12. Next, hide the metric value and the heading. Click Chart configuration (  ) >  Columns from the right-hand panel. 
13. Hide the second column from the list.
14. To hide the heading, click Chart configuration (  ) >  Chart. Look for Header visibility and hide the header. 
15. You can also adjust the text configuration in the same setting.
16. The report is, by default named New report. Click the New report text and replace it with a title of your own.
17. Finally, click Save.

Now, you can add it to your dashboard to display the current date. To add a report to your dashboard, see the article: Adding reports to dashboards.