Image type data in Zoho Reports
Hi, New to Zoho Reports, I'm wondering if we can store images to Zoho Reports database tables. Tried looking into different field types supported by tables in Zoho Reports, but couldn't find a suitable one. Gone through knowledge base, and learned that images can be uploaded into Zoho Creator, but how to import them into Zoho Reports? With Regards ~Vikas
ZOHO FINANCE Inventory Adjustment DATE not available in ZOHO Analytics Data Source
See Screen Shot.
Joining 2 tables
Hope someone can help. We are a service delivery company and I am trying to keep track of each technicians completion percentage as the day goes on. The "starting Services" column is the amount of services they start the day with, then we export from our CRM to dropbox hourly to get the "services completed" number, then also a formula for the % complete. The problem i am having is that the "services completed" column references the total number of services completed between all technicians, and does
Ask the Experts #7: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We're super excited to host our next online community event Ask the Experts #7 on 19th March 2020 between 05:00 AM - 10:00 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar. This Q&A discussion happens right here on the online community forum. To participate, post your questions
Flowchart showing changes over time (day/week/month/year/custom) to see to which state my potentials went
Cheers People, I added the options on the data source (Zoho CRM) to import the stage history and now i have a new table with this information. This table does not have the name of the connected deals (Potentials) in it?! What i want to check with this report: Show me where my potentials went and when. Example: last week we had 150 deals in stage x and on the next week we have 155 deals in stage x. Now i want to know how many deals went away from this stage (x) and to which state (y, z). And of course
Anyone know how to display ROI from data in two unlinked tables?
We've been working on this issue with support for weeks but have gotten no where. We're looking for something that seems so simple; a widget in a dashboard that shows the ROI for ad spend (ROAS). Table A has the ad spend cost. Table B has the revenue. We have tried several ways to link them via lookup columns, but nothing has worked. Support has tried to create query tables, but it's proven more challenging than they anticipated. We can't link the tables because they have no columns of data in common.
Tip of the Week - Import files larger than 100 MB easily!
Yes, you read it right! You can easily import large files (those larger than 100 MB in size) into Zoho Analytics using Zoho Databridge. Zoho Databridge is an enhanced utility by Zoho Analytics that enables you to import data in the form of large flat files, from on-premise and cloud databases, into Zoho Analytics. You can also automate the import process to synchronize the data from your local/hosted database into Zoho Analytics at periodic intervals. Below are a few details about our next-generation
Invalid numeric expression found
I am getting this error on several canned reports that Zoho provided with Analytics and on several reports I have created. I have not changed any of these reports and I have not altered any of the aggregate formulas that they use. Something has changed recently to cause this error. Alert Message Invalid numeric expression found. The numeric expression contains a String column/value which cannot be converted to numeric.
How sales analytics drives revenue growth
Hi there! From defining realistic objectives to adopting course corrections, organizations call for a comprehensive and objective outlook on sales—one where expectations are clearly defined and agreed on with the sales team. This is getting better with data driven decisions, but there's still a long way to go. Join this webinar, where we'll discuss how sales analytics can help you align your sales team with your revenue growth expectations. Register now!
How do I hide a Dashboard widget from certain users?
I have a sales dashboard with several widgets that show the monthly sales by product line and a user filter so each user can see only their data. A subset of my users do not sell one certain product line, so I would like to hide that widget from their view. I do not want to create a copy of the dashboard for only those users. Instead, I would like to have one dashboard for all users, and those users only see the reports and widgets relevant to them.
Sample of ZOHO Analytics prediction function
ZOHO Analytics has a predictive function, which automatically predicts the number of new coronavirus patients. The conditions that can be predicted are quite severe, but simple data with few omissions seems to work relatively well. You don't know what the key predictions are without looking at future trends.
Help with KPI Widget please
Hi, I have a KPI Widget that is calculating the Avg of an Invoice amount. I am grouping by month. What my objective is to do, is to calculate the average monthly total by month. Example: If the date picker is showing this year and say 7 months have passed. I am wanting to calculate the average amount invoiced per month. (Add up the total of each month for the seven months, to get a total YTD, and then divide by the number of months (7), to get the average). This does not seem to calculate correctly,
New Features rolled out on Feb 28, 2020
Advanced Analytics for Site24x7 Advanced Analytics for Site24x7 helps to improve your service/platform availability & quality with meaningful insights on outages, alarms, monitors, and infrastructure. You can easily track the outages by analyzing the key metrics such as downtime count, duration of outage, frequency, and more across locations. This helps in identifying the root cause of downtime and take appropriate steps to maximize website, application and server performance and availability. The
ZOHO Analytics Case (Current Status of New Coronavirus Infections)
Current status of new coronavirus infections [Domestic cases (excluding those returning from charter flights)] I made it with ZOHO Analytics This is an example of how you can do this with ZOHO Analytics First of all, please click below. You can do this. Current status of new coronavirus infections [Domestic cases (excluding those returning from charter flights)] Creation time is only 15 minutes The data is not accurate because it is intended to introduce what ZOHO Analytics can do. Therefore, copying
New Features rolled out on Feb 20, 2020
Support for Amazon S3 Amazon S3 is the latest entrant being added to the list of Cloud Storages/Drives supported by Zoho Analytics. You can now analyze data from files stored in Amazon S3 buckets, using Zoho Analytics. Click here to learn how to analyze the data stored in Amazon S3. White Label Settings Page Revamped with More Customization Options! The White Label Settings Page has been revamped with a lot of additional features and enhanced usability. The new UI is divided into Settings and Administrative
New key install (zoho databridge
We have a problem installing Zoho Databridge We downloaded the setup and installed it. But we need to reinstall the software and lose the key. How to get another key? We need to connect to a MySQL database
Resource Utilization Report
I'm trying to build a report drawing from synced Projects data that will show planned resource utilization across multiple users/projects, by summing all their planned work hours for all their tasks by month. I'm able to find fields for budget hours and users, but I can't find a field that shows the time element of the table. I've tried duration and start date, but start date only shows time in the month it starts and duration doesn't offer the necessary options. For example:
Empty but successful XML feed over https gives error
I’m testing a data import to Zoho Analytics using Feed/XML data fetch from an URL with https. I have tested successfully the following request with CURL command line, it gives the XML response, given that I had CA certificate installed on my local Windows. There is no other explicit authentication method required. curl --cacert ca-bundle.crt -X POST -d dataname=xxxx -d key=xxxx -d token=xxxx -d table=orders -d column=closed -d value_min=2020-02-19%2000:00:00 -d value_max=2020-02-19%2023:59:59 -d
Shared Dashboard Not Displaying to the User
Hi I have a paid subscription for the Zoho Analytics. I have created several dashboards and shared with several users before without any issues. Today I created a dashboard, and shared it with 2 new users who I bought subscription for. For some reason, both the users are not seeing the shared dashboard. I have tried deactivating, reactivating, revoking access and again giving access. Nothing seems to work. Dont know what to do as the other shared dashboards are working perfectly fine and are being
How do I remove or edit custom ranges on a slider?
I have added some ranges to a slider, but have realised that I either made a mistake or want to edit what I created. I do not see how I can do this. I can add a new one and deselect the incorrect one, but would be nice to keep the area clean and tidy and not have non useful options. Thanks Steve
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
Ask the Experts #6: Five hours live Q&A session with Zoho Analytics product experts
Hello everyone! We're all set to host our second community event in 2020 - Ask the Experts #6 on 19th February between 05:00 AM - 10:00 AM PST. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar. This Q&A discussion happens right here on the online community forum. To participate, post your questions
Embending API problem
We're having an issue with the underlying data, We're using the embedurl from de api indicating the underlying data permission to true & the columns that we want to show. The UD was previously showing on the portal where we embed the url. We don't know if some of the documentation regarding the API changed recently. I hope you can point us what we are doing wrong. Just to reiterate this was already working before today
Databridge
I currently have the Databridge downloaded for a local database. Whenever I update that database, does the databridge automatically update it in Zoho. Or would I have to constantly re-import?
Images in ToolTip
Is it possible to show an image when rolling over a dataset? Basically I have my chart showing data (impressions) by creative. I want to be able to rollover the creative name on the axis and have it show an image of the creative vs. just having the name there. Or I'd even like to have it show the image in the tooltip along with the other data that I've placed there. Is this something that is possible or something you can add in to your roadmap? Thanks, Jamie
Query Table does not update with new data in dashboard
Hello, I'm using the On-Premises version of Zoho. I create two Query Tables that gets updated each week. Both of them are not refreshed automatically with the new data in the dashboard. When i select the query, the data shows the previous week, and when I go to "Edit Design" and "Execute Query" I see the updated data. Please see sample query below: SELECT "Week", "Actual2019", "Actual2020" FROM "SalesPerformance" WHERE "Week" in ( SELECT MAX("Week") FROM "Calculations" ) Am I missing a step?
How to create Pareto Chart like this
I try to create a chart like this image: The Acc axis is "Running Total", but show as "%Accumulate". This is what I can do. My problem is : 1. I can not sort bar chart from Max to Min (Desc.) while line chart is sorted by Min to Max. 2. I can use "District Count - Running Total" for Acc. But it cannot show as %Accumulate. Do you have any idea for this case ?
Renaming Data Sources
Hi Please see attached, I have 2 Xero data sources but I cannot see where I edit the names so I can distiguish one from the other in the dashboard and the reports. Please help Thanks Dave
How to get multiple sheet in a single excel file
Hi, The reports are created in Zoho Analytics I want to consolidate and bring them in one single excel file. My team requires such report daily and same should be scheduled using scheduler. Help me to solve this problem
Color Coded Map of Territories
How can I make a map where the States are color coded to the CRM Territories?
Date Format Doesn't Convert
I'm importing data from Google Sheets I'm trying to change the date format of the "date" columns to mm/dd/yyyy. In my original Google Sheet, the format is mm/dd/yyyy. The initial date format in Zoho is 17 Apr 2017 00:00:00. When I change the Format of Date Columns to mm/dd/yyyy, my date column in the table preview is then changed to a Plain Text data type. If I change the data type back to Date and then create the source, I get errors on the entire Date column: "RESET : Invalid Date value." Is
Sending repost by email FROM the creator of the report
Hey, we have several reports that we would like to send periodically via email. I've set up an Email Schedule but the sender of those emails is either me (as the admin) or notifications@zohoanalytics.com. The user who created the report would like it to be send on his behalf, so he edited the Email Schedule and set his email address (and of course saved!). The email is still being sent on my behalf, and I don't even see the email of the user who created the report. How can we solve this? M.
Importing to same table with differing data sequencing?
Ok, this might be a simple question, but say I’ve created a Table of Monthly Sales (columns) by Customer number (rows). If I have the same 50 customers for a while, so 50 rows, but then I have an import with only 48 customers, or 48 rows, how or will Analytics pick up and place the sales data in the proper customers row and place a 0 in the row(s) where no sales data is for that particular month? If it didn’t then the sales data would be placed in the wrong customer numbers.
Pulling in Attendance Information
I'm trying to pull in daily attendance hours from Zoho People into Analytics but it doesn't seem to allow for that dataset? I'm working on a dashboard that will allow me to compare time logged from tickets and projects to an employee's actual attendance time. Thanks, Scott
Ask the Experts #5: Five hours live Q&A session with Zoho Analytics product experts
Hello everyone! Hope you all had a great start in 2020. We're excited to host our first community event for the year Ask the Experts #5 on 22nd January between 05:00 AM - 10:00 AM PST. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with our product experts. Start posting your questions right away! We're looking forward to have an interactive session. Note: This isn't a webinar.
How to get the first result of rows with duplicate dates?
Hi, I have a table that contains the following fields: An ID An event A date-time for each event It looks like this: ID Event Event Date 1122334 Event 1 2016-10-01 10:00:00 1122334 Event 2 2016-10-01 10:00:00 1122335 Event 1 2018-06-23 11:43:22 1122336 Event 2 2019-02-02 08:04:13 1122336 Event 1 2019-02-03 06:07:17 1122336 Event 2 2019-02-06 13:37:44 My goal is to find the first event for a given ID, based on the date so that I have a list of unique IDs and their corresponding events and dates like
New Features rolled out on Jan 31, 2020
New Data Connectors We're happy to announce two new Advanced Analytics connectors--for LinkedIn Ads and Eventbrite--powered by Zoho Analytics. Advanced Analytics for LinkedIn Ads Advanced Analytics for LinkedIn Ads, enables you to visually analyze your marketing Ad campaigns, measure the outcomes, and derive actionable insights in minutes. Quickly analyze key performance metrics like traffic, CTR, CPC, CPM, conversion rate, and much more. Apart from analyzing your LinkedIn Ad campaigns, you can
How to input Values from 2 different tables on Y Axis & Generic Date on X Axis
I managed to feed values from 2 different tables on Y axis. But now I need to feed a Generic Date (Month/Year) on X axis. Im trying to make a Chart like: Receipts x Expenses Y (2 Bars) Time X Anyone know how can I do it ? If I insert date from one of the 2 tables (receipts or expenses) it doesn't load the chart data. Tks
Linking table from Zoho Reports to Excel
Hello, I would link to be able to have a worksheet in excel that gets automatically updated when there are changes in a Zoho reports table. I believe the Get external data option in excel should be able to do this, but I am unsure how to set it up to work with a specific table in Zoho. Any help with this would be appreciated.
New Features rolled out on Jan 20, 2020
Happy New Year! Zoho Analytics welcomes 2020 with some cool new options. Embed / Publish UI Revamped with Lot More Options! The Embed / Publish URL dialog has been revamped for better usability and has also introduced a good set of additional functionalities. The new UI captures the following: Embed and Publish options merged in a single screen Access with Login, Access without Login, and Access within Organization / External Users permission controls in the same dialog Status of the already published
Next Page