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
Zoho Analytics sync period on "standard" plan
The pricing page of Analytics claims that the data sync interval is hourly without pinpointing specific applications. The shortest interval on the Data Setup page for data sync settings is "3 hours". Is the info on the pricing page incorrect or are there some other settings for the data sync setup which will allow us to set it to "1 hour" ?
MongoDB Integration Data Sync
I am currently using the MongoDB integration for Zoho Analytics. The only issue I'm having is that fields that are arrays do not sync in Zoho. It would be great to have an option for each table to unwind arrays if needed so that data could sync as well.
What's New in Zoho Analytics - March 2024
Hello Users, We are back with the latest update and enhancements in Zoho Analytics to improve your experience. Read on to learn more about what's new in Zoho Analytics. New Database Connectivity We've added two new database connectivity options: HFSQL
Change language dynamically
Hi, Is it possible to change the language in Zoho analytics without changing the user? Maybe there is a parameter in the url to be able to do it? thank you
How to work on separate files created on different dates
I have different set of tables updated on different dates Table 1 - Location 1, Work Done %, Date A - Location 2, Work Done %, Date A - Location 3, Work Done %, Date A - Location 4, Work Done %, Date A Table 2 - Location 1, Work Done %, Date B - Location
Why do I need to check for null fields when excluding fields with certain content?
If I get all records and use WHERE "Lead Source" != 'Webinar' my report removes all records where Lead Source is Webinar or is null. It removes null fields. If I want to just get all records where Lead Source is not Webinar, I need to use this WHERE ("Lead
Merge Pivot Table Columns to count as one column
I am new to using Zoho Analytics and I am trying to run some simple pivot tables. Basically I need to know how I can merge columns together so I can count them as one. We use Deal stages to track a record progress. Some deal stages need to be rolled up
Combining two reports
I am a Microsoft Access Developer new to Zoho Analytics. I ran into an issue where filter two sets of dates cancel out one of the other. For example, I have client Start Date column and a client discharge date column. When I filter the start date and
Zoho Survey Table: "Respondents", Column: "Survey Modified Time"
Hello there, I wonder what the time is in the Respondents.Survey Modified Time column. This cannot be the data from the survey, as the two data are not the same: However, it cannot be the time at which the user last edited the survey, it generally cannot
Zoho Survey Table: "Surveys", Column: "Type"
Hello there, when creating a query in Zoho Analytics, I noticed the "Type" column in the "Surveys" table (table was automatically created by the sync between Analytics and Survey). It only ever says survey... I wonder what this information is even used
Chart background color
How can I change the background color of a chart? Probably a silly question but I have tried several things and can't seem to figure it out. Our app has a grey background color throughout and the charts have a plain white background and it sticks out.
Same Year filter for two date fields
I have a report that includes a FosterIntake Date and a FosterDischarge Date. I want users to view the number of youth that entered the program this year (2024) - Year of FosterIntake, and the number of youth that were discharged from the program this
Inverse Scoring Results
I have a set of 6 text choices and they were ranked by users from 1-6, 1 being the Highest and 6 the lowest. I am trying to calculate the inverse scores and display them in a chart for all the respondents in the survey to show which answer had the highest
Importing Google Sheet - date format problems
I have a Google Sheet with a "Date" column and its format is set to yyyy-MM-dd. When I create a table in Zoho Analytics and import this sheet, the preview screen shows the Date column format as "dd MMM yyyy HH:mm:ss" (e.g., 28 Sep 2023 00:00:00). When
Changing Ownership of Zoho Analytics
How do I change the owner of Zoho Analytics
[Webinar Announcement] Transforming raw data into actionable insights using data visualization
Are you looking to maximize the impact of your data insights through effective data visualization practices? Look no further than our upcoming webinar on the best practices for visualizing data with a modern BI platform. In this webinar, we'll cover how
Access Data Source from Another Workspace
If there a way to use data or a query from another workspace in Zoho Analytics? Thanks Simon
Plot a count of records during a date range
Hi all, I am far from a SQL expert, but this feels doable and I just don't know how. If I had a table that looked something like Stage History.. Record Id Start Date End Date Stage Duration (Days) 11111 10/01/2020 10/21/2020 Needs Analysis 20 11112 09/20/2020
Gantt Chart - Zoho Analytics
Are there any plans to add Gantt Charts capabilities to Zoho Analytics?
Report: Show data based on changes over last time period? Ex: This month to date vs. Last month to date
This might be a complex question, but I was curious if it is possible to do the following: 1) I would like a chart that can compare data with the following date ranges. This month to date (meaning all of November through the current date, for example
Query doesn't refresh if subquery value change
Hi Zoho People, I run through a simple problem of a query not being refreshed. I have a table called "Params" with a column "Mois". The table has a unique row with the value of say "8". I have written this Query statement : SELECT "Date", "Qui", "Jour" , count(1) 'Nb Vis' FROM "Visites" where month("Date") = (select "Mois" from "Params") group by "Jour", "Qui" This statement runs without problems and reports all rows whose date is the 8th month. If I update the table "Params", changing the value
Multiple Left Joins Causing Duplication of Data
In Zoho Analytics I have an SQL Query that has multiple Left Joins. These Left Joins are causing some duplication of data, which for the most part is okay, as I can use a distinct count to collect data between certain things. I am trying to display some
Market Basket Analysis
Has anyone successfully done any market basket analysis / measuring product lifts in Zoho analytics and if so, how did you do it?
[Product Update] Changes to Zoho Analytics Integration with X (formerly Twitter)
Dear Customers, We would like to inform you about some upcoming changes to our integration with X (formerly Twitter). As X has requested all users to migrate from Version 1 to Version 2 of their APIs, we are revamping the Zoho Analytics integration with
I am unable to get details of particular channel.
I see the following error. https://cliq.zoho.com/api/v2/chats/{chat-id}/messages?fromtime=1546344120000&limit=1000 { "message": "Sorry! Looks like you are not part of this channel.", "code": "not_channel_user" } Also, I notice that I am not able to view
Inventory Remaining Days
Hi, I would like to know if there is a way to have a report that is done automatically that shows how much days there is left for a SKU. This would be the formula : ''Available Stock''/(''Average sales per month for last 3 months'')= remaining month for
Joining the same table several times?
Hello there, a (Zoho CRM) table is given with, among other things, two columns that have a company ID. The base table therefore points twice to the company table. I have set up the lookups accordingly. Base table with "CRM_Unternehmen_ID" und "CRM_übergeordnetes_Unternehmen_ID":
Create a report/chart with differents paths and joins
Hi there, I'm having a hard time trying to join tables as needed to create a proper report. I would say that my use case is quite basic, I'm using (from Desk) the Tickets, Tasks, and Agent tables. I want to list all tickets with a custom boolean field
[Upcoming Webinar with Industry Analyst] GenAI in BI
In today's BI and analytics landscape, data reigns supreme, and AI is transforming the way businesses derive value from raw data. Of all the facets of AI, GenAI is further democratizing BI, enabling businesses to build a more sustainable and scalable
Zoho CRM Sales Orders and Products -> Report which products are sold in a period
Hi, How can I create a report (in CRM or Zoho Reports) in which I can use Sales Orders and the Products registered on those orders. It looks like there is no link between the 2 tables in the database while in CRM it's presented as there should be a link between the tables. Anybody any idea how I can combine these 2 tables so I can use them for reporting? Thanks Frank
There is no link between Deals and Projects in Analytics
Hello there, I am trying to link Deals with Projects in a Pivot view on Zoho Analytics. However, there is no relationship, yet on CRM there is a relationship. As you can see below, there is no link between them: However, on CRM, if you go into a Deal,
Error while importing an excel sheet to Zoho Analyitcs using PHP Library API
We are facing issue when we are trying to upload a csv file to zoho via the api integration (version: "2.1.0"). Organisation ID: 679207784 Workspace ID: 1861560000007540051 View ID: 1861560000020340002 We have already contacted your support and they requested
Row size exceeded the allowed limit.
We have been uploading data to a Zoho Analytics dashboard using a very simple pipe, OneDrive with an Excel doc. Since today we are unable to update the set, and get the error "row size exceeded the allowed limit." Assuming they meant the data allowance
Automatic Left Aligment for Formulated Column in Pivot Table
HI, From last 3 days, all the pivot table where we created a column with formula is automatically setting left alignment and very hard to change to right aligment. some time it take morethan 10 attement to change the format in setting option to but fail
KPI Widget - last month sales vs same period last year
I would like a KPI Widget that might compare data with the following date ranges: This month to date (meaning all of February through the current date, for example the 14th, if today was the 14th. So Feb 1-14th 2018)vs. last year this month to date (Showing
Sort/Filtering on List of Import Tables (Data Sources)
I would like to see at least some sorting (filtering would be nice too) in the 'Data Sources' tab, on any given data source, where you are provided a grid of your imported/synced tables. This would make sync troubleshooting and analysis much easier.
Understand Customer Purchase Behavior and Boost Sales with Market Basket Analysis
Delivering a personalized purchase experience is the key differentiator for businesses to increase sales and brand loyalty. Market basket analysis, also called affinity or association analysis, is a data mining technique that helps discover significant
Zoho Campaigns Not Syncing in Analytics
I am trying to sync Zoho Campaign data to Zoho Analytics and when I hit sync now it just says 'Sync in process' and has been doing so for almost a day now. Can someone help me fix this issue?
Adding variables to a formula column
I have records that have a start date, end date, and funding for a year rate. I am trying to write a formula that will read how long the record was active in months and give me the rate for that period. The only thing is, if the start date happens on
Next Page