Worked hour report help.
Good day everyone, I need some advice with Zoho Analytics. I am trying to get a report that will show the work hours of a user. We are using Zoho People timesheet/time logs. I connected Zoho People and Zoho Analytics, and everything is working fine. So,Unknown table or alias 'A1'
I would like to create a subquery but i am getting the following error: Unknown table or alias 'A1' used in select query. This is the sql statement: SELECT A1.active_paying_customers, A1.active_trial_customers, A1.new_paying_signup, date(A1.date_active_customers),GROUP BY error message with IF statement
Hi, I'm reasonably new to coding so this may be a really simple fix (i hope anyway!) I'm building a query table to identify cases for inclusion in a healthcare quality indicator as well as produce an output column that provides a true or false statementCompliance - ITAR
I was just reviewing your compliances, and noticed you do not have ITAR certification. Is this a certification you plan to get, if so what's the timeline? We currently use ZOHO for analytics, but some of your apps we cannot use due to your lack of ITARHow to filter by null values
Is there a way to filter a widget by null? I want to get a list of records that don't have a date filled in and can't seem to see how without going through a query. Is it possible to do it through the widget filters? Thanks.Tip of the Week - Split Columns in Zoho Analytics Table
Want to split a column containing distinct values into multiple columns in your Zoho Analytics table? The below video demonstrates how you can split columns in a Zoho Analytics table.New Features rolled out on April, 2024
Sunburst Chart We're thrilled to announce that Zoho Analytics now supports the Sunburst Chart. Explore the power of hierarchical data with our sleek and intuitive Sunburst Chart and uncover trends with precision. This dynamic chart visualization transformsAdding custom sort to sort options
Hi! Happy to connect! I am so excited to use Zoho analytics which is so easy to map the required data from marketing, new project development teams, clients, and vendors. I have the option of sorting either by ascending or descending. It would be of greaterHow can I generate a report on dormant Accounts in Zoho CRM and Zoho Analytics?
I can't imagine this is a unique ask, but can't find an answer in the community. We have lots of Clients (i.e. Accounts) with various levels of 'dormancy' i.e. they have not engaged with us for # months. This is based on the date of the most recent EnquiryAll Zoho Survey tables explained
Introduction Hey everyone! Sometimes, deciphering the structure and meaning of data in Zoho Analytics, especially when Zoho’s native syncs and integrations are activated, can be quite challenging. That’s why I’ve put together an overview, not only toTrying to Access all Zoho analytics data?
Hello, I am using post man at the moment to test the API connection to Zoho Anaylitics. When it comes to the URL and parameters, I think I am missing something or adding the wrong information in a step. This is currently what I am trying: GET: https://accounts.zoho.com/oauth/v2/auth?Import Pandas data frame into an existing table in ZOHO analytics
I need to import pandas dataframe into zoho analytics table which is already existing in ZOHO analytics. How should I do that?Merging Cells
I wonder if someone could help me with this problem? I have looked through the forums and noticed that someone posted the same question as I'm about to last year, but it was not answered. OK....I have created a table with three columns and a number of rows. I would like to merge cells but can't seem to find a way to do it. Can anyone help with this?[Upcoming Webinar] Refined data and faster insights with data preparation
Data preparation forms the bedrock upon which insightful analyses and informed decision-making stand, directly impacting business revenue. However, preparing data is often perceived to be a complex and time-consuming task that often demands IT intervention.Tooltip Customization
Hi Team, I have a bar chart that displays the dollar amount in proposals sent, won, and projected to close per month (a bar per metric per month). I have the count of proposals per metric included in the tooltip shelf. When I hover my mouse over the 'Sent'We are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingAverage agent time reply - Zoho Desk
Hello, We are building a report where we would like to see the average time that an agent takes to reply to their customers. In Analytics we were using the measure "tiempo total de respuesta en horario laboral", but it does not show the correct valuesCan we consolidate data from multiple Zoho Books organizations having different home currency in Zoho Analytics?
Hello, Can we connect Zoho Books account having multi organizations with Zoho Analytics to consolidate data from all organizations? Each Books organization has it's own home currency like INR, USD, GBP etc. How to consolidated Sales figure and show amountSolution of the Week - Consolidated Balance Sheet for multiple orgs, multiple countries with different base currencies
In the previous posts, we discussed how to create a consolidated balance sheet for scenarios using Zoho Analytics where multiple outlets operate within a single country using the same base currency, and for cases where there is an organization with aCustom Formula - Zoho Analytics
Hi, I want to see profit% for each customer. However the aggregate formula on the tool is not the most accurate as it ignores purchase discounts all together and gives the % on Sale Price and not Purchase Price. I tried adding custom formula but couldHow can I calculate the physical stock available for sale?
Hey Zoho Team, I've tried to calculate the physical stock on hand in various ways - but always receive a mismatch between what's displayed in Zoho Inventory & analytics. Can you please let me know how the physical stock available for sale is calculated?Waterfall Chart
Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?Date from a date field to today
Here is my query, but it's not calculating correctly. I'm trying to determine how many weekdays have occurred between "23-24 Start Date" and today, but I'm getting a number that's much too high. SELECT "Q_DataWalls_Time-Off_23-24"."Name", DATEDIFF(WEEKDAY,Data imported through URL data sources will show HTML codes instead of special characters.
We have a data source configured to import information from a URL. Some of the data contains apostrophes that will not be displayed as the actual characters but as HTML code. Example: let's go will be displayed as let's go Is there an option in theNeed Query to Output as Date
Hi, I'm new to Zoho/queries.....In my formula below, I need "23-24 Start Date" to output in a date format, but when i try to change the data type after I execute my query, it says it's not compatible. How do I fix that? SELECT "Staff Demographic DataAnalytics - String to Duration
Hey friends! Our calls module is logging the call duration automatically and it's coming into Zoho Analytics as a string. When I try to change the data type from the parent data set, I'm unable to as it's a system table. I'm trying to get around thisQuery table count function
I am trying to create an SQL query table with the aim of producing the attached stacked bar chart in Zoho Analytics. I can count the number of S1 payments as follows: SELECT abs_month("S1 invoice received"), count(abs_month("S1 invoice received")) ASFirst reply time in hours - Zoho Desk
Hi, We are trying to build a report to see the time it takes to reply to our customers when they create a ticket. We are using the "First Reply time in hours", but checking with the tickets does not seem to show the right value for some tickets. How canZOHO Reports is not Working !
This error is coming up: Please fix it ASAP. Sorry!! Unable to display this page Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page. 1. The error has been logged and will be looked into. 2. It would be of great help if you could provide us with additional information using the feedback link.Trial: Project Status Overview Report Not Showing All Projects
We use Zoho Projects to track our teams IT projects. I'm currently evaluating Analytics to get better reporting capabilities of our projects. Unfortunately, when I run the "Project Status Overview" report, only 2 projects of the 8 projects currently openZoho report aggregate function issue
Hi, I wanted to write a formula connecting 2 tables. But currently im facing this error Alert Message Sorry, you cannot create a formula column involving columns from multiple tables. This is my formula. Can you help me with a workaround. Infact, i haveDashboard User Filters synchronize across all tabs
Is there a way to synchronize dashboard user filters across all tabs of a dashboard. For example, if I defined a user filter to allow the user to select a data range for the dashboard, I want that range to apply to all tabs of the dashboard so the userIs there a way to remove the border color of widgets on a dashboard?
I have a dashboard with a multicolor theme. There are four pivots with detailed information, and Zoho auto-assigns a fill color to each of the headers. I added a widget that has summary information for each of the four pivots and made the fill color matchCompare differences between data in different groups (year, year/month)
Hi, I need to compare data in a pivot table. I found articles related to the % of, however it seems that this only allows comparison with values within the same group. Let's say I have my data segmented by Year, then Year & Month. If I want to compareCompletion age Tier Range - Zoho desk
Hello, we have built a graph about the resolved tickets by time and we would like to modify the range in the lagend, lo make different buckets but we are unable to find how. Thanks!Mapping Date Columns in Filters
Hi Team, I created a chart where I am tracking USD in proposals per month by their sent date, won date, and projected close date. Those dates are all fields in the proposal record. On the x axis I am using sent date. On the y axis I have a sum_if formulaCreating a staked bar chart in Zoho Analytics where the x axis is the date of two different fields
Hi, i would like to create a staked bar chart in Zoho Analytics where the x axis is the date of two different dependent date ranges. The first date range is the date when a stage one payment is received in the CRM. The second date range is the date whenI need help with a column
I need to help me to make a formula for a column, it is to determine that when the data is greater within a specific column, is a type of retention, if it is less, is another type of retention, and if it is much less, is another type of retention, I getHow to put a dashboard offline?
Hi, I have a dashboard which is shared to several people within the organisation. I need to make some significant changes to the dashboard. What is the easiest way to make the dashboard offline during development of new features and put them live againHow to compare data from last 7 days to previous period?
I would like to create Widget that shows data - counts the number of specific contacts that changed their Stage to a Win Stage in the last 7 days. After that, and at the same widget, I would like to see same data from the previous period. Can I do that?Next Page
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
New Features rolled out on April, 2024
Sunburst Chart We're thrilled to announce that Zoho Analytics now supports the Sunburst Chart. Explore the power of hierarchical data with our sleek and intuitive Sunburst Chart and uncover trends with precision. This dynamic chart visualization transforms[Upcoming Webinar] Refined data and faster insights with data preparation
Data preparation forms the bedrock upon which insightful analyses and informed decision-making stand, directly impacting business revenue. However, preparing data is often perceived to be a complex and time-consuming task that often demands IT intervention.We are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingWhat'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[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
Most Discussed Topics
Worked hour report help.
Good day everyone, I need some advice with Zoho Analytics. I am trying to get a report that will show the work hours of a user. We are using Zoho People timesheet/time logs. I connected Zoho People and Zoho Analytics, and everything is working fine. So,GROUP BY error message with IF statement
Hi, I'm reasonably new to coding so this may be a really simple fix (i hope anyway!) I'm building a query table to identify cases for inclusion in a healthcare quality indicator as well as produce an output column that provides a true or false statementImport Pandas data frame into an existing table in ZOHO analytics
I need to import pandas dataframe into zoho analytics table which is already existing in ZOHO analytics. How should I do that?How can I generate a report on dormant Accounts in Zoho CRM and Zoho Analytics?
I can't imagine this is a unique ask, but can't find an answer in the community. We have lots of Clients (i.e. Accounts) with various levels of 'dormancy' i.e. they have not engaged with us for # months. This is based on the date of the most recent EnquiryCan we consolidate data from multiple Zoho Books organizations having different home currency in Zoho Analytics?
Hello, Can we connect Zoho Books account having multi organizations with Zoho Analytics to consolidate data from all organizations? Each Books organization has it's own home currency like INR, USD, GBP etc. How to consolidated Sales figure and show amount
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Sticky Posts
We are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMOAnnouncing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data PreparationZoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us