How to get a combined report from two tables using performance analytics?

[Siva Ganesh]

I need a report consisting of three columns from one table and four columns from another table. How can I achieve this using performance analytics?

Can anyone give a solution to this?

Thankyou.

[yltsai]

You need to build a database view for the two tables. The new database view will be like a new table for you to build a report with the Performance Analytics.

The link will explain what a database view is in ServiceNow.

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/use/reporting/concept/c_D...

[AndersBGS]

Hi @Siva Ganesh ,

What you are describing is not the purpose of performance analytics (PA), as PA is only for measurement/calculation etc. You instead need to look into creating a Database view unless you can dot-walk from the first table to the second.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders