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

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
 
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
 
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
 
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

Embedding Views in Web Pages, Web Applications and Blogs

Zoho Analytics, being a versatile reporting software, allows you to easily embed any view such as a table, report or dashboards in a website, web application, blog or an intranet page. You can embed views with a secured login (with login) or a private permalink (without login) or with public access. Users visiting the webpage will be able to see the latest live version of the view and any changes that you make to the view will automatically get reflected in the embedded version as well.

  1. What are the views that I can embed in my website/blog?
  2. What are the access modes available when embedding a report/dashboard?
  3. What is the difference between the three embedding modes?
  4. How to embed a view with Secured login?
  5. How to embed a view with Private URL/Permalink?
  6. Can I protect my Private URL (without Login) with a password?
  7. Can I set an expiry date for my Private URL (without Login)?
  8. Can I embed only a few selected columns from my data table/query table?
  9. How to embed a view with Public access?
  10. Can the embedded reports and dashboards be shared across social handles?
  11. How to share embedded reports and dashboards across social handles?
  12. What are the interaction options that are supported in an embedded report/dashboard?
  13. I regenerated the random key, I cannot access my previously embedded views. What should I do?
  14. How do I edit the permission of the embedded view?
  15. How do I remove the access of the embed view?
  16. Can I pass a dynamic filter while embedding the view?

1. What are the views that I can embed in my website/blog?

You can embed all the views such as tables, charts, pivots, tabular view, summary view, query tables and dashboards that you create using Zoho Analytics. To embed a view created in Zoho Analytics, you need to get the corresponding HTML code snippet generated for the view by Zoho Analytics and paste them within the <body>...</body> HTML tags of the destination page. Refer to this question to learn about generating a HTML snippet.

2. What are the access modes available when embedding a report/dashboard?

The following are the three access modes that you can choose while embedding a report/dashboard.

  1. Embedding with Secured Login (with login): This is the most secure mode of embedding a view. Only the users with whom you have shared the report will be able to view it upon logging into Zoho Analytics.
  2. Embedding with Private permalink (without login)When this setting is selected Zoho Analytics will generate an embed URL (within an iframe code) which will contain a big randomly generated private key (private link), making them secure and very hard (if not impossible) to guess. Users can view the embedded report without logging in to Zoho Analytics. Please do note that this option is available only in the premium and enterprise plans of Zoho Analytics.
  3. Embedding with Public Access: In case you want your embedded report to be accessible to the users within your organization or to the users who visit your web page and do not require any random key based link generation or logging into Zoho Analytics, you can use the public access mode.

3. What is the difference between the three embedding modes?

Embedding with secured login allows the highest level of security to the embedded view. When you embed the view with "Private Access with Login", then it would prompt for the users to login to Zoho Analytics to access the embedded view. Also, only users to whom you have shared the view would be able to access the embedded view, on a successful login. 

When you embed a report with "Private Access without Login", Zoho Analytics will generate a private permalink making it secure and very hard to guess. Users need not login to Zoho Analytics to view the embedded report. Although this is secure, the randomly generated key is not impossible to guess.

In case you want your embedded report to be accessible to the users within your organization or to the users who visit your web page and do not require any random key based link generation or logging into Zoho Analytics, you can use the public access mode.

4. How to embed a view with Secured login?

Click to learn about editing permissions for the embedded report/dashboard.

5. How to embed a view with Private URL/Permalink?

Click to learn about editing permissions for the embedded report/dashboard.

6. Can I protect my Private URL (without Login) with a password?

Yes, you can protect your private URLs (without Login) with password. When you generate a permalink with Private Access (Without Login), Zoho Analytics will generate a private permalink making it secure and very hard to guess. You can also protect it with a password by selecting Set access password checkbox in Embed/Publish URL dialog. 

7. Can I set an expiry date for my Private URL (without Login)?

Yes, you can set an expiry date for your URL by checking the Set expiry checkbox in the Access without Login section. The shared URL will be valid only for the specified time frame. After the mentioned date, the URL will expire. After the set time, you can extend the expiry date, if you want to extend the validity.

8. Can I embed only a few selected columns from my data table/query table?

Yes, you can embed selected columns from your table while you embed them without login. This enables you to control what data your users get to see and will particularly be helpful in case you have sensitive data in your table.
 
You can share selected columns from your table by following the below steps:  

  1. Open the view that you wish to embed.
  2. Click Share > Embed.
  3. Once you have set your Access Permission as Access Without Login, you will notice an Edit Permissions link inline with the option.
  4. Click the Edit Permissions link. The Apply Permissions & Filters dialog will open. 
  5. Click the All Columns link under Read Access and then select the columns to be shared.
  6. Click OK to confirm the selected columns. The users accessing the URL will be able to access only selected columns for viewing and report creation. 

9. How to embed a view with Public access?

Click to learn about editing permissions for the embedded report/dashboard.

10. Can the embedded reports and dashboards be shared across social handles? 

Yes, you can share the embedded reports and dashboards to your social handles using the Social Widget option. Learn more.

11. How to share the embedded reports and dashboards across social handles?

Follow the below steps to share the embedded reports and dashboards to your social handles:

  1. Click the Share button from the top-right corner.
  2. Select the Embed option from the drop-down menu.
  3. Select the Access Permission as Access without Login or Access within the Organization/External Users.
  4. Choose the Social Widgets checkbox available in the Options section.
  5. When you access the embedded report/dashboard, you will notice the Facebook, Twitter, and LinkedIn icons. Using these icons, you can share/tweet them.
Note: The Social Widgets option is available only for Access without Login and Access within the Organization/External Users publish options.

12. What are the interaction options available while embedding a report/dashboard?

