Need Custom Reports for list of Ticket Created & Modified

[macrotech]

Hello, Can someone help me how can we create report where i can generate reports how many tickets (Case) created today and including view, modified reports (Modified means if agent put any comments in to stream also consider as a ticket modified)

[tanya]

Hello,

posts are saved in entity Note.This entity is not available in Reports.
But...
You can create a readOnly date or dateTime field for Case, which will contain the date or the time of the last agent's comment.
After that you create a workflow rule for Note. In formula condition set parentType='Case' and set other conditions, which determine this Note as agent's. In Actions add an action 'Update Related Entity' -> 'Parent' and set your field value as now/today.

Now you can create a report for Case based on 'createdAt' field and yours.

Regards.