Progress Bar
Hi Zoho Team, 1. Please add a progress bar from which we can get the %age of the Synchronization status. 2. As Currently we are not testing the connection which we are making with the SQL Server or any other source please do make it also
How to calc cost % of all income
Hi, I would like to calc the percentage of cogs but don't know how to achieve this with a aggregate formula: Hope you guys can help! :) My data is is modelled like this: GLMain Cat GLSub Cat GLMain Desc Amount 7 70
Display an Image of an Employee in a Report
I'd like to display an image of an employee in a report or dynamically on a dashboard with relevant data in reports below. Can I do this? Diane McConnell
Possible to create calculated fields with Pivots?
Hi, we're thinking of evaluating your product, however we need a calculated field in a pivot. Is this possible? For example, we have a table with columns for Country, State, Sales, SqM. In the pivot we will group by Country and then State, and in order to get a Sales / SqM column, we need to add it as a calculated field in the Pivot table. It would, on a record basis, calculate the total sales divided by the total sqm. In Excel we use a calculated field inserted into the Pivot table to do this.
Vertical Bar Chart
I'm trying to draw a chart which would show me the sales person name on X Axis and Y Axis would show sales total amount. I need two columns per sales person (one for 2020 and other for 2021) and I need my sales figures broken down by product sold. I understand
How do I change the time zone in Zoho Analytics (under data sources > Next Schedule Time
As show on the enclosed screen shot the time zone is shown in GMT. How do we change this? Data Sources > Last Data Import/Sync Status and Next Scheduled Time
Change font of PDA File
When I export the dashboard as a PDF, the Japanese fonts are very hard to read. Is there a way to change the Japanese font in a PDF file?
Threshold Scope and Reference Axis not available to amend
Hi All I have a report built where the Y Axis is made using a simple formula to return a % result. I want to add a target, static line in to the Y axis using threshold. However, when I do this I cannot select Scope of Axis to apply to. If i add 0.45
Error in Connecting with data source
I have a connection error with sql server data source. How can i connect with sql server data source please give some instruction to connect. It will showing an error message like connection problem with host name. Thanking you in advance.
How can I merge two tables into one formula?
Hello dear Zoho community, I would like to create a graph for my dashboard, where the Total Direct Costs / Client can be seen according to the respective month. However, this is currently causing problems as this data comes from two different tables.
Questions about syncing with Zoho CRM.
I have a question about synchronizing with Zoho CRM. I changed the name of a single selection item in Zoho CRM and then synchronized, but some of the changes in the above items are not reflected in Zoho Analytics. After changing the items of Zoho CRM,
Widget Not Included in Slideshow
I am unable to include / add - Widget in Manage Slide show in Zoho Reports / Analytics
[Webinar] Accelerate Multichannel Online Retail With Advanced Analytics
Hi there, Hope you are safe and well. We have made a practical webinar to help online retailers centralize their inventory, supercharge multichannel sales, and apply the insights derived from advanced analytics to scale up faster. We believe that this
SQL Alias error?
I keep getting this error: Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query I don't know where I've went wrong. SELECT Distinct "Book Title", t1."Author" as 'Authors1', t2."Author" as 'Authors2', FROM "SET1" t1 LEFT JOIN "SET2" t2 ON t1."Book Title" = t2."Book Title" WHERE Authors1 LIKE '%John%' OR Authors2 LIKE '%John%'
Today's Date Widget?
I love the new in-line e-mail feature, but before I'm ready to start using it for my company, I'm hoping to solve one thing: When I send the PDF version of my weekly dashboard, I've embedded a little iframe in the title that simply pulls in "today's date." So, today's dashboard will say "Dashboard for the week of September 18th, 2015" where the date is pulled in via and styled with HTML. Is there a way to achieve this with a widget or other method? The iframe doesn't survive the e-mailing process.
How to import from a file local to the server running Analytics
This seems like it should be the easiest thing in the world, but I can't find a way to do it. We run the on-premise version, under Linux. We have jobs that deposit files in a particular directory on the machine running Zoho Analyltics. I want to import
Conservar Formato en Tabla Dinamica
Saludos. Al crear una tabla dinámica quisiera pre establecer el tamaño de las columnas y que este se mantenga aunque se actualice la información. Actualmente reduzco de manera manual el ancho de las columnas y cada vez que actualizo la data, las columnas retornan al ancho habitual. Podrían Orientarme. Gracias.
Zoho Analytics : Import [Zoho Desk History] table
Dear Zoho Agent, Would it be possible to Import Zoho Desk History table into Zoho Analytics? I couldn't find any table that could be History Table. Best Regard, Karanig Nitithan
Multiple Axis Graphs
Hi, It would be great if you could pick which axis a series will be plotted on rather than each on their own or all on one as is current. Eg 2 series measuring volume plotted on one axis with a percentile line plotted on a second axis (currently you would have to have all 3 series on 3 separate axis or all on the same one).
Automatically changing the Y-axis range
Hi guys! In this chart, I'm analyzing the data input average per customer profile. In the image below you can see that there's two profile and the Y-axis range is set according to the data related to both profiles: When I deselect one of the profiles
Dashboard header and logo alignment
Hi i added logo and header but its alignment is not proper and dashboard hedaing is not in center as shown below if i tried to make a dashboard title center aligned but we are getting a extra space below is there any way to get both logo and header
Query table, select where with bool column
I am creating a Query table, when I use select with a where with a bool column, it doesn't compare well SELECT "PVC ASSEMBLY OUT" FROM "Item_Subform_SubItem" WHERE "Item_Subform_SubItem"."PVC ASSEMBLY OUT" = 0
Some fields of my Zoho Desk Layout isn't accessible in Zoho Analytics
I frequently use Zoho Analytics to treat some data of my Zoho Desk tickets, but I've just noticed that some fields that I added to my layout are not shown in the Tickets table on the "Zoho Desk Modules (Data)" paste. Why is this happening, and is there
How to change the format data from a table in Zoho Analytics
When importing a Google Sheets as a Data Source in my Zoho Analytics workspace, a "Month" column was imported as a "Text" data type, and not a "Date" data type, as shown in the image below. As I use its data in some Querys and Charts, I'd like to change
Zoho Analytics Formula Column
Date column imported from Zoho workspace gets changed to text type. I tried converting the format, however it gives weird results. To counter this, I created a formula column - this however doesnt give me any output. It's always blank. Not sure, if the
Why is Zoho Analytics so damn hard to set up?
Hi I am a Zoho One user and small business owner. I use quite a few Zoho apps and for the most part can get things to work as long as it does not require Deluge. With one exception, Zoho Analytics! I have attempted setting somethings up on my own but
Summary view grouped by date - can I include missing dates?
Let's say I have a table like this: May 1, A May 1, B May 1, C May 2, A May 3, A May 3, B May 5, A May 5, B Using the "Summary Report", grouping by Full Date, and displaying count for column B, I get this Summary: May 1, 3 May 2, 1 May 3, 2 May 5, 2 Is
Joining Leads and Deals tables
By The Grace Of G-D. Hi, How can i join 2 tables that are already joined (Like Leads and Deals) Using another Column as lookup?
Calculate business days between dates in reports
Good afternoon, I'm trying to calculate the datediff excluding weekends/holidays. I can accomplish this in Excel using NETWORKDAYS. I saw there was a previous response about this, I have shared my DB with support and emailed in, but wanted to post here in case someone could template this out for others.
Creating Rankings based off of other fields
Hello, What i am looking to do is create a formula that creates rankings based on two specific fields. In excel I would do a countif functions =countifs(A$1$:A1,A1,B$1$:B1,B1). This creates a ranking based on the number of records that come before it with same criteria in columns A and B. Is there any way to do this in a report?
Adding two fields to create a new column
Hi , i have two fields first name and last name and ,i want to create a new column as full name . so i tried with this formula "first name"+"last name", the column is created but it shows no data in that column. is there any solution? Regards, Divya
Why can't I use GROUP BY clause normally like everywhere else?
Query Error: Improper usage of GROUP BY clause. Please ensure that all non-aggregate columns used in the SELECT clause are also used in GROUP BY clause. I have a simple table with data scattered around for same value, I want to get the total for all the
No e-mail sent when user forgets password
Using an on premise setup (latest service pack). When user goes through the "forgot my password" process, everything appears to work on the web side, but the user never gets any e-mail with a reset link. When I reproduce this problem, the only log activity
Replicating a google analytics table in zoho analytics
Hi I have imported my Google Analytics and Google Ads data into Zoho, and I'm trying to replicate a table that is available in Google Analytics, but I can't see a clear way with the data pulled to attribute a transaction to a particular keyword. I have attached the table that I am trying to replicate.
Adding text to a Line Chart
I would like to add some text to a line chart. In the dashboard, i can add Text at the bottom or top of this line chart. But i want the text adjacent to the lines. Is this possible? Regards, Ram Reddy
New in Zoho Reports: Criteria based sharing
Criteria based sharing Zoho Reports now offers a powerful feature that allows you to define a criteria when sharing a view/report/dashboard. The defined criteria will determine the data that will be displayed in the view to the shared user. When a report is shared to a user(s) with an associated filter criteria, the specified criteria will be applied on the report shared, there by filtering the data viewed when user accesses the report. For example, if you want to share a Sales report to a Manager
Not being able to assign my user as Admin (with a current admin account)
Hello there guys I've been trying to add my user as an admin on Zoho Reports with an already existent Admin User, nevertheless I'm not being able to as when I change the profile/role it automatically goes back to "User" and I'm not being able to save it as admin in any way My user account is clundstedt@innovasoft.cl and our organization admin (the one that is trying to set me with those permissions is mcollado@innovasoft.cl Please help with this issue so I can start sorting out Zoho Reports as intended
Summary Table Filter
Hey, Zoho Analysis Team I was just working on creating a summary table, using multiple numeric filters - and it became very messy for me to manually add range filters according to every user filter I need to use. In this reporting I need to use more than
Databridge - Import data from AWS, possible security issue.
Hello Since Aprin 2021 we have started to use the new Databridge software tool to import data from our local DB's to our Zoho Analytics account. It works fine however this representes a possible security problem for us. All our systems are hosted in Amazon
KPI Dashboard: Most Active Day of the Week
I have a dashboard widget showing the most active day of the week. Problem is, I want the full day spelled out and not just the abbreviated day (Mon, Tues, etc). Within the KPI Widget Editor Settings, I am using the following: ${Date}.LABEL What syntax
Next Page