Zoho Analytics allows you to embed reports/dashboards in an interactive mode. When you embed a report in interactive mode in a web page, then users visiting the web page can view and interact with the chart as you could do when you view the report within the Zoho Analytics user interface. The following interactions are possible when a chart is embedded in an interactive mode:

1. Tooltips & highlights.  

2. View the underlying data  

3. Drill down 

4. Change chart type  

5. Apply User Filters, if the chart contains user filters

6. Interact with legend 

You can also embed the reports as a image. This feature is only available for charts. As a result of this, the chart will be generated as a static image and hence will load faster. 

13. I regenerated the random key, now I cannot access my previously embedded views or URL's of that report/dashboard. What should I do?

When you reset/regenerate the random key, the previously shared URL's/Embeds will become invalid. You will have to regenerate the new embed snippet and update the page.

14. How do I edit the embed permissions?

You can edit the previously granted permissions by following the below steps:

  1. Open the corresponding view that has been embedded and invoke the Share > Embed in Website/Blog.
  2. From the Embed / Publish URL page that opens, click the Edit link at the top right corner or the Edit Permissions link in line with Access without Login menu.

\ 

15. How do I remove the access of the embed view?

You can easily remove the permissions by following the below steps:

  1. Open the corresponding report that has been embedded and invoke the Share > Embed.
  2. From the Embed / Publish URL page that opens, click the Edit link at the top right corner.
  3. Click the Remove icon in line with the respective access to remove the permission.

16. Can I pass a dynamic filter while embedding the view?

Zoho Analytics offers a powerful feature of applying dynamic filters when you embed any view into your Web page. Using this feature, you can embed the same view in web pages applying different set of filter criteria, to suit the allowed permission, context and profile of the user who is viewing the page.

For example, an embedded sales report can have a 'Region' based criteria in each page that it's embedded, creating a scenario such that, when a sales person from say Region West views his/her accessible page, will only see the Sales from that region in the report embedded. A similar setup can be applied for sales person from other regions.

Filters can be applied by passing the required filter criteria to the parameter named ZOHO_CRITERIA and appending it as part of the Embed URL present in the HTML <iframe> code snippet. The embedded view's data is filtered and displayed based on the criteria specified, whenever the web page is loaded in the browser.

Example:

The generated HTML code snippet for embedding your view with the <iframe> tag would look like something given below (the following code snippet is for a Table):

<iframe frameborder=0 width="800" height="600" src="https://analytics.zoho.com/open-view/1156972000001226026?ZOHO_CRITERIA=("Store Sales"."Region"='West')"></iframe>

The above snippet displays a "Sales" table when embedded. To limit the view to just show the Sales in the West Region, the parameter ?ZOHO_CRITERIA=("Store Sales"."Region"='West') is added to the <iframe> code snippet. In this parameter "Region" is the column name in the view, which is filtered to display values matching the region West. The parameter should also be encoded. You can use this tool or any other tool that is available on the internet to encode.

The complete code snippet with this parameter is given below:

<iframe frameborder=0 width="800" height="600" src="https://analytics.zoho.com/open-view/1156972000001226026"?ZOHO_CRITERIA=(%22Store%20Sales%22.%22Region%22%20%3D%20'West')'></iframe>

When you embed the above code snippet into a web page, the table view displayed will contain only the values matching the Region West.

Filter Criteria Format

The filter criteria that is passed follows the same format as that of the SQL SELECT Query's WHERE clause. You can also use SQL in-built functions as part of the criteria. These built-in functions should be the functions supported by any of Oracle, MS SQL Server, MySQL, DB2, Sybase, ANSI SQL, Informix and PostgreSQL databases. 

The generalized format of simple criteria is given below.

ZOHO_CRITERIA="(<[tablename].[columnname]/SQL expression/SQL function calls> <relational operator> <value/[tablename].[columnname]/SQL expression/SQL function calls>)"

Description:

Column nameRefers to the name of the column on which you are applying the criteria
SQL Expression

Any valid SQL Expression.

Eg: "Store Sales"."Sales"-"Store Sales"."Cost">1000

Supported Arithmetic Operators are: +, -, *, /

SQL Function callIn-built standard functions from Oracle, MS SQL Server, MySQL, DB2, Sybase, ANSI SQL, Informix and PostgreSQL databases 
Eg.: year([table_name].[date_column]) = 2016
Relational operator

Any relational operator to compare values supported in an SQL SELECT Query WHERE clause. The following operators can be used:

  • =
  • !=
  • <
  • >
  • <=
  • >=
  • LIKE
  • NOT LIKE
  • IN
  • NOT IN
  • BETWEEN
Value

Refers to the exact value to match

Eg.: "Accounts"."Department" = 'Finance"

here 'Finance' is a literal value to match.

You can also define filters containing multiple columns as the example given below
(("Store Sales"."Region"='South' AND "Store Sales"."Sales" < 10000) OR ("Store Sales"."Region"='West' AND "Store Sales"."Sales" < 10000))

Notes for Criteria formation:

  • You can combine any number of criteria defined in the above-specified format using Logical Operators like AND and OR to form complex criteria, the same way as in SQL SELECT WHERE clause. Also, use Braces '()' to group the criteria for ordering.
  • Enclose string literals (i.e. values) in single quotes.
  • Enclose table name and column names in double quotes.
    • Eg.: ("Store Sales"."Date Of Birth" = '2016-01-31 00:00:00')
  • Currency symbols (or) percent symbol can't be used in criteria
    • Eg.: [table_name].[currency_column] = 75.66 is valid
    • Eg.: [table_name].[percent_column] = 100 is valid
    • [table_name].[currency_column] = 75.66$ (or) [table_name].[percent_column] = 100% is not valid

Refer to the SQL SELECT WHERE clause documentation to know more on how to construct the filter criteria.

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