Frequent Visitor
Posts: 4
Registered: ‎12-23-2016

Calculate difference between indirectly related tables


I am working on a BI report on HR time attendence vs CRM time spending. I had a common employee and calendar table between HR TLM table and CRM table. Is it possible to calculate the differences between HR time and CRM time based on date and employee? I had a gauge visual that displays HR time as Target and CRM time as fill. The goal is to detect any false reporting under CRM. CRM time should equal or less than HR time.  If I have the diffferences between HR and CRM time, I can direct managers to the employees who had incorrect time & attendance record. Thanks a lot for you help.