Skip to product menu
close
  • Recent Launches
    Press Space or Enter to display list of options
EXPLORE ALL PRODUCTS

Recent Launches

New

Payroll software with automated tax payments and filing.

Try now
New

Robotic process automation software to automate high-volume, rule-based tasks.

Try for free
New

Low-code IoT platform and solutions for connected businesses.

Try now
New

Business formation service to launch and grow your businesses.

Try now
New

Privacy-friendly application analytics solution.

Try for free

Sales

 
CRM

Comprehensive CRM platform for customer-facing teams.

CRM
 
Bigin

Simple CRM for small businesses moving from spreadsheets.

Bigin
 
Forms

Build online forms for every business need.

Forms
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
Sign

Digital signature app for businesses.

Sign
 
RouteIQ

Comprehensive sales map visualization and optimal route planning solution.

RouteIQ
 
Thrive

Complete loyalty and affiliate management platform.

Thrive
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
Suites
CRM Plus

Unified platform to deliver top-notch customer experience.

CRM Plus

Marketing

 
Social

All-in-one social media management software.

Social
 
Campaigns

Create, send, and track targeted email campaigns that drive sales.

Campaigns
 
Forms

Build online forms for every business need.

Forms
 
Survey

Design surveys to reach and interact with your audience.

Survey
 
Sites

Online website builder with extensive customisation options.

Sites
 
PageSense

Website conversion optimization and personalisation platform.

PageSense
 
Backstage

End-to-end event management software.

Backstage
 
Webinar

Webinar platform for webcasting online webinars.

Webinar
 
Marketing Automation

All-in-one marketing automation software.

Marketing Automation
 
LandingPage

Smart landing page builder to increase conversion rates

LandingPage
 
Publish

Manage all your local business listings on a single platform.

Publish
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Sign

Digital signature app for businesses.

Sign
 
Thrive

Complete loyalty and affiliate management platform.

Thrive
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
NEW
LeadChain

Sync, manage, and convert leads across channels seamlessly.

LeadChain
 
NEW
CommunitySpaces

Online community platform for individuals and businesses to grow their network and brand.

CommunitySpaces
 
Suites
Marketing Plus

Unified marketing platform for marketing teams.

Marketing Plus

Commerce and POS

 
Commerce

eCommerce platform to manage and market your online store.

Commerce

Service

 
Desk

Helpdesk software to deliver great customer support.

Desk
 
Assist

Remote support and unattended remote access software.

Assist
 
Lens

Interactive remote assistance software with augmented reality.

Lens
 
FSM

End-to-end field service management platform for service businesses.

FSM
 
SalesIQ

Live chat app to engage and convert website visitors.

SalesIQ
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
Suites
Service Plus

Unified platform for customer service and support teams.

Service Plus

Finance

 
Books

Powerful accounting platform for growing businesses.

Books
 
FREE
Invoice

100% Free invoicing solution.

Invoice
 
Expense

Effortless expense reporting platform.

Expense
 
Inventory

Powerful stock management and inventory control software.

Inventory
 
Billing

End-to-end billing solution for your business.

Billing
 
Checkout

Collect payments online with custom branded pages.

Checkout
 
NEW
Payroll

Payroll software with automated tax payments and filing.

Payroll
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo
 
Practice

Practice management software for accounting firms.

Practice
 
Sign

Digital signature app for businesses.

Sign
 
Commerce

eCommerce platform to manage and market your online store.

Commerce
 
Suites
Finance Plus

All-in-one suite to manage your operations and finances.

Finance Plus

Email and Collaboration

 
Mail

Secure email service for teams of all sizes.

Mail
 
Meeting

Online meeting software for all your video conferencing & webinar needs.

Meeting
 
Writer

Word processor for focused writing and discussions.

Writer
 
Sheet

Spreadsheet software for collaborative teams.

Sheet
 
Show

Create, edit, and share slides with a sleek presentation app.

Show
 
Notebook

Beautiful home for all your notes.

Notebook
 
Cliq

Stay in touch with teams no matter where you are.

Cliq
 
Connect

Employee experience platform to communicate, engage, and build positive employee relations.

Connect
 
Bookings

