Repeat Data Rows based on Start and End Date
I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will
ERROR - Calculate Hours Remaining p/Day
I am trying to use the query to calculate the number of hours needed p/day based on the number of hours left on a job and the number of days until its due. This is just part of the total query I am writing The problem I am having is that when I code to
Unable to import data from Azure SQL due to unsupported date format
I am having trouble importing data from Microsoft Azure SQL Database. My tables have a column of datetimeoffset(3) type which Zoho doesn't identify as Date. If change the Data Type to Date manually, it will result in the following warning: "The chosen
Counting the number of times a given transition in a blueprint has been performed
Hello. Is it possible to make graphic in Zoho Analytics of the number of times a given transition in a blueprint in CRM has been performed? In this case, I want to know the number of times the transition 'Offerte verstuurd' has been performed. CRM offers
Incorrect Time in Reports
In the column I've set the column to current date. My time zone is EST, yet for some reason, if I edit a field, it's already so far ahead that it labels the cell as tomorrow (10/4 -- it's 10PM here 10/3)
Dashboard data permission based on user
Hello, We have a dashboard full of widgets, charts, ... with data from different applications. How is it possible to share this dashboard filtered so that each logged in user (non admin) only sees their filtered data in that dashboard? Picture in attachment
Dashboards not visible
Hello, I have shared a dashboard with 2 non admin users with the exactly same filter to only see their own data. They also use the applications exactly the sames way. How is it possible that one of them has 0 data in Analytics ? see attachments tha
Data type alteration issue
Hi Please help, Zoho does not allow me to change data type on sale_date column from plain text to date. Thank you.
Sync with CRM down again
Our Data Sync from CRM to Analytics has been showing as 'Sync in Progress" for over 45 minutes now. Is the sync functionality not working again?
Can not see the underlying data.
When the user is not logged in, the underlying data option is not visible. I have also enabled it from the settings. I have attached the Screen short for your reference. Before the underlying data was visible without login.
Return Anniversary Dates of staff
I am trying to query a staffing table I have set for scheduled imports into Zoho. My goal is to query all of the employees that have an anniversary in the current month. Below is the query I would write, but it looks like Zoho does not allow for GETDATE
Tracking A/B Testing Results of a Campaign in Analytics
Hi Team, I am trying to create a report that compares the result of version A and B of a campaign sent in Zoho Campaign. When I sync the campaigns to Zoho Analytics, I can't differentiate which is for version A and B. So, I would like to know if there
Backing up reports and dashboards
The help page for backing up a database says "The reports and dashboards are not backed up". OK. So, how do you backup reports and dashboards? In other words, if I want to back up the definitions of all my views, reports, and dashboards, how is this
Zoho Analytics
Hello, How is it possible to unselect "Others" in the the settings of a user filters for Actual periods. It looks like the select button is blocked and I cannot unclick it. See attachment. Thank you, Joshi
Analytics Dashboard Logged in user
Hello, I created a dashboard so our salespeople can keep track of their own KPI's. We want every salesperson to have that same dashboard BUT that the data of the charts/tables/... is updated to the the salesperson that's logged in. Also, the salesperson
Zoho Subscriptions Data deleted from Analytics mysteriously ....
I am curious if others have run into an issue I am now running into.... We noticed today that several of the Views and Dashboards in our Zoho Analytics workspace were gone. Upon further research, they were in the Trash. It says "Deleted by" our account
Report which shows tickets and bugs
Hi team,how can I create a report of extract which displays a list of tickets (Zoho desk) and any associated bugs (Zoho BugTracker)? We will use this list to review a list of open tickets against the status of the associated bugs. Thank you in advan
Analytics refresh schedule for specific time
I need to send reports out to business users in the middle of the day and at day end. These need to be sent with performance as of specific times of day 1pm and 7pm. I can set the CRM data to refresh every 6 hours but as it takes 11 minutes to update,
I want to have Different Filter For Data Column
Case 1 - I have Three columns First is Item Name , Second is ITs Stock in Hand but i want average sales for last 3 month in Third Column how can i achieve it.
Sales Objective
Hi guys, Hope you're doing well! I have one question about how to join two tables or I dont know if there is a better idea. I'm a little lost with this kind of requirement. I have to tables: Sales detail (item, amount $, salesman, category, date,etc)
Delete rows
Hi, I have in my tables 4 records which are duplicated by some reason.... I need to delete those 4 manually. I go to DATA, search the rows, select the header but I cannot find the option "DELETE ROW". I can only DELETE COLUMNS. Please help. Thank y
Track Project Task Time Via Status
I'd like to see how long a task has spent in a particular status. I'd like to see the total for the project as well. I looked in the backup files and task data source files and I didn't see the table that shows activity in a tasks which would have time
Send Zoho Analytics reports to all contacts
Hi, We use Zoho CRM data to create reports in Zoho Analytics. The report we create shows all deals that have been referred to us, by referer. We want to send a report every month to each of our referrers, with the status of their assigned deals. Referers
Display Order for Stacked Bar Charts
I've got a stacked bar chart that is correctly displaying the data I want it to, but I want the data sorted in descending order by value - it's currently sorted in alphabetical order by name (so reading from left to right it shows Alpha (3) Beta (1) Gamma (5). I'd like it to display in Gamma Alpha Beta order. Is this possible (without switching the axes). Thanks
Geo Data
Hi, I am wondering if I can do this within an analytics map chart... I have 2 charts UK Postcode data of sales UK Postcode data of post offices Is it possible to overlay both sets of these data and define then with specific colours eg Sales data in green
Joining 2 tables
Hi, Wonder if someone could help me, Im looking at joining two tables in Analytics to create a new table, Im not an expert on SQL? I am wanting to use both of the historic data and current data tables to create a new table, with new values as shown
[Webinar] 7 BI trends to watch in 2022
Hi there, Some businesses are still reeling from the impact of the pandemic, while others are growing as expected—with some even outperforming expectations. Irrespective of the stage in which your business currently finds itself, one of the key enablers
Formula column IF statement between dates
Hello! I want to add a formula column in Zoho Analytics that indicates the period in which a lead was created. So it must be an if statement that returns the value 'Period 1' when a lead is created BETWEEN Jan 1 and Jan 30. I just can't figure out how
Target within a pie chart
Is it possible to set a target within a pie chart? The image shows 3.3%, but it should be at max 1%, so that's the target in this case.
Zoho Analytics for Experts (video tutorials)
Hello friends Let me share my first Zoho Analytics lessons for Experts via a youtube playlist. Free lessons for users of the Zoho Analytics BI tool. https://www.youtube.com/playlist?list=PLnusL2XA4g1EyvhwfU7g4I2YcrVq-AyTE Please, share your ideas for
Historical Analysis of Pipeline
Hi All I am new to Zoho and am trying to figure out if there is a way to see the value of a particular stage at a given point in time. The basic idea is to see the total value of each stage of the pipeline at the end of each week/month. This will allow
multiple filtered results from single table
Hi, I have a table called 'Applications' that include a list of apps on each computer, and their versions (and computer serial number) What I want- A table (query table? Report? Dashboard?) showing the serial number, and the version of a couple of these
Combo Chart - Tickets Open Vs Tickets Closed
Trying to do a simple combination chart and running into some issues. Trying to have a single view show me side by side, how many tickets opened in a month and how many tickets were closed in that same month. To make it simpler, I am only going to view
How to fiter Query Table using report as a filter?
Greetings! I have a dashboard with multiple reports and all of them are acting as a filter. Everything was working fine. So I created a Query Table to join data from different tables and show as a list of items into this dashboard. The main purpose is
How to Edit a Column Formula that is part of a Query Table
I need to edit a column formula that was saved into a query table Normally for an import table, I would just go to the "Edit Deign" button in the top right corner, and a formulas tab would be there for me to select However, in a query table when I click
How to compare open vs closed tickets
Hello, We're trying to represent the number of desk tickets opened and the number of desk tickets closed each month on the same graph. We're looking to create something like this: With perhaps the blue area being the number of tickets opened, and the
Translate Month Names
My workspace are in portuguese, but all month names are in english. It's possible translate month names to portuguese too?
Update column type/formatting via API
Greetings! I have a table with 107 columns and I want to change at least 20 fields from decimal number to currency and apply currency symbol and separator. As far as I know, I have to manually change the type of a column, wait, change the data formatting,
Xero Connector import date range (more than 24 months?)
Hi, I'm working on an integration between Xero and Zoho and part of it requires data to be pulled into Analytics and that's raised a question in my mind. When connecting to Xero, Zoho Analytics lets me pull up to 24 months of data from Xero in the initial
Graphs with 'Full Date' no longer work
I have a number of graphs that are showing "no data available" . All of these graphs have data in the graph by "full date" - I also get the error circled below when I try to create a new graph "by full date" This has never happened before and suddenly
Next Page