Help! Zoho Analytics not working!
The workspace areas show up but when I click in a workspace the following error is coming up: Please fix ASAP Sorry!! Unable to display this page Sorry an unexpected error occured when performing this operation. The error has been logged and will be looked into...................
CRM User Table
Respectfully requesting you add the ability to sync the entire CRM Users Table including Custom fields as part of the CRM - in other words, under Data Sources, Edit Setup, please show the User Module and let me select the fields to sync. Thank-you
Standarddeviation of distinct values?
Hey there, I want to get the average days between orders of a customer. stddev(days_between("Due_Date")) works just fine. However, some customers have multiple orders on the same day. Is it possible to only include the distinct values in the calculation? stddev(distinct days_between("Due_Date")) doesn't work in Zoho. Thanks in advance!
[Webinar] Financial Analytics: Empowering businesses at every stage of growth
Hi there, In a data-driven world, contextual business insights are integral to business growth. At every stage of a company's journey, greater and faster access to insights can help generate new business, and improve profitability. One of the key business
New Features rolled out on Oct 06, 2020
Switch Chart Axis Dynamically Interactive capabilities of charts has been further enhanced with the new Switch Axis feature. Now you can switch the X-Axis column dynamically as required and view the chart in different dimensions. Click here to learn more. Set Alternative Text for Web URL in Grid Views From now on you will be able to display an alternative text for Web URL columns, instead of actual URLs, in the Pivot Tables and Summary Views. This can be set as part of the column formatting,
Flatten a table
Is it possible to flatten a table that I'm creating by an SQL query from another table? For example, I have this table: 1 A C D 2 B C E F 3 C D E I would like to turn it into this table: 1 A C 1 A D 2 B C 2 B E 2 B F 3 C D 3 C E
Filter Multiple Dates
Is there a way to use a filter/ slicer in a dashboard from one table to filter/ slice another table in the same dashboard? For example, Table 1 has dates from 2018 to 2019. Table 2 has dates only in 2019. In my dashboard I am using a date filter/slicer from Table 1. Now I have Table 2 in the dashboard but when I use the filter/ slicer from Table 1, Table 2 charts do not slice correctly. The data is wrong. I cannot create a lookup field between dates in tables. Is there a SQL statement to create a
[Webinar] What's New in Zoho Analytics: Q3 '20
Hi there! Artificial intelligence (AI) is developing at breakneck speed across multiple business functions, seamlessly weaving intelligence into the fabric of any organization. Keeping intelligence at the heart of analytics, we've beefed up our augmented analytics capabilities to meet your evolving business needs. And now we're back with another edition of What's New in Zoho Analytics ! Join us to learn about the new and exciting AI enhancements and functionalities we've built into the platform,
Adding a New Row
It would be great if when you add a new row, it put the new row at the top of the sheet and not at the bottom. Thank you. Gloria
"Open in new tab" appears in admin instance but not users
I have several dashboards that contain one or more Tabular Reports. If I view the dashboards in View Mode from my admin account, in the upper right hand corner of the report there are two icons - one that displays a tool tip on rollover "Export" and the other "Open in New Tab". However if I view it from a user account, only the "Export" icon is available. The "Open in New Tab" is of much more use to me in most cases than "Export" because I have a lot of conditional formatting applied to the table
Workdrive sheet error "deleted or does not exist"
I've been connecting multiple Workdrive sheets to my Zoho analytics account to create client dashboard reporting. All sheets have been created exactly the same. Most of the sheets are loading fine. But I have 2 or 3 that I repeatedly get a message that the sheet doesn't exist or has been deleted. Has anyone else experienced this or know how to fix it?
Widget for Latest Date in Data
I have a series of data in Zoho Reports and 1 of the columns is date. Is there a way to make a widget that will report the most recent date in that data? I can't seem to get it to report that, just the "count" of dates in that column. Thanks!
Tip of the Week : Moving Calculation
With some datasets, you may find it difficult to comprehend the general trend. This is because the data points can fluctuate widely. Take for example website page visits, ad impressions, or stock prices. They vary continuously, and this is where Moving Calculation can help you see the trend more easily. Moving Calculation averages the values over a specified time span, with a more smooth curve. The below recording shows how you can create a 30 day moving average curve. The summary function selected
Dynamic Average in Threshold
Hello, I have a graph that shows the total count per each as the Y-Axis and the dates as X-Axis and have some job types set as Color. For some reason when I use the threshold feature in Zoho Analytics, I get a different average from what I manually compute. As you can see from this graph below, the average that zoho gave me for the whole table is 4.33 but if I compute it manually (117 total count / 3 job types = 39 / 10 no. of months = 3.9). I wanted to use Zoho's threshold feature and select your
Ask the Experts #13: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We're hosting the online community event Ask the Experts #13 on 23 September 2020 between 05:00 AM - 10:00 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar. This Q&A discussion happens right here on the online community forum. To participate, post your questions as a comment
[Webinar] Power up your Unified Business Analytics with robust Data Pipelines
The ever-increasing rise in the adoption of business apps has opened up opportunities for organizations to gather data on an unprecedented scale. But how can organizations put this data to effective use? Unified Business Analytics is one of the key data strategies to help organizations unearth end-to-end business insights from multiple data sources. To enhance the functioning of this unified ecosystem, data pipelines play the crucial role of feeding enriched data into the system. Join this webinar,
Merging User Filters
I have two different values with the same name in the data. When plotting the graph, if a take average value on Y-axis I get the average of the two similar name values even though their other data are different. Therefore, I want the filter to show values as in below attached image 1. Currently my filter shows values as in image 2.
Report of the Week - Team Performance Report
This week we will see how to create a performance report for each sales agent, based on your CRM data. This will help you monitor your team productivity, and identify your top and under performers. Here, we will use Zoho CRM data as an example. This can also be achieved in other CRMs like Salesforce CRM and Microsoft Dynamics CRM, by slightly modifying the queries. To create the Team Performance report, you need to create the following Query Tables. Customer Start Date Invoice and Recurring Month
"Stacked Bar is not possible" error.
We are getting an error message when trying to embed a stacked bar chart in a web page. This bar chart views fine on the Zoho Analytics page, but when it is embedded it converts over to a scatterplot chart. The message displayed before the chart finishes is "Stacked Bar Not Possible as there are more data points. Online line or scatter chart possible." This seems like an error since the chart displayed just fine on the analytics page. Is there a way to fix this?
Formula - calculate Avg per day
I have Monthly $ amount and Month fields I'd like to calculate $ amount / month days = $ / day i'm able to do it on excel, but not familiar with Zoho formula, could anyone give me advise please, thanks!
Create Aggregate Formula SUM Distinct values based other column
Hello everyone, I have two tables, one with the records of LEADS with a key of Channel/Month and another table with the TOTAL COSTS with one occurrence per key of Channel/Month. I basically need to create an aggregate formula that allows me to calculate the TOTAL COSTS per sum(LEADS) (basically divide one by another). The issue is that on the dashboard Zoho Analytics basically replicates the TOTAL COSTS for each LEAD, turning the formula useless. Is there any way to create a SUM function that only
split y-axis (or any axis) by attribute and dimension
this idea is based on how tableau treats axis and the ability to split an axis by an attribute. example: - i have 3 companies and i want to see the running total of widgets they purchased from me over time - if i set up the x-axis with date and the y-axis with widgets purchased and running total i can see the total widgets purchased over time, great - now to see it per company, this is not possible - in tableau for reference, if i were to drop an attribute on the y-axis ahead of the # of widgets
Looking for help with Zoho Analytics Dashboards
We are looking for some consulting help with Zoho Analytics dashboards. Someone who is good in SQL queries as well as in reports/dashboards. The need is immediate. Thanks, -Naveen
Why do generated Xero Analytics aggregate formula default to $
I've just started using Zoho Analytics and have connected to Xero. Seems to be working ok, but annoyingly all the auto-generated Aggregate Formula are set to use $ as their formating, despite our Xero being in £. All the tables have GBP as the currency, it's just the aggregate formula that are wrong - but as most reporting (charts) use the aggregate formula, every chart has $ rather than £. I've worked out how to change this on a case by case basis, but it's a pain to have to do it for every one.
Zoho Analytics and Creator
Has anyone done integration with Zoho Analytics and Creator? Basically, we are creating a premium edition of dashboards using Zoho Analytics. These dashboards are going to be exposed to users through Zoho Creator. People should be able to define multiple set of criteria and then should be able to see Zoho Dashboards by passing these criteria to Zoho Analytics.
New Features rolled out on Sep 03, 2020
Expiry Date for Private Links You can now set expiry date for the link generated for a view, using Access without Login permission. After the said date, the link will expire automatically, and the view will not be accessible. Option to Request Access A shared user can now use the newly introduced Request Access option to request for read permissions for a shared view. When a shared user tries to access a view without proper permission, they will be navigated to the access denied page as shown above.
New Features rolled out on Aug 25, 2020
Advanced Analytics for Instagram The Advanced Analytics connector for Instagram enables you to analyze your user traction and account performance in detail. It allows you to slice & dice your Instagram account data and get insights on your followers (age, gender, and place) and how popular is your brand. This integration includes 45+ prebuilt reports and dashboards over your Instagram data to help you jump start your analytics right away. Click here to learn more. Advanced Analytics for Sage
Most recent Status created date
Hello, I need to create a report where i only have the most recent Status (according to the date) with the the comments etc. Below is the an example of the data I have: Candidate Name Current Job title Client Postilng title New status Created dated Comments John Smoth CMO Nobody xxx Shortlisted 2020-06-22 12:14:42 good candidate John Smoth CMO Nobody xx Interview 2020-06-26 11:20:16 move through process John Smoth CMO Nobody xx On hold 2020-07-03 14:36:16 Hiring freeze I need to have a report with
Jira Integration
Hello, I see in the help pages that it is possible to create an integration between Zoho Analytics and Jira Seoftware, but I cannot find it in the Data Sources. Is this integration only available in the On-Premise version? No other way to achieve this with the cloud version? Thanks, M.
What does the Default Function column do when creating a new table?
What does the Default Function column do when creating a new table? Can it be used to default the value to today's date? Ultimately I would like the value in the field to default to the current month - is that possible?
Total Resolution time / no comprendo como esta expresada la información
Tengo una tabla dinamica que construyo con informacion de Desk, el campo Total Resolution time no se como vienen expresado en minutos horas. La tabla suma una serie de tickets en un periodo de tiempo y usando el campo Total Resolution time me da algo como 245.21265586 ?? no entiendo esa informacion. Mi idea es calcular el tiempo en horas de todos los tickets atendidos en ese mes.
Ask the Experts #12: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We're hosting the online community event Ask the Experts #12 on 20 August 2020 between 05:00 AM - 10:00 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar. This Q&A discussion happens right here on the online community forum. To participate, post your questions as a comment below
Tip of the Week - Cascading User Filter Behavior
"I have a 'Sales Report - Pivot View' having Region, Product Category, Product, Year, and Sales data. I want to provide Product Category and Product values as the User Filters. The Product values are interlaced with the Product Category values, hence
Difference between DATEDIFF and DAYS_BETWEEN
Hi what's the difference between DATEDIFF and DAYS_BETWEEN ? I only want to count days, not time I can't work out what one I should use
[Webinar] 3 steps to powering your Marketing Life Cycle with Analytics
Hi there! New advancements are taking marketing technology to the next level. The marketplace is flooded with tools to harness technology to drive business results. However, deployment is no guarantee that businesses will achieve their marketing goals. A business must be able to build a layer of mission critical insights over its marketing life cycle. Join this webinar to learn how analytics is powering the 3 stages of the marketing life cycle with business insights. Register now. And don't worry,
Zoho Analytics Dashboard to Zoho CRM
Hello Guys, Anyone can suggest if we can add the Zoho analytics dashboard replacing CRM one. I know we can have a web tab for achieving this but we wanted to see that on Homepage of CRM We know this is not practical to ask this question after working with Zoho from long time. Best Regards, Ram Adarasupally
Zoho Analytics vs Zoho Campaigns - Inconsistent data
Hello, I've run a few Campaigns via Zoho Campaigns (different Distribution Lists). I had a few Unsubscribers. I've tried to use predefined Zoho Analytics report - Unsubscribes (Zoho Campaigns) to get an exact list of names for all the campaigns run. However, from what I see, it shows me a different number of Unsubscribers from Zoho Campaigns (direct check). The same applies to a few other reports - data is inconsistent. I did synchronization before comparing the numbers. Could you please explain
Text "widget" on a dashboard
Hello! Is there a way to display a widget type block that pulls from a specific field in the database of either text or a date? We are creating a quick glance customer dashboard with an account filter, and would like to display 2 different text values from their Desk Account properties. Thanks!
Listing of Date Range using MySQL
Hi is there a way on listing up a date (Within a range) using MySQL ?. Such that we can populate it up. Example |date | Active | Terminated | |--------------------------------------| |2012-02-10 | 15 | 9 | |2012-02-11 | 11 | 1 | |2012-02-12 | 16 | NULL | |2012-02-13 | NULL | 22 | |2012-02-14 | 1 | 11 | |2012-02-15 | NULL | 5 | |... Until |2020-08-12 | 19 | 77 | ---------------------------------------
Graphing Creator Subform data in analytics
Hello, I have a question on how to graph the data in a subform properly. I want to drill down the data based on one field in the subform such as the equipment name and I want that field to be displayed in the legend. But the name of the equipment is not a number value instead I am graphing values associated with that row in the subform; therefore the legend contains the name of the recorded values as opposed to the name of the equipment. Is there a way to graph number values in a subform row that
Next Page