How do I create a formula that gives me a ratio of Lead Conversions per Week over Calls made per week?

How do I create a formula that gives me a ratio of Lead Conversions per Week over Calls made per week?

So using the two system-generated tables from CRM, Leads and Calls, I want to create a custom field for a report that will show me Leads converted by week, divided by the calls made per week. 

In the Leads table I have the field "Date Converted", and the Calls table has the default "Call Start Time" field.  What I would want of course is to group the data from these two tables under one date field, so I could have "Week Created" as the X axis on the report.  And then I would create a custom aggregate formula to calculate Leads Converted over Total Calls Made.  But, you can't create a Lookup between these two columns in the tables.  

Would this require a Query table (perhaps using Coalesce to join date column then Union All) or is there a more straightforward solution I'm not seeing?  



    • Sticky Posts

    • What's New in Zoho Analytics - January 2026

      Hello Users! We are starting the year with a strong lineup of updates, marking the beginning of many improvements planned to enhance your analytics experience. Explore the latest improvements built to boost performance, simplify analysis, and help you
    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

    Nederlandse Hulpbronnen