Appointment scheduling app for consultations with customers.

Bookings
 
TeamInbox

Shared inboxes for teams.

TeamInbox
 
WorkDrive

Online file management for teams.

WorkDrive
 
Sign

Digital signature app for businesses.

Sign
 
Office Suite

Powerful collaborative work platform for teams.

Office Suite
 
Office Integrator

Built in document editors for web apps.

Office Integrator
 
ZeptoMail

Secure and reliable transactional email sending service.

ZeptoMail
 
Calendar

Online business calendar to manage events and schedule appointments.

Calendar
 
Learn

Knowledge and learning management platform.

Learn
 
Voice

Cloud Contact Center Software for businesses.

Voice
 
ToDo

Collaborative task management for individuals and teams.

ToDo
 
Tables

Work management tool to connect people, processes, and information.

Tables
 
FREE
PDF Editor

Collaborative online PDF editing tool.

PDF Editor
 
Suites
Workplace

Application suite built to improve team productivity and collaboration.

Workplace

Human Resources

 
People

Organize, automate, and simplify your HR processes.

People
 
Recruit

Intuitive recruiting platform built to provide hiring solutions.

Recruit
 
Expense

Effortless expense reporting platform.

Expense
 
Workerly

Manage temporary staffing with an employee scheduling solution.

Workerly
 
NEW
Payroll

Payroll software with automated tax payments and filing.

Payroll
 
Shifts

Employee scheduling and time tracking app.

Shifts
 
Sign

Digital signature app for businesses.

Sign
 
Suites
People Plus

Comprehensive HR platform for seamless employee experiences.

People Plus

Security and IT Management

 
Creator

Build custom apps to simplify business processes.

Creator
 
Directory

Workforce identity and access management solution for cloud businesses.

Directory
 
FREE
OneAuth

Secure multi-factor authenticator (MFA) for all your online accounts.

OneAuth
 
Vault

Online password manager for teams.

Vault
 
Catalyst

Pro-code platform to build and deploy your apps.

Catalyst
 
Toolkit

Complete resource for any admin-related lookup queries.

Toolkit
 
Lens

Interactive remote assistance software with augmented reality.

Lens
 
Assist

Remote support and unattended remote access software.

Assist
 
QEngine

Test automation software to build, manage, execute, and report testcases.

QEngine
 
NEW
RPA

Automate manual, tedious, and repetitive tasks easily.

RPA

BI and Analytics

 
Analytics

Modern self-service BI and analytics platform.

Analytics
 
Embedded BI

Embedded analytics and white label BI solutions, tailored for your needs.

Embedded BI
 
DataPrep

AI-powered data preparation service for your data-driven organization.

DataPrep
 
NEW
IoT

Harnessing IoT analytics for real-time operational intelligence.

IoT

Project Management

 
Projects

Manage, track, and collaborate on projects with teams.

Projects
 
Sprints

Planning and tracking tool for scrum teams.

Sprints
 
BugTracker

Automatic bug tracking software for managing bugs.

BugTracker
 
NEW
Solo

The all-in-one toolkit for solopreneurs.

Solo

Developer Platforms

 
Creator

Build custom apps to simplify business processes.

Creator
 
Flow

Automate business workflows by creating smart integrations.

Flow
 
Catalyst

Pro-code platform to build and deploy your apps.

Catalyst
 
Office Integrator

Built in document editors for web apps.

Office Integrator
 
ZeptoMail

Secure and reliable transactional email sending service.

ZeptoMail
 
QEngine

Test automation software to build, manage, execute, and report testcases.

QEngine
 
Tables

Work management tool to connect people, processes, and information.

Tables
 
NEW
RPA

Automate manual, tedious, and repetitive tasks easily.

RPA
 
NEW
Apptics

Application analytics for all apps.

Apptics
 
Embedded BI

Embedded analytics and white label BI solutions, tailored for your needs.

Embedded BI
 
NEW
IoT

Build, deploy, and scale IoT solutions for connected businesses.

IoT
 
DataPrep

AI-powered data preparation service for your data-driven organization.

DataPrep

IoT

 
NEW
IoT

Low-code IoT platform and solutions for connected businesses.

IoT

