To record the time when a checkbox was checked in Zendesk Explore, you need to create a report using a standard calculated attribute. This attribute will capture the timestamp of when the checkbox was checked. If the checkbox is unchecked and then rechecked, a new timestamp will be recorded.
Start by creating a new report in Explore and selecting the 'Support - Updates history' dataset. Then, create a standard calculated attribute with a formula that checks for changes in your custom checkbox field. Replace '{yourcheckboxfield_name}' with the actual name of your checkbox. Once the attribute is saved, you can build your report by adding metrics and filtering out NULL values to display only relevant timestamps. For more details, check the originalZendesk help article.
To create a checkbox timestamp report in Zendesk Explore, you need to have either Editor or Admin permissions. These permissions allow you to access the necessary features in Explore to build and customize reports. Additionally, you must be using…
Yes, you can adapt the checkbox timestamp formula for other custom fields in Zendesk. The formula provided in the help article is designed for checkboxes, but it can be modified to work with other custom field types. For fields like dropdowns or…
To filter out NULL values in your Zendesk Explore report, you need to adjust the settings of your calculated attribute. This ensures that only entries with valid timestamps are displayed. After adding your calculated attribute to the Rows panel,…
Yes, you can track timestamps for numeric fields in Zendesk using a similar approach to the checkbox timestamp formula. By referencing the name of your numeric field in the formula, you can capture the timestamp when a value is entered. The formula…
To display only the most recent checkbox check in your Zendesk report, you can use the latest date functions available in Explore. This will help you filter out older entries and focus on the most recent updates. By applying the DATE_LAST function…