Transfer image url from Zoho Forms to Zoho Analytics
I am storing an image in a zoho form. When I pull the data from the form into zoho analytics the image field does not import. How do I pull in the image url location or the image into Zoho Analytics.
I want to know the gross profit by sales person. How?
Kindly guide me how to know the amount of gross profit which is calculated on the basis of sales person. That means, how much is the amount of gross profit made by a particular sales person.
ZIP Codes not Available on Zoho Analytics
Hi, I'm currently trying to create a Chart Map in Zoho Analytics, but I'm struggling to get all my data points displayed because not all ZIP codes from my database are available in Zoho, even though they are valid sequences. I can't provide a specific
How can I account for business hours when measuring first response time SLA?
I am just starting to use Zoho Reports for our ServiceDesk Plus. It appears that first response time is measured over 24hr period. For example, in the Average First Response Time report and Average First Response Time by Technician. I'm hoping to get some help in figuring out how to account for the operational hours that we have defined in SDP? Thank you for your help -Mark
Analytics Portal
I have the "standard plan" and want to explore the portal option; I activated the 15-day trial but do not see the pricing for the add-on. How can I get the price under "Upgrade add-ons." Thanks Rudy
Date Filtering - Zoho Analytics
Hello, Situation: Let's say you have a table called "Contracts", these contracts have a start and end date, and a report called current contracts has been built in Zoho Analytics. This report displays a list of contracts that are "active", meaning they
Sharing reports via Cliq
Hi Team, I wanted to share my reports which I created in Zoho Analytics to specific groups in Zoho Cliq. How can I enable this feature? FYI: I couldn't find the Cliq Integration in Zoho Analytics Settings.
Solution of the Week - Multiple Organization Setup with Same Base Currency
You can use the Zoho Analytics integration with Zoho Finance to create financial statements like balance sheet or profit and loss statement easily. The integration setup can be done in two ways: Single Organization Setup Multiple Organizations Setup If
CASE function in SQL Query Table
I have 2 Data Tables coming from different sources syncing into the same workspace. I have several columns (Columns A – G) from Data Table 1 and 1 Column from Data Table 2 (Column B) that I want to show up in a Query table. DT 1 and DT 2 are joined by
Tip of the Week - Conditional Formatting Chart
Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend. Zoho Analytics allows you to
Restrict access to workspace
Hi I have a Workspace - I'd like to restrict access to this workspace to myself (the account admin) and 2 of the 5 organisation admins i.e I have workspace I'd like to keep 3 of the org admins from accessing. I don't want to change the 3 org admins to
Solution of the Week: Financial Reports with Impactful Visuals
Finance reporting is a critical part of understanding an organization’s financial health. With Zoho Analytics, you can easily create dynamic reports such as Balance Sheets, Budget Statements, and Profit and Loss Statements. Now, with the release of Zoho
Zoho Analytics Balance Sheet Opening Balance
I have recently linked our Zoho Analytics account to Xero however I have found that all the standard balance sheet reports in Zoho Analytics along with any new ones I try to create are incorrect as Zoho Analytics does not import an opening balance. How
Support for FULL OUTER JOIN in Query Tables
That's all. Thanks in advance, Eduardo
Time Format from Decimal Number to Hours and Minutes (hh:mm)
I have been using Zoho Analytics for some time now, and I have a query table that combines data from three datasheets (Calls, Desk and Projects data coming from different Zoho moduels). One of the columns contains Hours, as a decimal number, eg. 0.75
Conditional formating entire row ?
2 quick questions. Question 1. Is it possible to have a conditional from a single cell change the entire row ? Let's say for example if the column total hours is greater then 40 to have the entire row change color and not just that cell ? If not is it
Left padding integer with spaces
Hi, I have a table that contains integers. I need to left pad the integers with blanks and a length of 5 characters. E.g. Table contains following integers (data type is integer). CustKey (column) 1 2 3 In SQL, I used the LPAD function - LPAD(CustKey, 5, ' '). However, this does not add the spaces in front. It just returns the integers in the same way as the original table. However, if I used LPAD(CustKey, 5, '0') then the query correctly returns: 00001 00002 00003 However, I want the spaces - not
Error Authentication type 10 is not supported
Al conectar Zoho Databridge con Postgresql mostro el error : Authentication type 10 is not supported 2. I get this message "Authentication type 10 is not supported". How do I resolve this? Zoho Analytics uses the MD-5 password authentication method. If
How can I create a range of dates in Zoho Analytics Query Table?
Hi, I'm trying to create an auxiliar list of dates for using in a JOIN with another table as default values for the months where I have no data. I'll attach the SQL query I wrote so far, please take a look at it. The problem is that I can't do exactly
Is it possible to assign Y axis fields to different stacks in stacked bar charts?
Is it possible to create multiple stacked bar charts for individual fields? I know this can be done if you use the 'Color' option to cut a bar across a field (technically it is not a stacked bar with respect to the Y axis fields, but works in many cases).
How can I see the run time of the data sync with my google cloud db?
I'd like to get a sense of the time needed to sync the various tables of my Zoho Analytics data from my google cloud db. I can only see the last time the sync ran. Is there any way for me to see how long each table takes to fetch? I probably need to optimize
ZOHO Reports - Filter Logic?
Hi, I need a way to apply filter logics such as ((1 AND 2) OR 3). All I can see as of now is a way to enter different AND filters in the respective filter column. But how can I add an OR filter? Any advice would be highly appreciated. Mark
Zoho Reports and Dashboards Continue to not Update Promptly After Successful Data Syncs
This has been an ongoing issue for ZA for sometime now and the Support response previously has been to claim caching or DB cluster issues: https://help.zoho.com/portal/en/community/topic/report-data-and-widgets-not-showing-latest-data https://help.zoho.com/portal/en/community/topic/zoho-much-slower-than-usual
How do you append all CSV files in folder using data bridge - i.e. like excels get data from folder function?
Currently we use Excel for our dashboards with power query and power pivot. The power query dataset is set to grab all csv files in a particular folder and append them together. (as we have a folder that automatically has a new sales file added to it
Automating Excel file upload in Zoho Analytics. How to organize it?
Hi everyone. I am just getting familiar with Zoho Analytics service and some questions have arisen. For generating several reports, I am using excel file which I upload to Zoho Analytics from my computer. Basically the excel spreadsheet grows by some
Show missing data till current date only
Hello! Could you please help me solve this problem? On the Zoho Analytics chart, I need to display two metrics: cumulative sales of the current year and cumulative sales of the previous year. In the current year, there may be some weeks with no sales,
Pivot table with Text values - "Matrix Report"
User Story - As a user, I would like the ability to display textual data in a two-way table, matrix format (text datatypes, not numerical datatypes displayed as a dimension) One major feature missing from the Pivot tables in Zoho Analytics is the ability
Sort By Value Descending disappears when there are more than 2 Groupings
Hi - the Sort By feature in Table Charts is really critical and an excellent addition. However, when I add a second Groupings (i.e., Account Executive and Account Name), the option to "sort by value" disappears and only leaves "sort by label" - which
October working days not showing correctly using the Business_Days function
I tried to get the business days for October but I am getting 22 days instead of 23 days. there should be no holidays for this month. Am I doing something wrong?
Working with Zoho IDs in Sheets - Eliminate Scientific Notation
When exporting a data table to Sheets from Analytics, it seems the 18-digit Zoho record ID values get screwed up going back and forth from scientific notation. Actual ID value from Analytics: 586138000007735001 Comes to Zoho Sheets as: 5.86138000007735E17
Using the "Like" operator in Custom Formula
HI there, Can someone please explain the way to use the "LIKE" operator in an IF statement to compare strings? I have tried the following but am not getting the results I'm after. if( "CurrentStatus" like 'Rejected*','Unsuccessful','Pipeline') Thanks Matt
Compliance - ITAR
I was just reviewing your compliances, and noticed you do not have ITAR certification. Is this a certification you plan to get, if so what's the timeline? We currently use ZOHO for analytics, but some of your apps we cannot use due to your lack of ITAR
Query in Analytics for tracking Physical Available For Sale from Books
Need: a query in Analytics on which we can build reports related to Physical Stock from Books items. In Books, each item has an Accounting Stock and a Physical Stock. In the settings you can toggle the 'Mode of Stock tracking' option and we have selected
Quicker Data Sync for Zoho Apps
I know that the team has been working on trimming down the sync time for Zoho CRM. This is a huge deal and much appreciated. I was wondering if Zoho has the same intentions with other Zoho Apps. We would love to see 1 hour (or quicker) sync times for
Facebook Leads Table is not showing up in data source table list
Hi Team, We are doing facebook marketing and acquiring leads through it. So I would like to get the list of leads captured (form submissions) . We are getting the count of Form submissions in the table, but we are not getting the table for form submission.
Hyperlinks in tables and summary views
I would like to have columns in my tables that link to a specified url but display custom text instead of the link itself. For example, in Excel, Google Docs and even Zoho Sheets there is a formula to display text with a hyperlink: https://sheet.zoho.com/functions#HYPERLINK
How to know / reach a column's ID from a table in Zoho Analytics?
Hi, I'm trying to find all the views that are dependent on a column I have in a Data Table in Zoho Analytics. The issue is that I'm having sync problems with Zoho CRM because there was this field whose type was changed recently and the import error simply
Parsing of SQL query failed. Please check the SQL syntax.
I am trying to have Zoho Analytics recognize that if the a Deal is in Stage "Need Docs" it should also be counted as a Deal in the Stage "New Lead" /*New Lead*/ SELECT "ID" 'New Lead' AS "Stage" From "Deals" Where "Stage" = 'Need Docs' Union All Error
Tip of the Week - Dynamic URLs for Business Applications
Interactive data visualizations and dashboards help uncover and understand insights instantly. The dashboards created will be viewed and accessed by other organization members, so it's imperative for the dashboards and reports to be interactive. This
URL data type - Link name & link address
Hi, I have a url data type filed called "link" in a table. I currently store the url address in this field. e.g. http://www.google.com I would like to show a link name instead, e.g. "Google" - Which points to http://www.google.com Is it possible to do
Next Page