Search Result

 
CRM Plus

Unified platform to deliver top-notch customer experience.

Try now
CRM Plus
 
Service Plus

Unified platform for customer service and support teams.

Try now
Service Plus
 
Finance Plus

All-in-one suite to manage your operations and finances.

Try now
Finance Plus
 
People Plus

Comprehensive HR platform for seamless employee experiences.

Try now
People Plus
 
Workplace

Application suite built to improve team productivity and collaboration.

Try now
Workplace
 
Marketing Plus

Unified marketing platform for marketing teams.

Try now
Marketing Plus
 
All-in-one suite

Zoho One

The Operating System for Business

Run your entire business on Zoho with our unified cloud software, designed to help you break down silos between departments and increase organizational efficiency.

TRY ZOHO ONE
Zoho One
Zoho Marketplace

With over 2000 ready-to-use extensions across 40+ categories, connect your favorite business tools with the Zoho products you already use.

EXPLORE MARKETPLACE
Marketplace

Zoho Analytics has been recognized in the 2024 Gartner® Magic Quadrant™ for ABI PlatformsRead more

Skip to main content

Zoho Connect Advanced Analytics

Advanced Analytics connector for Zoho Connect allows seamless import of your Zoho Connect data for detailed analysis. This integration helps you track and visualize team activities, collaboration metrics, and engagement trends, providing valuable insights to enhance team productivity and collaboration strategies.

This integration comes with a set of pre-built reports that provide important details like the average response time taken for responses, the number of responses received for each survey, and much more.

Setting up the Integration

A user with administrator privileges (Account admin and Org admin) can configure the integration.

Note:

  • The initial fetch might take a few minutes depending on the volume of the data to be imported. An email and an in-app notification will be sent, once the initial fetch is complete.
  • The setup process can sometimes fail for a variety of reasons. In this case we request you to access the Data source tab and click the Retry link to import again. If the issue persists then write to support@zohoanalytics.com.

Modules & Fields (What are the modules and fields in Zoho Connect that will be synchronized in Zoho Analytics Workspace?)

The below table lists the modules and fields that will be synced to Zoho Analytics.

Modules

Fields

