I have two Labor reports I am trying to reconcile. One report is a payroll report with employee ID's, Date's worked, and Hours. The other report is a time ticket report to track labor activities, which also has employee ID's Hours worked, and the date. I am trying to reconcile these reports by importing them as tables, and then using the lookup function to subtract the hours p/date from one report to the other report by employee to identify employees with missing time tickets.
The problem I am having, is that when I create the lookup between the two reports, one report is summing ALL the historical hours for each employee and dumping all those hours into every date, This is making the reconciliation not work.
I have created a lookup between the employee ID and the dates between the reports
Cardinality for dates is many to many
Cardinality for employee ID I have tried one to one (what I thought it should be), but when that didn't work I also tried many to one, and many to many. None have worked.
Thanks for your help
Ask the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion
Announcing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data Preparation
Free Webinar: 5 Must have inventory reports for online sellers | Zoho Analytics & Zoho Inventory
Hello All, Selling goods online? These 5 inventory reports will help you make better informed decisions. Join us on this free webinar hosted by Zoho Analytics and Inventory domain experts to learn more. Register now! Friday, December 13th: 9am PST
Zoho Reports to be renamed and launched as Zoho Analytics 4.0
We made the Zoho Reports 4.0 Beta announcement a few months back. As we worked on new features in 4.0, we realized we are moving away from just Reporting, and getting more and more into the Analytics realm. And that's the reason why we have decided to rename Zoho Reports as Zoho Analytics. This post is just to give you a heads up on the Zoho Analytics 4.0 launch in mid November 2018. As present users of Zoho Reports, be assured that the new product will continue to work the same as the current one.
Zoho Reports Release 4.0 Beta
We are delighted to announce the new Zoho Reports Release 4.0 Beta. Your favorite Zoho Reports now comes with a fresh new-look and exciting features. The new Zoho Reports 4.0 includes the following features: Dashboards in Single Click The UI has been completely revamped focusing on easy navigation. Now you can access any dashboard in a single click using the Preview Cards. Easy Navigation The main navigational elements are made bolder and bigger now. The analytics elements are organized into three