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:
- 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?
Por favor, entrar para comentar.