Hr case requested by vs opened by report in performance analytics

charan_1
Tera Contributor

I have a requirement that i need to report in performance analytics where the report in pa has to be hr cases opened by vs requested by. Can anyone suggest the steps how to make the two reports as an  user I want to be able to run a report showing the cases in a period of time split between those opened by and requsted by.

2 REPLIES 2

SANDEEP28
Mega Sage

@charan_1 In HR case table (sn_hr_core_Case), we don't have requested by column. We have there user fields as below

1) Opened by

2) Opened for

3) Subject person

 

Do you want PA report for Opened by & Opened for?

charan_1
Tera Contributor

@SANDEEP28 The table which i had the field names are showing as requested by and opened by . can you please tell how to report opened by vs opened for in pa