Is there a way to sync user comments in Zoho Books with Zoho Analytics?
Hi, Is there a way to sync the comments associated with a customer record with Zoho analytics? I have integrated Books with Analytics and I cannot see a way to pull the notes/comments across for reporting. We have multiple versions of books for different companies in our group and I use analytics to consolidate financial information across all companies. For each company i have created "debtors" dashboards listing customer information such as amount overdue, last payment date, customer contact
Importing data from a cloud database using a local variable
I need to import data from a cloud database but restrict the query to records that have a value in a sequence column that is greater than the last import. ie select * from mytable where ID > MAX(local copy of ID) Is there anyway to do this, maybe with a local variable? Retrieving close to a million rows needlessly every refresh doesn't make much sense......
How do I create a custom formula field using date from another formula field in a summary report?
I've created a couple of custom formula fields in my summary report and I'd like to use these fields to create other fields showing percentages and other formulas. However when I go to the add formula section like I had previously, none of the formula fields that I created in the summarize section are able to be chosen as a column to use in a formula. What's the work around? I've included screen shots of the fields I'm trying to use. Thanks,
New Feature rolled out on April 30, 2020
Smart Data Alerts now via Slack, Microsoft Teams, and Webhook! Until now, any anomaly or change in your key business metrics were brought on a snap to you via Email and In-app notification channels. In addition to the already existing channels, new to join the line of channel notifications are: Slack Microsoft Teams Webhook Get data alerts any time, anywhere. Stay well-informed and prepared. Click here to learn more.
New Features rolled out on Jul 22, 2020
Ask Zia - our AI assistant with cool new features A set of cool new features has been added to our already smart Ask Zia. The enhanced AI assistant will now support: Ability to Understand Unstructured and Incomplete Queries: Ask Zia can now interpret grammatically unstructured queries appropriately. In the example below, although the query is not properly formed it will still be interpreted rightly as "show me sales by region in the previous year". Typo Tolerance: Ask Zia is now typo tolerant. It
Reporting
I need a report that shows deals closing by month. Right now the only date I have to work with in the reporting module is 'closing date' ... but I only want the 'month'. Is there a way to do this?
Changing the pointer of reports/dashboard to different table having exactly same schema
Is there a method to change the pointer (underlying table) of reports/dashboard to some other data table having exactly same schema?
ZOHO Reports - Advanced CRM Reports
1st Question Can I create auto-emails from the new Reports-Advanced CRM Reports module in ZOHO Reports? I have looked and cannot figure out if this is available. I want to send weekly emails out to the staff from this awesome reports module. 2nd Question Can I customize any of the ZOHO Reports - Advanced CRM Reports or are these 100% driven off of the data in ZOHO CRM? Thanks! Keep up the good work. Michael Kokernak Across Platforms, Inc. www.acrossplatforms.com
First Call register
Hello good Morning. I have the following doubt, how can I make a query in zoho anayltics to get the first call made to my leads, or is it necessary to know the record of the first call of each lead in my zoho CRM.
'Sign in with Apple' is now supported in Zoho Analytics iOS mobile app
Hello All, In the latest version (v3.2.2) of the Zoho Analytics app, we have brought in support for an additional mode of gaining access to the Analytics app. You can now sign in to the app using Apple ID by clicking on 'Sign in with Apple' option. It is now easier than ever to stay on top of your data and get deeper insights on the go. You can update the app directly from the App Store or using the link given below: https://apps.apple.com/us/app/zoho-analytics/id902365462 I have attached
Can't integrate Zoho People Time Trackers table with Analytics
Hello there, I've been having troubles integrating some tables from zoho people to analytics, particularly the time tracker tables (although theres a bunch more that don't work at all). The select square just dont work when I click on it and there's no error message. I attach a file with the problem
TASK & BUG Report
Does there anyway to produce a report that shows all tasks and their associated bugs in one report view? We need it urgently to relate both to do efficiency check
[Webinar] KPI dashboards—an indispensable business enabler
Hi there! Businesses today face an imbalance caused by the growing complexity of data ecosystems and the rapid adoption of BI. So how are companies across the globe working to overcome this imbalance and drive growth? Join this webinar to learn how KPI dashboards are becoming a solution to this imbalance, and are transforming into an indispensable business enabler. KPI dashboards help you empower teams across your organization to make better business decisions. Register now. And don't worry, we've
report
can we have the comment section appear in the report
Aggregated SumIf help?
Hi! I'd like to make a report in which I compare a client's usage data over a certain time frame against a group of clients' usage data using an aggregated formula in the Y-axis, however I'm struggling with this a bit. I have a column called "columnA" in which there is either a 1 or a 0. I then have a column called "client" (string) in which my different clients are listed. I would like to make an aggregated formula that adds up the scores of "ColumnA" for certain clients from the "Client" column,
What's New In Zoho Analytics: Q2- 2020 [Recorded webinar]
Hi there, Here's your recording of our webinar: "What's New In Zoho Analytics: Q2: '20." Watch now to learn about all the new and exciting functionalities we've built into the platform in Q2, 2020—functionalities that can further simplify the way you and your team work!
SUMIF clause not working in Groupby Query (neither CASE or IF) with Query Tables
SELECT FACT."CNT.Nombre de Cuenta" Cliente, sumif(FACT."FACT.Naturaleza ingresos" = 'Facturación Proyectos Ajenos', FACT."FACT.Subtotal", FACT."FACT.Subtotal") IngresosProA FROM "BR-Facturas-2016" FACT GROUP BY FACT."CNT.Nombre de Cuenta" Yields error: nsupported function used in the query. Please send us your query to support@zohoreports.com, incase you wish to post to our bugs database
Time Value Calculation in Pivot Data field
Dear Team, I need Time Value Calculation in Pivot Data field in Time Format. Exmpl. our calling agent calls on leads for 10 to 15 Min. I need Σ summation of Time in Hour /Min format. is there possible to do so. Regards, Subhash K
User filter for 2 conditions
I am trying to analysis Zoho Project by Zoho Analytics, i want to use user filter for 2 conditions, and conditions 2 show only the result of conditions 1. For example: Condition 1 is the Projects Name, Condition 2 is MileStones, after i choosed one or many project, i want the condition 2 show only the Milestone of the condition 1 results. Is this possible? Please see the picture for detail This picture show all of milestone in my organization, i dont want like this, i want show only the milestone
Scheduled import interval issue
Dear Sir I have a scheduled Import group of html files from google drive. the scheduled interval time is 1 hour. but the scheduled not start every one hour. One import was finished then the finished time pluse 1 hour is next import time. ie the first import start at 8.00pm and finish on 8.10pm then next sync time is 9.10pm. how can i fix it every one hour that is 8.00pm, 9.00pm ,,,,.
Pivot Table Help
I was wondering if I could get some help on a pivot table I'm building. It takes info from two different tables, a contact table and a deal table. The parent table is the contact one. I will include screenshots to help visualize the issue as well as explain it through text. So it displays a Franchisee, a Franchisee Owner, Franchisee ID, and Deal Owner as the Rows. The actual data is the amount of deals total, deals made this month, and the number of active accounts. The deal information is taken
Discard filter when data is uploaded
Hi, I have a scheduled upload form an Excel file on my OneDrive. That file is shared with several people and sometimes they apply filters, when the scheduled refresh occurs and a filter is applied only the filtered data is loaded. Is there a way to load all the data, regardless of the filter applied in the Excel file? Thanks.
Calculate Churn Rate from the beginning of the day
GIven a table: tblhosting (To achieve churn rate based on termination of services) Here i will only list out import data column 1. id (service id) 2. orderid 3. regdate (registration date/start date) 4. nextduedate 5. termination_date (the date when service ended) 6. billingcycle (free/monthly/semi-annual/annually/triennially) 7. status (Active/Suspended/Terminated/Cancelled) Using this query: Select count(id) FROM tblhosting Group By regdate - I can get total number of services grouped by date Select
Quickbooks Journal Entry and Invoices
Hello, Does anyone know if there is a way to link invoices with their journal entries? I was told to try classes but the class ID column in our invoice line items table is empty so I can't do a query to join the tables. I do know these Journal Entries are linked to their Invoices because if I visit Quickbooks, you can see which invoice the journal entry is linked too so I don't know why there's no foreign key I can use to join them when creating a query. Any advice you might have is appreciated.
Distinct Count issue with Grand Total
I have a Pivot Table report with a distinct count that is working fine going across the rows, but when it shows the Grand Total, i want it to sum the counts above it. Right now it is showing something different. This is made up data, but it represents my report. This is a report showing each customer, and how many different brands they bought. Customer Name Brand Customer.Distinct Count ToysRUs Lego 1 Barbie 1 Hot Wheels 1 Walmart Lego 1 Barbie 1 Target Barbie 1 Hot Wheels 1 Grand Total 3 The
Churn Rate From Services
Hello, I have a table ( tblhosting ) Column Contains: | Id | Userid | Orderid | startdate | Termination_Date | ProductStatus | So far I have queried 1. A total number of active products from January 2016 to December 2019 in query table 2. A total number of terminated products from year January 2016 to December 2019 in another query table How do I join them ? It comes to the problem when I join the two queried table. Such that Example: in March 2019, Total count(product ordered) is 200
Add the row number in the query result.
Hi, I'm trying to add the row number out of a SQL query result. It would be the equivalent of the following query in mysql: SELECT ROW_NUMBER() AS ID, Name AS NAME, Age as AGE FROM Table; ID, NAME, AGE ---- 1,Dan,42 2,Jo, 32 3,Jim, 35 Can this be implemented in zoho analytics? Thanks,
Number Sorting Is Wrong on Bar Chart
Hello! I need some help. I'm trying to sort our NPS reports scores by Actual Value. It does not go from 0 - 10. It goes 0, 1, 10, 2, 3, etc... I would like to know how I can display the attached chart from 0 - 10. Thank you!
[Webinar] What's New In Zoho Analytics: Q2 '20
Hi there! The arrival of the "new normal" is redefining the way businesses operate today. At Zoho, we have a finger on the pulse of these changes, as we're living them ourselves. This has enabled us to turn your changing business needs into powerful new features in Analytics. And now we're back with another edition of What's New in Zoho Analytics! Join us to learn about all the new and exciting functionalities we've built into the platform—functionalities that can further simplify the way you and
How do you group items based on occurrence
Dear Zoho Analytics Community, For a marketing report I'm working on we're tracking downloads of the content on our website. People that download will enter our CRM as Leads which will be nurtured at a later stage. We host over +50 downloads and of course people are able to download multiple pieces of content. This is what I would like to figure out. Let's say there are 5 people A, B, C, D and E. Person A: downloaded 5 items Person B: downloaded 3 items Person C: downloaded 5 items Person D: downloaded
How to fetch Vendor Bank Details i.e. Bank Name, A/c No, IFSC from Zoho Books to Zoho Analytics
Hi, I want to generate a report of Vendor Payments containing Venodr''s Bank details with Bank Name, A/c No and IFSC. But, can't see such fields in ZOHO FINANCE Data Source.
Passing Parameters to Report URLs
I was wondering if it is possible to pass a parameter to a report so you could filter based on the parameter. So let's say you have a report that has different Codes....High, Medium, Low...and you only want to show data that has a code of High. So you have a link to the report as such:- http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=1111111111111&STANDALONE=true&privatelink=2222222222&ZDB_THEME_NAME=blue&REMTOOLBAR=true&Code=None Would be good if there was the ability to pass the Code=None query
Restore data of ZOHO Analytics
I did a data synchronization of ZOHO CRM to ZOHO Analytics where I unmarked a some tables in the synchronization, this action deleted graphics, dashboards and querys in my ZOHO Analytics account. In the trash are my graphics, dashboards and querys but I can't restore. I received this error: Sorry, view(s) cannot be restored. All or some of the selected view(s) have dependency over deleted columns of tables in a integration workspace (setup pulling data from another application), hence cannot be restored.
Zoho Analytics - Conditional Formatting in a Table
Conditional formatting can be done only against absolute value and not relative value when creating a table. This is quite misleading when we are looking at data for a set of time periods. The red/green up/down arrows are all showing in comparison with an absolute value that we feed in the background and not in relation to the value of previous time period. Please suggest if there is any way to do conditional formatting with relative values.
Remove unnessary date-time from X axis
How can I remove the unnecessary date-time from the X axis and only display the date-time for actual points on the chart? With Analytics randomly filling them in, it make the chart very difficult to read (see attached screenshot).
Ask the Experts #10: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We're hosting the online community event Ask the Experts #10 on 24th June 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
Margin calculation in pivot
Hi, I'm trying to add an aggregate calculation to a pivot table to calculate margin percentage. I'm adding the following formula: sum(("Sales Price" / "Cost Price" - 1) * 100) This does not seem to be working on aggregated levels. I have for an example a sales price of 10027 and cost of 9780. The calculation ends up with a result of 87.51 (would expect 2.5). Are there another solution to do this?
[Webinar] Align IT monitoring metrics and business KPIs using Advanced Analytics
Hi there! The rapid shift in the way organizations function in the current business world is driving them towards data-driven decisions to ensure uninterrupted operations. Join this webinar to learn how integrating Site24x7 (an IT monitoring solution) with Zoho Analytics (BI and analytics software), gives you a complete overview of your IT monitoring metrics and relevant business KPIs. These exhaustive business intelligence reports and dashboards can be used to correlate data and make better business
Load all data not only filtered data on refresh
Hi, Currently I do auto refreshes from Excel files i have on my OneDrive, sometimes those Excel files can have a filter on one of its columns and when ZOHO refreshes only the filtered data is loaded into the table, is there a way that all the data from the Excel file is refreshed every time nonetheless it has a column filtered or not? Thanks in advance!
New Features rolled out on June 11, 2020
Fill Chart with Pattern Now you can apply attractive patterns over your chart to enhance the visual appeal of your chart. You will find a set of prebuilt, pattern-based palettes. You can also create your own pattern palette to apply in your chart. This feature is of immense benefit for users with difficulty in identifying colors. Click here to learn more about the Pattern Palette. Import Data from Cloud Databases into an Existing table So far, Cloud Databases were listed as data source only when
Next Page