Performance Analytics and combining data

[dartx21]

I was looking through PA Wiki and videos. Is it possible to combine data from multiple tables and create metrics/historical data from that?

Example:

I want to see how many change requests that are being created from an incident.

[Vincent Loffel1 · Accepted solution]

Hi Chris,

If the table are referenced to each other, then yes. That is possible. I've created the KPI you described, multiple times at different customers. If tables are not referenced or connected to eachother, then you could combine data by creating widgets that contain multiple indicators. Or you could come up with an formula indicator that uses data from two different tables.

E.g. the total workload for the servicedesk would consist of three indicators that are combined (number of open incidents + number of open problems + number of op changes, all by assignment group servicedesk)

Cheers,

Vincent