Display Weight symbols to Values in a Widget
Hi there, I was wondering if there is a way to display weight symbols, similar to how you format units as in the screen shot for this widget: Want to show Weight with Metric units: Grams = g Kilograms = kg Tonnes = t etc. Thanks Andrew
Share with Support
I had recently shared my Workspace with support as part of troubleshooting (ticket #1). The problem is still under investigation and has been over 2 weeks now. Following another issue (ticket #2) I noticed that support were able to access my workspace. I then realized that my Workspace was still shared (as part of Ticket #1). It would be better for the Admin to be aware that the Workspace is being Shared with Support by some indication/mark/colour etc on the Workspace. Best regards, Sony
Report of the Week - Stage Analysis
Potential stage history analysis helps you track the stage movement of each potential. Tracking the wins and fails helps you avoid repeating the mistakes of the past and define better processes to convert more potentials into wins. This week, let's see
column total in report
Good day, I am trying to create a basic report with 10 columns, i would like to group the data and present a total for each group. Can someone please guide me on how to do this, i have not been able to figure out how to group the data much less get the
Splitting delimited values into multiple rows
Hello, I'll try to briefly explain the problem I am facing in Zoho Analytics. So, I created several forms in Zoho Forms, integrated it with Zoho CRM and then created a module in Zoho Analytics to receive the filled data. Let's say I have three columns
Tip of the Week - Embed View into Zoho CRM with Dynamic Filter
You can embed the views created in Zoho Analytics into Zoho CRM as a Web Tab using the Permalink of the view. Zoho Analytics allows you to dynamically filter your embedded views based on the user logged in. You can achieve this using Variable. Using Variables you can embed the same report with different filters for each user thereby controlling the data that could be accessed by the users dynamically. The following video illustrates how to embed with a dynamic filter based on the users' email address.
Compare data between two data
I have a problem that I would like to create a chart that can compare data with the following date ranges. This previous week (meaning last 7 days ) vs the data before last week days (meaning data before 7 days ).
Zoho Analytics -
This might be a complex question, but I it's in high need in Zoho Analytics. I would like a chart that can compare data with the following date ranges. This last week (meaning data of last 7 days ) vs. data before last week ( means data range before previous
CRM Sandbox Workspace
Hello, We have a workspace in Analytics that is connected to CRM, and it is pulling in our production data. I am wondering if it is possible to create another workspace in Analytics and connect it to a sandbox in CRM? We've built some things in the sandbox
ZOHO ANALYTICS - HOW TO GET THE DATA VALUE?
Hi ZOHO Team, Good day. How can I get the data for Invoice Date, Invoice Number & Total Amount of Invoice from the Purchase Order Items as Source? Will appreciate immediate response Thank you Best Regards, Raffy Laoang
Timesheet data by Milestone
Hi What is the simplest way of getting timesheet data by Milestone? I can do it by Project since the timesheet table contains ProjectID, but it doesn't contain Milestone ID. Ultimately, I'm trying to calculate the cost of a milestone based on submitted
Adding calculations from other tables / Adding a sum
Hi Guys, i have the following problem: i want to create an analysis for each employe, that shows his "working hours" for a month and his "planned hours" (the hours he should work per month). Problem here: each employe has not 100% work time but some have
Copy paste multiple rows and columns?
Is it possible to copy paste multiple rows or column fields like working on a spreadsheet in Zoho reports.
How to find Widgets from ID
I'm attempting to delete lookup between two tables, however I need to delete the views and widgets which use this relationship first. The views are straight forward to find, but I'm unsure how to track down the widgets based on the ID provided. WIDGET:
How do I create a query table?
How do I create a query table? Is there a specific plan I need to be on to use this feature? After clicking on "Create" tab in the sidebar, I am not able to find the "Query Table" option.
Integration between Analytics and Marketing Automation
Dear Team, I would like to create dashboards email marketing performance of Marketing Automation in Zoho Analytics but I cannot find the connection. Is it possible to integrate those 2 apps? Please advise me. Many thanks in advance. Regards!
Add a report to a widget
I have created a report with two formula columns, one of which is true/false. I would like to add this report using the formula column as a percentage (how many true/total) and show it in a widget. Please can you help me.
Composite Primary Key (or Foreign Key)
Is it possible to have a composite Unique key - either as a Primary key, or as a Foreign key reference? If not, is it an acceptable workaround to create a new column that stores a concatenation of the fields I want as part of the composite key, and use this new column as my unique key?
Copy all reports in a folder
I currently have a database that I need to create multiple charts filtered by market. All of the charts are identical, I just change to of the filters and then I have the next market's set of charts. The only way I've been able to copy charts (reports)
Field limit | Zoho Desk
Hello there, In Zoho Desk you can create significantly more than 100 custom fields, plus the standard fields, of course: (img source: https://help.zoho.com/portal/en/kb/desk/customization/layouts-and-fields/articles/working-with-custom-fields#Adding_custom_fields)
[CRITICAL] Zoho Desk <-> Zoho Analytics Sync fails without specific error message!
Hello there, as you can see on the screenshot, the synchronisation of zoho desc keeps failing without a helpful error message! As a reason there is "A temporary error occurred while synchronising data from Zoho Desk" displayed... The error can't be that
Formula Using Returned Data Results
I'm trying to calculate the percentage of a returned data set relative to the total. In the example below, I'm trying to show the percentage of pears to the total count of fruit returned in the Pivot Table Report. I'm not sure the syntax for this....
Applying dashboard filters to KPI widgets
Hi, Is there an option to apply the Dashboard User Filters to the KPI widgets on the dashboard. They work for charts but don't apply to KPI widgets.
Joining Two Tables on Multiple Ids
Hello all, I'm guessing there is an obvious solution for this, but definitely not an expert in sql. On our Deals module, we have two user lookup fields. In Analytics, those fields have the user's ids in those table rows, and I'm trying to create a query
Website Alarm Monitoring
Watch this video to learn about the importance of aligning the alarms metric with your business goals, and how it can be achieved using Zoho Analytics and Site 24X7 integration
Get the User Filter value in the Dashboard (Zoho Analytics)
I built a dashboard in Zoho Analytics with different reports, tables, and widgets in it for my personal website https://apkzity.com. The dashboard has one user filter and it's a date filter. I'm happy to try Deluge script, SQL, or any other way to achieve
Showing total number of records on a stacked bar graph
Zoho Desk always displays the total number of records in the title of its stacked bar graphs. Is something similar also possible to achieve in Analytics?
Pagination in Zoho Analytics V2 bulk API
Dear Zoho Analytics developers! I am trying to get Zoho Analytics reports asynchronously using the Zoo Analytics V2 Bulk API I am creating a job, then I use the link "https://<ZohoAnalytics_Server_URI>/restapi/v2/bulk/workspaces/<workspace-id>/exportjobs/<job-id>/data"
What's New in Zoho Analytics - January 2024
Hello users! With the onset of a new year, we're delighted to bring you new feature updates and enhancements to improve your experience. Read on to learn more about what's new in Zoho Analytics. HyperSQL - Live Connect We have enabled Live Connect for
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
Integrating with the Google Play Store Console & Apple App Store
Has anyone integrated their Zoho Analytics Workspace with the app stores? We have a mobile app and I would like to be able to display the number of downloads, updates, and other statistics from the two app stores next to each other in Zoho Analytics.
Zoho Project - Total Forecasted Hours
Does anyone know an easy way to get a total of all the forecasted hours across the portfolio? I'm aware trying to create a custom report that can generate this figure for each task and the total up but the completion percentage doesn't seem to come back
Help creating inventory volume report.
I've been working with Zoho support for a few months now trying to develop a inventory volume report. Though they have been helpful, it never seems to generate exactly what we're looking for. I thought I'd turn to the community for further help. We've
Urgent: Continued Issues with WooCommerce Sync - Need Assistance
I am writing to bring to your attention an ongoing issue I have been facing with the WooCommerce Sync feature in Zoho Analytics. Initially, the integration worked seamlessly during the first import; however, subsequent autosync attempts have consistently
Commenting report records
Hello, I have a request I don't exactly know how to answer it, and may be not with analytics. I'm getting daily 3 emails with excel sheets attached and inserted in tables. I built a new SQL table aggregating all 3 tables (3 SELECT). Then a report is build
CSV Exported data includes $ symbol for currency column
Hi, When I export a table or view (query) to a CSV file and the table contains a column that is of currency type, the "$" symbol is included in the export. Can this be removed? The CSV file feeds into a database and short of writing a script to remove
Grouping of Dates in Zoho reports needs option for monthly, quarterly, and Yearly
When trying to group records by dates in Zoho Reports, there is no way to group by month, date, or yearly, Any Ideas of how to do a work around?
[Upcoming Webinar] 7 BI trends to watch in 2024
BI and analytics is increasingly taking center stage, as we generate and interpret business data like never before. And with the recent breakthroughs in AI, the BI space is witnessing a stream of futuristic capabilites that are transforming data into
Questions about ZOHO Reporting
I am looking into integrating reporting into an existing site for reporting. Have a couple questions about zoho reports. 1) Can zoho reports create a paragraph of template text that has embedded data from the database. For example, the following text would be a template but the numerical data would be plugged in from the generated report data: The percentage of international widgets increased from 59.4% in the 2005/6 Survey to 60.1% in the 2012/13 Survey. Average domestic widgets increased from
How to publish and share portals?
Portals are an advanced way of data storytelling. In this video, you will learn about how to publish and share portals on Zoho Analytics.
Next Page