Hello! I am creating a report that will be sent to an end-user. They have requested a column to display the date the ticket was last updated. I have this filtered to be a public comment, however, I am not sure which value to use as a row or what other filtering criteria I need to use. I have tried two setups and neither displayed what I wanted.
The first setup showed a new row with a date for each time a public comment was added to the ticket, so there ended up being multiple rows/date associated with each ticket. The second setup I tried was showing one date for each ticket, but it was including date for private comments too (even though I am filtering by Public comment types.)
I only want a column that displays the date of the most recent public comment. Any ideas?
Please sign in to leave a comment.