Adding Amazon S3 Data Source
I'm trying to add an Amazon S3 data source but I'm getting an error "Failed to fetch the buckets. Reason: Access Denied" Our dev team only granted me access to a certain path and not the entire bucket, so could that be the reason why I'm failing to add
Displaying total seconds as HH:MM:SS in widgets
Hello, I have a table that contains all of our call data including call length in seconds. I've used the sec_to_time function to convert the seconds to HH:MM:SS format within the table but I would like to be able to aggregate call length and display in
% Of Year Gone By in Report
Hi! I want to make a widget or a report that tracks with what % of the year has passed so far for task management. Would I need a dataset with this info to do this, and if so what would it need to contain? The data I work with atm involves tickets that
Zoho Analytics
Hi Guys, seems Zoho Analytics is down Super slow loading times
Sharepoint Excel synchronization with Zoho Analytics
Hello, Is there any possibility to synchronize an Excel File on Sharepoint via Zoho Analytics? OneDrive is user-dependent and therefore problematic. Best,
Sorting Legend in Stacked Chart
How can I sort the legend in my stacked chart from the highest to the lowest value? Refer to the attached screenshot.
Filter modification actions
Is it possible to filter the actions when seeing the modifications done by someone? Context: I use "Modified by" to check who was the last person modifying the ticket however, I'm only interested if they modified the ticket in form of a reply (email)
API request problem
Sou brasileiro e não falo em english, me desculpe se a gramatica estiver incorreta. Estou tentando consumir a API do Analytics Zoho para enviar dados para uma tabela. A ideia é fazer uma rotina que será executada todo os dias para enviar os dados atualizados.
Problema com a API do Analytics Zoho
Estou tentando consumir a API do Analytics Zoho para enviar dados para uma tabela. A ideia é fazer uma rotina que será executada todo os dias para enviar os dados atualizados. Porém quando vou tentar fazer a requisição dentro da minha API, ele retorna
KPI Widget with dynamic Group By
I've created my KPI comparison widget with a Group By "Month" but I want to know if I can dynamically group it based on the date range? For example, my KPI widget compares the current month vs previous month (primary value, secondary value and the difference)
zoho the length of the null parameter is greater than the required length
analytics is giving me back this error. It only happens to me on a computer. i can see and apply filters correctly on other computers or zoho accounts
Formula Column cant be used (doesnt show up)
I created a new formula column inside the ticket table (zoho desk sync). If I create new queries, the new formula column can be used: If I create a other thing like a tabular view, the new column doesnt exists... :(
Remove fiscal year from date filter
When adding a yearly or quarterly date filter to my dashboard, I only get the option of fiscal years. How can I get the actual year, 2021 or 2022 in my date filter, and not the fiscal year of 2021 and 2022?
How to find ZohoAnalytics OrgID?
Hi reader, I hope you are doing well. I've been trying to work with the Zoho Analytics API library and have has no problems with the auth and token refresh steps, very clear to use! However, for actually interacting with ZohoAnalytics itself through the
Making a graph from a pivot chart
Is it possible to make a graph out of a pivot chart?
Custom Query: Get last weekday (Sunday) of month in timestamp
Hello, I need to select the last sunday of the month of a given timestamp: Example: - Input: '1991-03-12' - Output: '1991-03-31' How can I do this? Regards, Sven
Created at Month (Relative) Filter
Hi, I'm having an issue with the 'Created at: Month' filter when it is set to relative. Instead of pulling data that has been created this month (April 2023) it is showing me data created in April 2022 when this filter is used. I assumed that this filter
Add a row in Analytics
I've been trying to add a row in Analytics using the below code. orgId = "-----"; workspaceId = "----"; viewId = "----"; headersMap = Map(); headersMap.put("ZANALYTICS-ORGID",orgId); columnsMap = Map(); columnsMap.put("User ID","Hello"); columnsMap.put("User
[Upcoming Webinar] Driving product usage and growing revenue using embedded analytics
Hi there! Today, we're seeing a growing importance for contextual analytics, as software vendors rapidly leverage embedded analytics as a key business competency. By providing deep analytical capabilities in traditional workflows, software providers are
【ZohoAnalyticsの質問】複合グラフでの2軸のグラフ作成または別手段の表現方法について
現在ZohoCRM、ZohoCampaignsで管理している2つのデータについて、 相関関係があるかをZohoAnalyticsの複合グラフで表現したく苦戦しています。 データは下記のような2つのものになります。 1.母数が1,000~100,000になるCampaignsのメール配信数 2.母数が1~100ほどになるCRMで管理しているコンバージョン数 Campaignsでメールを配信した後にCRMのコンバージョンが伸びるので、 それを複合グラフで表現することで配信後どれくらいの期間コンバージョンが増えるのかや、
New Features rolled out on Apr 03, 2023
New Business Application Connectors We are excited to announce the release of two new business application connectors. Advanced Analytics for Odoo Advanced Analytics for Odoo enables you to gain a complete view about your business operations. It helps
How to display ZohoSurvey question text and answers in ZohoAnalytics
I am using ZohoSurvey to send surveys to my customers and get responses, and I would like to create a report in ZohoAnalytics that shows the survey questions and answers. In addition, since the survey questions are different each time, I would like the
Formatting and Displaying Time in Zoho Analytics
How do I format a column in my data set to correctly display time or duration? I import the data every day from an external Excel spreadsheet, and the format in the Excel sheet is "hh:mm:ss" but when I import it into Analytics it's formatted as "dd mmm
Scheduled Emails Failing
We've had multiple scheduled emails fail to send in the last 24 hours. We get a "Email schedule failure notification" email but no indication of what the problem is. Why have these scheduled emails started to fail?
Refreshing Zoho analytics queries
I have one master table and multiple child tables derived from that table. If i update the master table or create new master table and change reference of this new master table in the child tables, it throws error : The table 'XYZ' does not exist in this
[Product Update] Supporting Notes data in Zoho CRM - Zoho Analytics Integration
Dear Customers, We are glad to announce the support of Notes data in Zoho CRM - Zoho Analytics integration. Please access the Data Sources tab in the left pane of your Zoho Analytics workspace and edit the Zoho CRM integration setup to select the notes
Task/Notes
Is there a way to include the lead "notes" field to a lead task/activity report?
How to I report on CRM Notes related to a custom Module?
I have a custom module (called Agreements) that I'd like to show the last Note added to the CRM record. As far as I can tell, Zoho Reports allows you to import custom modules, activities, events etc, but not Notes. Does anyone know how to do this? (I want to create a tabular report, one Agreement per line with the last Note as a 'Comment' column at the end).
Is Zoho Reports Advanced Analytic Add-on to sync NOTES module into Zoho Reports available now?
Is Zoho Reports Advanced Analytic Add-on to sync NOTES module into Zoho Reports available now?
Can I sync "Notes"module from zoho CRM to analytics
Hello there, We are sync'ing zoho crm and analytics in the workspace. However, I cannot find the "Notes" module option in analytics sync set up while there is a "Notes" module in zoho crm. I would like to do some analysis in zoho analytics, however this
Notes in integration with Zoho Analytics
Will the "Notes" field in CRM be available to upload into Zoho Reports so we can add notes as a feild in the reports?
[Upcoming Webinar] What's new in Zoho Analytics: Q1 2023
Hi there! Are you looking to level up your BI game and stay ahead of the analytics curve? Look no further, as we are back with another webinar on What's new in Zoho Analytics for Q1 2023! Register now In this webinar, our analytics experts will discuss
Composition graph combined with a line graph
I want to build a combo graph with a stacked bar and a line graph together but for some reasons zoho analytics won't let me do it. It would be nice to have this feature in future.
Filter by Date where Date is NOT EMPTY or blank
I'm trying to filter a chart but I need to return results where the date is NOT EMPTY or blank. I can select all the years like 2022, 2023 etc., but future dates might get added in which case I will need to edit the filter again to include those dates.
Enable to interact multiple graph at time
We have observed that while creating dashboard we could not find the interaction options with multiple graphs at a time
Use data from analytics to create a form output
Hi On our analytics tables we collect data (narrative and other pieces of data). I would like to turn some of that data into an output that could populate a form-like document ie place specific fields in specific places on a dashboard-like output but
Dates Skipping when value is NUll
I am trying to combine two tables so I can create a burndown report for marketing budget One Table is "Marketing Burn Down Budget - Daily 2023" which is just a table that contains each day of the year, and starts at $500k then drops incrementally each
Duration format when importing data
I need to import time duration data into Zoho Analytics, but it says my format is incorrect. The format in my Excel file is hh:mm:ss and the format in Zoho Analytics is %H:%m:%s What do I need to do to get this working?
How do i create Target sales objectives?
Hi Guys, I'm hoping someone can help me with a report I'm trying to build. We have a sales journey for our salespeople in this order: Apps Passed Packaged Offered What I need to do is create the current month's KPI based on the previous month's performance.
Add a zoho analytics workspace as a data source in Zoho Analytics
Given the large number of data sources that analytics can support, it would make sense if it could support its own data sources. eg get data from other analytics workspaces (either on the same or different zoho account). That would allow businesses to take a subset of data from lots of existing analytics workspaces to build an executive view of the business in a new workspace. That would be an elegant solution as you could then manage user access and permissions based on each workspace. For example
Next Page