Embed Dashboard into a Web Page using iframe
Hi, I have a Wordpress web site page behind a login for our company users. I want to be able to embed a dashboard view onto a page for our small company and let them drill down as required. I have the Standard Plan - I presume this will work OK please ? I have tried it and found that sometime it does and sometimes it doesn't show and to help problem solve the issue - I just want to make sure that my membership will allow this - I think it does but am checking. Thanks for the help Stephen
Total (sum) of each bar in a stacked bar chart
Hi, does anyone know of a way to add the total (sum) of the numbers in each bar of a stacked bar chart?
Cost Per square meter Calculation
I have the following data; IssueNo Consumeddivision Week Year IssueValue Area Period 1056492 CHEP 13 2013 5169 149615 4 1056492 CHEP 13 2013 7236.6 149615 4 1056492 CHEP 13 2013 15507 149615 4 1056492 CHEP 13 2013 24122 149615 4 1056493 SIMO 13 2013 7236.6 178349 4 1056499 CHEP 13 2013 758.12 149615 4 1056500 CHEP 13 2013 87.6 149615 4 1056501 KAP 13 2013 17.52 92480 4 1056502 SIMO 13 2013 26.28 178349 4 1055524 CHEP 7 2013 2146.2 149615 2 1055525 TOR 7 2013 1620.6 199100 2 1055525 TOR 7 2013 3540.1
error synchronization tool
: Lamentamos informarle de este error al invocar la herramienta de sincronización de datos de Advanced Analytics. Puede obtener los archivos de registro de errores desde la pestaña Soporte haciendo clic en el enlace Archivo de soporte en la aplicación ServiceDesk Plus.
Custom fields not showing current information in reports
We have custom project field called "Current Status Summary" which we update every few days and reports come out bi-weekly showing this information. The reports that came out this morning show the right information for some projects but for others the report shows information form last week and possibly even before that. The fields were updated yesterday so the report should be reflecting that information but it is not form many of the projects. Please help
Merging Axis, but not ALL axis
Is there a way to merge only some of the axis on a report ? I have a report, where I'd like to display - Cohort revenue averages - Cohort revenue summations - Cohort Count And I want 2 axis, one for the "Cohort Count" and a merged one for the two revenue data series. It seems to me that merge axis is either all or nothing. Is there a way to merge axis for only subset of data series? Thanks.
Working out Same Store Sales
Hi There, I am trying to work out a way in Zoho Analytics to calculate same store sales vs last year on the condition that the store traded the full month the prior year. For example if the store opened 7th January 2018 I don't want this to be included in comparing 2018 to 2019 January. Any help would be greatly appreciated Thanks, Paul
Resizable 'User Filters' Card?
It would be nice if we could adjust the size of our 'User Filters' card, the same way we can with others. Here, I only have a few, and it'd be nice to throw in a header image to the right, instead of having a bunch of empty space. Is this doable? Thanks
Report over estimates excluding certain items
Hello there Is it possible to build a report from the estimates and it's subtotals, but exclude some of the items in these estimates? Kind regards Reto
Creating a percentage report for a subset of textual string containing values from a Desk ticket table
I'm trying to create a percentage report to compare a subset of textual string containing values which were imported from a Desk ticket table. I can't find the proper syntax which allows the selection of specific values from this column. I want to compare the count of this subset of values to the count of another subset from the same column. Could you please help me out about this issue.
Journey in 2018 - A Zoho Analytics Travelogue
2018 was an eventful year for Zoho Analytics, as we had the Zoho Analytics 4.0 release in November. The product has moved more into the Analytics realm with a lot of key features such as Ask Zia, Forecasting, Auto-data Blending, Data Alerts, Contextual Commenting, Geo Map Charts, and Dashboards with flexible layouts. We have revamped the interface completely too, to enhance user interactions. We introduced a good many connectors to popular business apps over the course of the year. We take this opportunity
Get a Median Line in Zoho Reports Chart?
Hello, Is there a way to get a median line in zoho reports bar chart? Thanks and Regards, Atul Jain.
Craete report of timeline (history) using zoho report for all modules.
Hi, we want to create a report in zoho report which will show the history of records. We need this report for all modules. Can we do this in zoho reports? If yes can anyone share the steps for this.
Constant Contact Api Sync
Hi, I wanted to know when or if it possible that Zoho Analytics will be able to pull Constant Contact live data from the account? I know it is possible with the exel and csv files imports but I wanted the more automated sync option. Thanks.
Share Permission
Hi, this is my first question in this forum , it seems to be very easy ,but i cant figure out .can any tell me how to give shareable permission to any user, i tried some options from share icon, but user are not able to see any enabled option/button on this view, can any tell me what i m missing your help would be highly appreciated
Combining Data from Multiple Zoho Apps?
I am just starting to learn Zoho Analytics and would like to know if it is possible to create dashboards and reports that pull data from several different Zoho apps. So far I only see how to connect to one Zoho app at a time. Example: I would like to create a report or dashboard that shows my open tasks across the main Zoho apps I use - Desk, CRM and Projects. Is this possible? Thank You
Pivot Table Sub Totals Average decimal place
Hi, I have created a pivot table that does quarterly sub totals. Instead of sum I have changed it to average. How do I make it show with 1 decimal place? I the decimal only in the subtotals as I am doing average. The data set I have is a count. Thanks Sony
ODBC Connectivity please!
A way to connect to ODBC database drivers would be wonderful!!!!
Pivot Table - hide column
Hi, I have a pivot table with rows to generate a report that is text based. I want to use a column that has numbers to do the sort order. However I do not want this column to be displayed. Is it possible to hide a column in pivot tables? Thanks Sony
Trying to apply countif function to accounts instead of opportunities
I am trying to create a formula which counts the number of accounts where a particular condition is met but the output is instead counting opportunities relating to those accounts The formula I have is "countif("Accounts"."ATS Contract Go Live Date"<(currentdate()-90))" I want the number of accounts which are over 90 days old but the above formula keeps counting the total number of opportunities relating to these accounts which obviously gives a higher figure than it should Thanks Sarah
Integration with CRM & Project - missing fields
Hi CRM: I am trying to create reports in Analytics from data in CRM which I would like to filter by User role. Role isn't included in the Analytics User table and when I looked at the configuration in CRM the User table was shown in the list of modules you can select additional fields for. Projects: I want include the users' project portal rate in reports but again I can't see any way of pulling this data in from projects (only the User Hourly Rates table which would require manual data entry). If
Custom Defined Parameter
I've been using Zoho for the past few days. One of the things missing is a Custom Defined Parameter that I can use in functions as well as user settings. I could list multiple use cases for this but YTD and MTD would be my biggest requirement. So for example - On the user filters I have Report Date - Which shows a date picker and I can select 2018-11-15 for example. This is linked to the User Parameter I have created paramReportDate Now in my functions I can create Sales_YTD with something like this
Pivot View - Custom Sort
I have created a Pivot View. I am trying to apply a custom sort for the rows. The list that I have has more than 500 values. It would be nice to be able to drag and reorder multiple items. At present it is only possible to do so one at a time.
Merging Only Certain Axes - Combo Bar
Would it be possible to implement a feature (specifically on the Combo Bar), where we can choose which axes to merge into groups? For example, I want to have a graph with two bars for "current year" and "previous year" sales, both on a merged axis, and then a line representing the variance percentage going through them on its own axis. Currently it seems like I can only merge all of them together or have them all separate, both of which are problematic. I can set identical manual ranges on my two
Analytics plan level on Zoho One account
Which plan level on Analytics will be available to Zoho One account users when they are subscribed to the "Flexible User Pricing" model? For example which plan level for the Analytics will be assigned to us if we subscribe to "Flexible User Pricing" model with 10 users? If it's going to be one of the "Premium" or "Enterprise" plans on Analytics then how many users will we have on these plans? These plans are normally defined to have 15 and 50 users respectively. https://www.zoho.com/one/pricing/
Deleted tickets are showing up in a SQL query
I'm trying to write a query that shows me all tickets that are missing a time entry, so I can make sure the agents are logging their time accurately. My script is: SELECT "Request ID", "Ticket Owner Name", "Created Time","Department Name" FROM "Tickets" LEFT JOIN "Time Entry" ON "Time Entry"."Request" = "Tickets"."ID" LEFT JOIN "Agent" ON "Agent"."ID" = "Time Entry"."Agent" WHERE (MONTH(Tickets."Created Time") = MONTH(Curdate()) AND YEAR("Created Time") = YEAR(CURDATE())) AND "Executed Time"
Zoho Reports Database
Hi! I have a database in zoho reports but when you migrate to zoho analytics I cant view my database, Can you help me to solve my issue? Cordially Edgar MOntoya
How to handle JSON feed with nested variables
Hi, beginner user of Zoho Analytics (long-time Zoho CRM user, if that's any help). I'm trying to pull together some info from Zoho CRM and our payment gateway, Iugu. For Iugu, I do it via a JSON feed - I make a call to its invoices API which returns all the invoices. All good until here. The problem starts when Zoho Analytics hits the nested parts of the JSON response. The nested part, "variables", can have 0 to 10+ items. I'm trying to catch the variable "subscription_id". In Zoho Analytics, I end
Aggregate formula not yielding correct result
I'm trying to use an aggregate formula to calculate % of one value to another in two different tables but in same relationship path. However, it's not returning the correct result although the absolute values are correct as I can see by including those columns in the tooltip. Below are the screen grabs of the formula, the absolute values and the result of the formula in %. As can be seen from the second image below, Total Debt is 657,354 and Total GDP is 240,216, which are both correct but the %
Zoho CRM/Projects/Desk
I'm using Zoho Analytics to report on a few combinations of items that relate to Accounts (CRM) being associated with Tickets (desk) and Projects (projects). For example, I have an account in CRM "ABC Corp" and in CRM I've linked a project from ZProjects "ABC Project." I would like to be able to create a report that shows me how much time I've logged for the Account across all of their linked projects and helpdesk tickets, however I can't seem to find the one-to-many key fields that make this type
Zoho Analytics Release 4.0
We are happy to announce the much awaited Zoho Analytics 4.0 public release. Zoho Analytics comes with several exciting features and a fresh look that you will love. Here is a summary of what's new in Release 4.0 Reporting to Analytics Zoho Reports is now renamed as Zoho Analytics!! Since we offer in-depth data analytics beyond reporting already, it is only fitting that we make this name change to reflect the power of the product. Refreshed User Interface Introducing an all new user interface with
Zoho inventory table
I have a new client that use Zoho Analytics for doing reporting on Zoho Inventory. It’s a bakery. In sales order we have all items that have been ordered by his clients. We need to do a report by items to have the production scheduled. We need to sum all orders by items for each expected delivery date. We have activated Zoho Analytics with their Zoho Books account, but I only saw the table on Sales Order with subtotal by order. I don’t have all items by sales order. I guess it’s like Sales Invoice,
Cannot open dashboards
I'm unable to open dashboards I made or the associated query tables linked to those dashbaords, and I keep getting shown the same error message: Alert Message Sorry, an unexpected error occurred 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.
Cannot close the announcement page for 4.0 release
Hello. When I open the Analytics app I get an announcement for the 4.0 Release which completely blocks my page from opening (see th attached image). How do I close it? There's a "next" button but when I click on it nothing happens
Cursor Position when editing SQL queries
When Creating or editing an SQL query I need to move the bottom of the query box up and down frequently to show or hide the bottom panel. To get the mouse in exactly the correct position to show the double arrow symbol is very difficult. Is it possible to enlarge the area where the double arrow shows to make this easier and quicker.
Show percentage of a value other than total
Hi Newbie to Zoho analytics so please excuse my ignorance. The chart below shows the appliances that householders had fitted in their new kitchen. The percentage figure is showing the percentage of the total count (2128) but I need this to be the percentage of the number of respondents in the survey (503). Can this be done? Many thanks in anticipation Jane
Count all Yes from radio button
I have a multiple fields with radio buttons. For all these fields only the option to select Yes or No. I would like to get a count of how many times the value Yes was selected in the row. Something like Yes + Yes + No + No = count the yes Field 1 + Field 2 + Field 3 + Field 4 = Countif YES = 2
Connect to Shipstation's API
Shipstation is a very big service, with lots of users, tons of order data.....and poor un-customizable reporting. This is perfect for Zoho analytics. The Shipstation API is modern and efficient. Today I think many people pay Zapier to get Shipstation data into Reports/CRM/Books - why not have a direct connection? -can pull in shipments via webhook or polling. -also nice to pull in order data along with shipment data
file: protocol in URL
Hello! I make a field with a URL. Links on the protocol http: and ftp: work. But file: links do not work. What to do?
Report to show most recent case for all accounts
I need a report to show the most recent case date/time for all accounts, so I can see which accounts require more immediate attention.
Next Page