Using user filter with tabular view
hi, I would like to know if it is possible to add a filter specifically for the table view , I mean not in the users filter field but next to the search bar? thanks .
How to use absweek and absmonth to get previous week/month
I've got some case statements in my analytics query that I want to return something different based on a date being last week or last month. I can do this week or this month using absweek() and absmonth(). if i do these -1 though it just removes a day
Custom Predefined Date Range Filter?
I need to hardcode pre-defined date ranges in a dashboard. I want my user to be able to select "Year 1" or "Year 2". However, Year 1 is not a January - December calendar year, it begins on March 16. I must be missing something, because I do not see
Wrong ticket owner name imported form Desk to Analytics
I've just noticed that if a ticket used to have an agent as its owner, but now it's unassigned, as shown in that image below of a ticket with this description. But when the data is imported to Zoho Analytics, the ticket owner remains the last one before
how many maximum we can create data source in zoho analytics
How many data we can add "data source" (google sheet) in zoho analytics, example : i want create every outlet and division have own spreadsheet , so every spreadsheet must have 1 data source setting in zoho analytics
[Webinar] How a Modern BI & Analytics platform is the key to insights-driven business
Hi there, To become market leaders, organizations need to make sense of their data. An insights-driven business model helps companies make better decisions underpinned by data. In this webinar Senior Evangelist Chandrashekar LSP and a guest speaker, Forrester
Formula of Aggregated values from Different Tables
Hi, Lets say i have these 2 tables, Revenue and Expenses. I have created an aggregated formula to sum the Total Revenue which is attached to table Revenue, and Total Expenses which is attached to table Expenses Now i want to create a KPI Widget on my
Is there a way to access the ticket page from Zoho Analytics?
My Zoho Desk and Zoho Analytics are integrated, so I can analyse all my tickets data with the Zoho Analytics, but one feature I miss is a way to link the ticket data, as its ID or Subject, for example, with the ticket page inside Zoho Desk. This would
Importing newly added tables
DataBridge was installed on the cloud postgres server and is syncing well on schedule. however, we added more tables on the source DB and I cannot find a way to include these to the sync. The databridge is missing from seting-> Manage databridges Data
Zoho Analytics data upload through databridge
Hi, i'm new to Zoho Analytics and evaluating the free-trial. I want to visualise data from my local Postgres database. I installed the databridge and uploaded 10 tables that i wanted to visualise. The entire data sync took a lot of time and additionally,
Spread a Number (Hours) Evenly Across multiple days (Start and End Date)
We have hundreds of active jobs at any given time, all with different budgeted hours, across dozens of processes, and all with varying process start and end dates. Below is a table with just a few lines containing our active jobs by job number. What I
Schedule Refresh Times
When setting up a new data source in Zoho Analytics we can set a "refresh frequency" but we can not schedule the time in which we run it to run. I would like to be able to schedule the specific time(s) for my data sets to refresh. For example, I have one large data set in particular that I would like to refresh at 2:00am on a daily basis when I know that there is typically no one reviewing dashboards.
Third party embedded links or javascript
Hi working with Zoho Analytics dashboards, I have linked zoho and third party data sources, however is it possible within the text fields to add javascript or embedded links from third parties when in view mode eg dashboard is live, but a live weather
I cant create dashboards ...
When trying create dashboards I have issues: Autogenerated dashboards generate an error when trying to open. If I manually create a dashboard I don't have any options or functions to populate the dashboard. I am able to create chart views etc using
Zoho Reports - New features rolled out on Nov. 12, 2013
Support to Control the underlying data visibility Till now, when you provide the permission to view the underlying data of a report your users will be able to see all the columns of the underlying table on which the report has been created. Now Zoho Reports allows you to select the columns that has to be listed in the underlying data. By default, columns used in the reports alone will be included in underlying data. You can select or unselect required columns. With this you will be able to set
API query- how to construct
Hi, I have an API based import to Zoho Analytics from an external source. I've been able to get a query working for the /users API endpoint, and I have a working query for the /devices API endpoint- - but I cannot get the query to work in Zoho Analytics
Text formatting to black out some data?
To add some security to my I would love to be able to import (or display) only the first few digits of a data field. Is there an easy way to do this?
Periodic Pivot Reporting
I have been all of the Knowledge Base and YouTube looking for this answer. Any guidance would be appreciated. I have created a pivot report that gathers the information in a way that works for our company. The problem is the filter has to be manually
Is there a "Light Agent" in Zoho Analytics?
Hello! I would like to know if there is some kind of user in Zoho Analytics like the light agent in Zoho Desk, so it can just view the dashboards, without the cost of a regular user. This would be very helpful once my company has some dashboards that
Data Format when subtracting dates
I am trying to make a formula to measure the number of days between two dates in two different columns. In excel you would just take one date, minus the other date and the output is a number. When I use the formula "DateColumn"-today(), I would expect
How to rename the Profile name at the Data Source
Hi Team, I would like to change the name of the default Profile name (Eg. 234932677 which is from our Google Analytics). Can you please advise me any solution for it? Thanks and Regards!
Synchronization helped and getting no support
My Synchronization between ZOHO Analytics and ZOHO Finance has failed from last 4-5 days and getting no support. Every time I am getting one simple Message of "Please have patience". Worst service no ways to connect with support team . Customer care no
How to group Leads and Deals (from Zoho CRM) by week of the year in Summary Views?
How do I make the below two Summary Views? Grouped by week of the year. Leads and Deals. Columns = # of Leads created # of Leads converted # of Deals won # of Leads lost The same as above BUT they are related e.g. # of Leads created, of those Leads how
Running sum column with reversed order (showing most recent date first)
I have a pivot table showing revenue grouped by month in each row (among other things). I've added an aggregate running total as a column which adds up the revenue for each month and shows the running sum. However when I change the order of the date column
LinkedIn Ads Integration
I've read that we can add LinkedIn Ads in Zoho Analytics. We have an Ad webform where potential customers can fill out their information. My question is, can the answers of those potential customers from the webform be sent to Zoho Analytics? Are there
Can't Report On Revenue from Zoho Desk Tickets
I'm trying to create a report that shows me all the revenue generated from Zoho Desk tickets. I have them linked and can see the estimates/invoices inside the Desk ticket and also the ticket and estimates connected in CRM, so I know they are being linked
Zoho Desk - Ticket ID field data type change in Zoho Analytics
Dear Customers, This is an announcement to the Zoho Desk integration users in Zoho Analytics. With reference to this post in Zoho Desk, the data type of 'Request ID' (Ticket ID) field in the 'Tickets' module will change from 'Number' to 'Plain Text'
Zoho Analytics with Facebook API
I connected my business's facebook account to Zoho Analytics. I am trying to make sense of the data, but I need someone to provide an assist. Looking at the premade "Page Insights" dashboard - The first column presents "Impressions" and "Post Impressions".
Sales by category - relational data model
I have a fairly 'standard' ecommerce data model (See attached for full detail) Product - id - name Product_Category - product_id - category_id Category - id - parent_id - name - path Order - id Order_Item - order_id - product_id - amount I'm trying to
Get the Customer's Owner from Zoho Books
Hello, In Zoho Books we can assign a customer owner for a while, but in Analytics we cannot access this owner because the database has not the option to retrieve it. Is there too much to ask to have this data avaliable to sync?
[Webinar] 5 Growth Drivers a Modern Analytics Platform Delivers
Hi there, With a massive explosion of data across sources, businesses have embraced analytics to extract meaningful insights out of their data. While many organizations have adapted to modern BI platforms, some are still in their very early stages of
Articles with the highest sales for each year --> Filter?
I've got a table with the categories "date of sale", "articles" and "sales". Now I'd like to see only the top sale article for each year. There are twenty or so different articles and the years are 2000 - 2004. So far I set the "date of sale" fx(year) on the x-axis and the "sales" fx(sum) on the y-axis. Then I set the articles for the color-option (that option next to the axis). Now I've got a bar diagram that shows all the articles for each year, so you can barely see anything there. I played with
Ranking Table
Hello, I'm currently using the top 10 filter in Analytics which is great and so I'm wondering if there is a feature where it will also show what that customer's ranking was last month (ex. Customer A is top 1 in February and top 4 in January). Somehow, kinda like how ranking charts have (billboard charts). Thanks!
Setting up a "hot backup" server
We run Zoho Analytics On-Premise, with a license for two servers, one each in two different physical locations. We run one location "primary", with the other site serving as a "hot backup" that can be switched to if something happens to the primary site.
Zoho Analytics : How to transfer "Zoho Databridge" and "Datasources" ownership
Dear Zoho Agent, I'm looking for a way to transfer "Zoho Databridge" and "Datasources" ownership but I cannot find a way or Document to achieve. Could you please provide me an information? Best Regards, Karanig Nititham
How to transpose a table in Zoho Reports?
Hello, I am trying to figure out how to transpose a table in Zoho Reports - I want to display in a Report the transposed table rather than the table itself. The Pivot function does not seem to do the trick. Any help is appreciated! Best, Jose
Extract the last Working Days information
I'm very new to Zoho and I would like to extract the past working days information from a Table of information. what is the easiest way to do this in Zoho Analytics so I can save and report on this. Thanks.
Sales Distribution Analysis
Hi, I'm not sure the best way to do this on Zoho...but here goes...! Context: we moved to a minimum order in the middle of May. Question I have is: Is there a way to show the distribution of sales by each group i.e. 0-50, 50-150, 150-250, 250-500, 500-1000,
Build segregated dashboard from different Zoho Accounts inside a unique Zoho One.
Greetings. I hope find all good and safe! We are in charge of the a few clients systems, included their Zoho One accounts. We need build a Analytics Dashboard to each client's operation. We would like to do that only on our-self Zoho One, to avoid signing-out
Zoho Analytics Map Unresolved Location
I tried plotting Map data and got an error while plotting Map DAta. Unresolved Location. I check spelling with all sources and unable to plot Aurangabad map in Map. please help me to solve this issue.
Next Page