Explore Time Filter | Community
Skip to main content

Explore Time Filter

  • March 27, 2019
  • 3 replies
  • 0 views
A
  • Anonymous
I have created a report to look at the number of tickets reopened, by Reason for Contact = Complaint and Objection Raised is true.
 
I have created a calculated attribute - (Objection Raised Timestamp - Date/Time) because I need to be able to filter the report by a specific date range. I can add the calculated attribute (Objection Raised Timestamp - Date/Time) as a data filter to the report. But this means I have to manually select each date individually.
 
I want to be to add the calculated attribute (Objection Raised Timestamp - Date/Time) as a time filter, as the time filter provides the option to render as:
  • Calendar
  • Common Range
  • Advanced Ranges
I have read this article which states - In the Time filter widget panel, select a date attribute to use in the filter. But when I search for (Objection Raised Timestamp - Date/Time) which is a calculated attribute, or even just the standard attribute "Objection Raised" neither appear
 
Is it because "Objection Raised" is an attribute and (Objection Raised Timestamp - Date/Time) is a calculated attribute? If so, how can I create a date attribute in Explore, is this possible?
    This topic has been closed for replies.

    3 replies

    B
    • Bart11
    • April 10, 2020

    @Kerry Charlton, 

    Do you happen to know how to set set the time filter so that by default it uses a common range like this week. -- Where you can then manipulate it to another date.

    By default, it uses all history and takes time to run a query, so would rather by default it opens this week to then further change the range. 

    Any ideas would be appreciated. If this is something that is already possible or is planned, that be great too know @Rob Stack

    R
    • Rob21
    • April 10, 2020

    Hi @Bart you should be able to use bookmarks to accomplish this. There's some useful information in https://support.zendesk.com/hc/en-us/articles/360034902733

     

     

    B
    • Bart11
    • April 14, 2020

    @Rob Stack, 

    Worked like a charm. 

    Terms & ConditionsCookie settingsAccessibility statement