ArticleCommentCOMMENT_ID, ARTICLE_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, IS_PRIVATE
ArticleARTICLE_ID, TITLE, URL, CREATED_BY, MANUAL_ID, CHAPTER_ID, STATUS, IS_PUBLISHED, PUBLISHED_BY, PUBLISHED_TIME
BadgeBADGE_ID, BADGE_NAME, TYPE, CREATED_TIME
BadgeHolderBADGE_HOLDER_ID, MEMBER_ID, BADGE_ID, ACHIEVED_TIME, ASSIGNED_BY, POST_ID
BoardBOARD_ID, BOARD_NAME, STATUS, URL, CREATED_BY, CREATED_TIME, GROUP_ID
BoardCustomFieldCUSTOM_FIELD_ID, CUSTOM_FIELD_NAME, CUSTOM_FIELD_TYPE, BOARD_ID
BoardCustomFieldOptionsCUSTOM_FIELD_OPTION_ID, CUSTOM_FIELD_ID, CUSTOM_FIELD_OPTION_VALUE
BoardCustomFieldRecordCUSTOM_FIELD_RECORD_ID, TASK_ID, CUSTOM_FIELD_ID, CUSTOM_FIELD_VALUE
BoardMembersBOARD_MEMBER_ID, MEMBER_ID, BOARD_ID, MEMBER_SINCE
CustomEventTypeCUSTOM_EVENT_TYPE_ID, EVENT_TYPE_NAME
EventEVENT_ID, TITLE, START_TIME, END_TIME, LOCATION, CUSTOM_EVENT_TYPE_ID, ALLDAY, COMMENT_COUNT, GROUP_ID, CREATED_TIME
EventAttendeesEVENT_ATTENDEES_ID, MEMBER_ID, STATUS, EVENT_ID
EventCommentCOMMENT_ID, EVENT_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, IS_PRIVATE
EventInviteesEVENT_INVITEES_ID, MEMBER_ID, MEMBER_TYPE, EVENT_ID
ForumFORUM_ID, CREATED_BY, COMMENT_COUNT, LIKE_COUNT, CREATED_TIME, TITLE, URL, VIEW_COUNT, UNIQUEVIEW_COUNT, IS_MANDATORY_READ
ForumCategoryCATEGORY_ID, CATEGORY_NAME, IS_DEFAULT_FOLLOW, URL, CREATED_BY, CREATED_TIME
ForumCategoryMapCATEGORYMAP_ID, FORUM_ID, CATEGORY_ID
ForumCommentCOMMENT_ID, FORUM_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, IS_PRIVATE
GameLevelGAME_LEVEL_ID, LEVEL_NUMBER, LEVEL_NAME, LEVEL_POINTS
GroupGROUP_ID, GROUP_NAME, STATUS, TYPE, URL, CREATED_BY, CREATED_TIME, ACCESS_TYPE
GroupMembersGROUP_MEMBER_ID, MEMBER_ID, GROUP_ID, MEMBER_SINCE
IdeaCommentCOMMENT_ID, IDEA_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, IS_PRIVATE
IdeasIDEA_ID, GROUP_ID, CREATED_BY, STATUS, COMMENT_COUNT, UPVOTE_COUNT, CREATED_TIME, TITLE, URL, VIEW_COUNT, UNIQUEVIEW_COUNT, CATEGORY_ID, IS_MANDATORY_READ
IdeasCategoryCATEGORY_ID, CATEGORY_NAME, URL, CREATED_BY, CREATED_TIME, GROUP_ID
ManualMANUAL_ID, MANUAL_NAME, STATUS, URL, CREATED_BY, CREATED_TIME, GROUP_ID, IS_PUBLISHED, PUBLISHED_BY, PUBLISHED_TIME
ManualChapterCHAPTER_ID, CHAPTER_NAME, MANUAL_ID
ManualMembersMANUAL_MEMBER_ID, MEMBER_ID, MANUAL_ID, MEMBER_TYPE, MEMBER_SINCE
MemberDetailsNAME, ZUID, EMAIL, TOTAL_POINTS, TYPE
PollOptionPOLL_OPTION_ID, OPTION_TITLE, POST_ID, VOTE_COUNT
PostCommentCOMMENT_ID, POST_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, COMMENT_TYPE, IS_PRIVATE
PostsPOST_ID, GROUP_ID, TYPE, CREATED_BY, COMMENT_COUNT, LIKE_COUNT, PARENT_POST_ID, CREATED_TIME, IS_PRIVATE, TITLE, URL, VIEW_COUNT, UNIQUEVIEW_COUNT
TaskTASK_ID, BOARD_ID, ZUID, TITLE, START_DATE, DUE_DATE, PROGRESS_STATUS, PRIORITY, CREATED_TIME, TASK_SECTION_ID, COMPLETED_TIME, COMPLETED_BY, IS_PRIVATE, COMMENT_COUNT, PARENT_TASK_ID, STATUS
TaskAssigneesTASK_ASSIGNEE_ID, TASK_ID, MEMBER_ID
TaskCommentCOMMENT_ID, TASK_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, IS_PRIVATE
TaskSectionTASK_SECTION_ID, SECTION_NAME, CREATED_BY, CREATED_TIME, BOARD_ID, STATUS
TownhallTOWNHALL_ID, TOWNHALL_NAME, URL, CREATED_BY, CREATED_TIME, START_TIME, END_TIME
TownhallMembersTOWNHALL_MEMBER_ID, MEMBER_ID, TOWNHALL_ID, MEMBER_ROLE, MEMBER_TYPE, MEMBER_SINCE
TownhallPostCommentCOMMENT_ID, TASK_ID, PARENT_COMMENT_ID, CONTENT, CREATED_USER, LIKE_COUNT, THREAD_COUNT, CREATED_TIME, COMMENT_TYPE, IS_PRIVATE
TownhallPostsPOST_ID, TOWNHALL_ID, TYPE, CREATED_BY, COMMENT_COUNT, ANSWER_COUNT, UPVOTE_COUNT, CREATED_TIME, TITLE, URL, VIEW_COUNT, UNIQUEVIEW_COUNT

Data Sync Frequency

