Lookup field display in Zoho Analytics

Lookup field display in Zoho Analytics

Hello,

I think I am missing something very obvious, but I can't figure it out:

I have 2 lookup fields in my "Deals module" -> One for the account that we have the project with  and one for the beneficiary account. Both fields refer to the "account name" in the "Accounts Tab" of Zoho CRM.

Now when I go in Zoho Analytics, if I drag the "Beneficiary account" from the deal module in a chart it displays the ID of that account, but I want to display the name of the account.

I know that if I drag the "Account Name" from the Accounts tab it will display the account that we have the project with, but how do I display the beneficiary account's name instead of the ID?

Thank you,
Adriana
    • Sticky Posts

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
    • [Webinar] Evolving BI & Analytics in the Age of AI

      Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations
    • Geo-Powered Retail Intelligence with Zoho Analytics

      In today’s highly competitive retail landscape, data-driven decisions are no longer optional — they’re essential. While businesses collect vast volumes of data across regions, stores, and customer segments, the real value lies in how effectively this
    • Create and save user-specific filter views with Zoho Sheet

      The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
    • Customer Segmentation using RFM Analysis

      How well do you know your customers? Whether you operate in a B2B or B2C space, chances are that 80% of your business comes from just 20% of your customers (Pareto's Principle). According to a study by Forbes, acquiring new customers costs five times