Analytics Case Attachments Flag
I have a requirement to identify which cases have attachments.
I have located the File Attachments table in Analytics, but don't want to include the names/id's of all attachments as this is creating a lot of data lines.
I have tried excluding these columns, but filtering by where attachment ID is greater than 0, and then choosing not to display duplicate lines but I then get blank lines showing on the report, 1 for each attachment for that case.
Is there a way to show just 1 case line where an attachment exists for that case?