Zoho Analytics offers flexible sync schedules to ensure that your data is always up-to-date for effective analysis. These schedules allow you to automate the process of updating your data, ensuring that your analyses are based on the latest information.

  • 1 Hour (Enterprise plan only)
  • 3 Hours
  • 6 Hours
  • 12 Hours
  • Every day

Handling Data Synchronization Failure

Data synchronization can fail,

  • If the data type of a field is changed in the Zoho Connect Application.
  • If the Modules and Field selected for analysis are deleted in the source application.
  • If the user who configured the integration no longer has permission to access the modules.

In any of the above mentioned cases, the data sync will be paused. You will be notified via email and in- app notification with the exact reason for failure along with the solution.

To resolve the sync failure, delete or restructure the views, or restore the specific modules and fields from the source application. Refer to Data Sync failure and solutions article for more details.

Once you have made the changes, click the Sync now option in the data source tab to resume data sync. If the issue persists, contact support@zohoanalytics.com

Managing Data Sources

The Data Sources tab provides essential information to monitor and manage the integration setup. It also allows you to edit the settings as needed. Users with administrator privileges will be able to view and modify the connection settings.

Data Source Permalink

The Data Source Permalink helps you easily access the data source tab. Only the Organization Admin and Account Admin can make changes in the Data sources page, other users can know the synchronization details like whether the last data sync was successful or not, when the last data sync happened, when the next sync is scheduled to happen, etc. This link can also be pasted in dashboards so that everyone accessing the dashboard can know about the sync status.

Edit Setup

The Edit Setup tab allows you to add or delete modules or fields, change the schedule interval, and modify other settings specific to the business application.

To modify the settings, 

  1. Click Data Sources > Edit Setup.
  2. The Edit Setup - Zoho Connect dialog will open. Modify the settings as needed and click Save.

Re- Authenticate 

Re-authentication will be helpful when the API key or password is changed. In this case, the data sync will be paused, and the administrator who configure the connector setup must re-authenticate to resume the data sync.

Sync History

The Sync History tab provides details about the data sync for the last 45 days. A successful data sync is marked in green, and a sync failure is marked in red.

To view the Sync history,

  1. Click Data sources > Sync History.
  2. A calendar with the Sync History of the last 45 days will open. The date when the data sync has happened will be highlighted. Hover to view the number of times the data had got synced on a specific date.
  3. Click the date to view more details. 
    • Time - Displays the time when the data is synced.
    • Status - Shows whether the sync was a success or a failure.In case of failure, the reason will be displayed. Refer to this page to learn how to resolve the issue and avoid further failure.

Audit History

Zoho Analytics logs all the user activities and system events within the Zoho Connect workspace. The following actions that are logged in Zoho Analytics,

  • User Action: Create, Modules Added, Modules Removed, Fields Added, Fields Removed, Schedule Change and Entities Modified, Delete, Take Ownership, Re-authenticate, Sync Now, Retry.
  • System Action: Plan upgrade or downgrade.

To view the audit history,

  1. Click Data Sources > Audit History.
  2. A dialog with the activities for the last 180 days will open.

Remove Data Source

Zoho Analytics allows you to remove the integration if needed. Removing the integration will suspend further data synchronization. The data tables and the reports will be available.

Click the Settings icon in the Data Sources tab, and select Remove Data Source from the drop-down menu.

Data Modeling & Preparation

Zoho Analytics allows you to combine data from various sources such as Files, Feeds, Databases and Business Applications for an in-depth analysis. Query Tables allows you to combine data from different tables to create reports.

While blending data from other data sources, Zoho Analytics automatically identifies similar columns and provides suggestions for lookups. Refer to the Joining Tables article for more details.

Formulas

The default formulas in the Forums table.

Formula Name

Formula type

Formula

Description

EngagementFormula Column"Like Count"+"Comment Count"Gives the total Engagement count.
Comments per ForumAggregate Formulasum("Forums"."Comment Count")/count_distinct("Forums"."Forum Id")Gives the average comments received by forum.
Likes per ForumAggregate Formulasum("Forums"."Like Count")/count_distinct("Forums"."Forum Id")Gives the average likes received by each forum.
Views per ForumAggregate Formulasum("Forums"."View Count")/count_distinct("Forums"."Forum Id")Gives the average views received by each forum.


The default formulas in the Ideas table.

Formula Name

Formula type

Formula

Description

Views per IdeaFormula Columnsum("Ideas"."Viewed Users Count")/count_distinct("Ideas"."Idea Id")Gives the average views received by each idea.
Upvotes per IdeaAggregate Formulasum("Ideas"."Upvote Count")/count_distinct("Ideas"."Idea Id")Gives the average upvotes received by each idea.
Comments per IdeaAggregate Formulasum("Ideas"."Comment Count")/count_distinct("Ideas"."Idea Id")Gives the average comments received by each idea.
Completed IdeasAggregate Formulacount_if("Ideas"."Idea Status" = 'Completed')Gives the total count of completed ideas.


The default formulas in the Tasks table.

Formula Name

Formula type

Formula

Description

Is OverdueFormula Columnif("Task Progress Status" !='Completed' AND "Due Date"<date(today()),'Yes','No')Checks the status of task as overdue or not and gives the result as "Yes" or "No".
Task DurationFormula Columndatetime_diff_in_duration( "Start Date","Due Date")Gives the total Task Duration.
Task Completion ModeFormula Columnif(date_diff("Due Date","Start Date")>0,'On Time',if("Due Date" < now(),'Late','On Time'))Gives the Task Completion Mode as "On Time" or "Late".
Completed on Due MonthFormula Columnif((month("Due Date")=month("Completed Time") AND year("Due Date")=year("Completed Time")), true, false)Checks the whether the task completed on due month and gives the result as "True" or "False".
Actual Time TakenFormula Columnif("Task Progress Status"='Completed',datediff("Completed Time","Start Date")+1,datediff(now(),"Start Date")+1)Gives the actual time taken to complete tasks.
Completed Task CountAggregate Columncount_if("Tasks"."Task Progress Status" = 'Completed')Gives the count of completed tasks.
Open Tasks CountAggregate Columncount_if("Tasks"."Task Progress Status" != 'Completed')Gives the count of open tasks.
Completed Tasks %Aggregate Column"Tasks"."Completed Task Count"/count("Tasks"."Task Id")*100Gives the percentage of completed tasks.
Open Tasks %Aggregate Column"Tasks"."Open Tasks Count"/count("Tasks"."Task Id")*100Gives the percentage of open tasks.
High Priority Task CountAggregate Columncount_if("Tasks"."Task Priority" = 'High')Gives the count of high priority tasks.
High Priority Task %Aggregate Column"Tasks"."High Priority Task Count"/count("Tasks"."Task Id")*100Gives the percentage of high priority tasks.
Open High Priority TasksAggregate Columncount_if("Tasks"."Task Progress Status" != 'Completed' AND "Tasks"."Task Priority" = 'High')Gives the count of open high priority tasks.
Completed High Priority TasksAggregate Columncount_if("Tasks"."Task Progress Status" != 'Completed' AND "Tasks"."Task Priority" = 'High')Gives the count of completed high priority tasks.
Overdue Tasks CountAggregate Columncount_if("Tasks"."Is Overdue" = 'Yes')Gives the count of overdue tasks.
Overdue Tasks %Aggregate Columncount_if("Tasks"."Is Overdue" = 'Yes')/count("Tasks"."Task Id")*100Gives the percentage of overdue tasks.
Tasks Completed On TimeAggregate Columncountif("Tasks"."Task Progress Status" = 'Completed' and Datediff("Tasks"."Due Date","Tasks"."Completed Time") >= 0)Gives the count of tasks, which are completed On Time.
Tasks Completed On time %Aggregate Column(countif("Tasks"."Task Progress Status" = 'Completed' and Datediff("Tasks"."Due Date","Tasks"."Completed Time") >= 0))/count("Tasks"."Task Id")*100Gives the percentage of tasks, which are completed On Time.
Tasks Completed LateAggregate Columncountif("Tasks"."Task Progress Status" = 'Completed' and Datediff("Tasks"."Due Date","Tasks"."Completed Time") < 0)Gives the count of tasks, which are completed late.
Tasks Completed Late %Aggregate Column(countif("Tasks"."Task Progress Status" = 'Completed' and Datediff("Tasks"."Due Date","Tasks"."Completed Time") < 0))/count("Tasks"."Task Id")*100Gives the percentage of tasks, which are completed late.


The default formulas in the Posts table.

Formula Name

Formula type

Formula

Description

Likes per PostAggregate Columnsum("Posts"."Like Count")/count_distinct("Posts"."Post Id")Gives the average likes received by each post.
Comments per PostAggregate Columnsum("Posts"."Comment Count")/count_distinct("Posts"."Post Id")Gives the average comments received by each post.
Views per PostAggregate Columnsum("Posts"."View Count")/count_distinct("Posts"."Post Id")Gives the average views received by each post.
Posts per PostAggregate Columncount("Posts"."Post Id")/count("Groups"."Group Id")Gives the average posts posted by each group.


The default formulas in the Town Halls table.

Formula Name

Formula type

Formula

Description

DurationFormula Columndatetime_diff_in_duration( "Start Time","End Time")Gives the total duration of the Town Hall.


The default formulas in the Town Hall Questions table.

Formula Name

Formula type

Formula

Description

EngagementFormula Column"Comment Count"+"Answer Count"+"Upvote Count"Gives the count of total engagements in the Town hall.
Questions CountAggregate Columncount_if("Town Hall Questions"."Post Type" = 'QUESTION')Gives the count of total questions in the Town hall.
Polls CountAggregate Columncount_if("Town Hall Questions"."Post Type" = 'POLL')Gives the count of total polls in the Town hall.
Announcement CountAggregate Columncount_if("Town Hall Questions"."Post Type" = 'ANNOUNCEMENT')Gives the count of total announcements in the Town hall.
Views per PostAggregate Columnsum("Town Hall Questions"."View Count")/count("Town Hall Questions"."Town Hall Question Id")Gives the count of total questions in the Town hall.
Comments per PostAggregate Columnsum("Town Hall Questions"."Comment Count")/count("Town Hall Questions"."Town Hall Question Id")Gives the average views of each town hall.
Answers per PostAggregate Columnsum("Town Hall Questions"."Answer Count")/count("Town Hall Questions"."Town Hall Question Id")Gives the average answers posted in each town hall.
Upvotes per PostAggregate Columnsum("Town Hall Questions"."Upvote Count")/count("Town Hall Questions"."Town Hall Question Id")Gives the average upvotes received in each town hall.

Data Visualization / Analysis

Zoho Analytics offers a wide range of visualization types to conduct your analysis. Follow the below presentation to learn about creating reports over Zoho Connect data using Zoho Analytics.

Chart Types in Zoho Analytics

The below table lists the range of visualizations supported in Zoho Analytics.

Visualization 
 Types
Bar 
Stacked bar, Histogram, Horizontal bar
Stacked Bar 
Horizontal Stacked bar, 100% vertical and horizontal stacked bar
Area
Area with markers, Smooth Area, Smooth area with Markers
Line and Bar Combination chart
Bar with Line, Bar with Bubble, Bar with Scatter, Bar with Area, Area with Bubble, Line with Bubble and Custom Combination
Bubble Chart
Bubble Pie, Packed Bubble, Word Cloud
Stacked Area
Stacked area with markers, Smooth stacked area, Smooth stacked area with markers
Map
Heat Map, Map Scatter, Map Bubble, Map Pie, Map Bubble Pie, Map Filled, Geo Heat Map
Pie 
Pie, Ring, Semi Pie, Semi Ring
Tree map
Default View
SankeyDefault View
Sunburst
Default View
Race Chart
Default View
Doughnut
Default View
Matrix View
Pivot table
Tabular
Summary and Tabular view
Dashboards and KPI widgets
Single Numeric Widget, Dial Chart Widget
Bullet, Chart Widget

Sharing and Collaboration 

Help & Support

We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com.

You can also reach out to us on our toll-free numbers.
United States: +1 (888) 900 9646
United Kingdom: +44 (20) 35647890
Australia: +61-2-80662898
India: +91 44 6965 6060

 

x
Thanks for your interest. We shall get back to you shortly.