PA Reporting Data visualizations and filters query

[nicolabroad]

I'm creating a new PA dashboard with some data visualizations and filters. 

I need to be able to filter on different ticket types (cases, incidents, alerts) to see how many times an individual has updated tickets.

As an example; A colleague has made 15 updates to 3 different case records today. Over the week the same colleague has made 50 updates to 7 different cases. Entries updated by 'system' should not be included. 

Is this possible? If so please could someone advise the best way round this?

[Dr Atul G- LNG]

Hi @nicolabroad 

You need to use the Report on task --> task type, and if it’s a use case, you should use the Use Case table to capture it. For ITM-related items, you can use the Task table with the appropriate task type.

The Updated By field does get updated; however, the issue is that if you run a report over the weekend and someone else makes a change, the Updated By field shows the latest user, not the original user who made the earlier change.

[Ankur Bawiskar]

@nicolabroad 

you need to use metrics for this I believe

Also check this

Generate Report for Incidents handled or touched by your team even after reassignment 

In my opinion this could be somewhat complex to handle

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@nicolabroad 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