Export as HTML error
Hi, I have a dashboard and I'd like to export it as a html. When exporting it as html the export file contains an error, when I try to send it by email as an attachment I get the following error: Could you please support me on this? I've shared the dashboard
Report Condensing
As I start a new financial year for a dashboard tracker, i'd like to only show the last previous 3 months as I add the new year. Is there a best way to show this without creating a new dashboard? Thnaks
Date Filtering - Why So Difficult?
Why is it so difficult to date filter across data sources? I have two Creator forms that I have as data sources. Each has a date field. I can make a Summary Report that has columns from both forms as well as calculation columns that calculate values based
Track Conversion rate between stages inside Deals Module
Hi, There exists a feature to track the conversion rate between the modules in CRM. say: 45 % conversion rate from Leads to Deals as you can see in the below screenshot. This can be assessed by going inside dashboards-> deals dashboards-> add component->
Set Geo data type for Zoho CRM Analytics
It would be nice if we could use address, city name or zip code from Zoho CRM standard fields to generate Geo Map chart. At this moment, when I try to change the data type to Geo, let say Country or Zip code or City, it says : "Sorry [TableName] is a system table in this workspace. You cannot modify its design" I was told by Zoho Analytics support to get in touch with Zoho CRM to change the field type, but that has nothing to do with data source... it is related to mapping in the Zoho CRM connector.
Comparar datos de un mes respecto el mes del año anterior.
Me gustaría comparar los datos de un mes en concreto respecto los datos del mismo mes del año anterior y cuando cambie el mes natural, automáticamente se actualice solo. Por ejemplo: Ahora me gustaría ver las ventas del mes de marzo respecto a las ventas
Filtro por fechas de diferentes tablas.
Hola, Me gustaría saber si en un gráfico tengo dos valores en el eje Y que provienen de diferentes hojas de datos ¿cómo puedo poner de filtro la misma fecha? El campo fecha está en cada una de las tablas de datos.
Woocommerce Product Table List
Hello EveryOne, WooCommerce Product Listing Plugin is the Easiest, Fast & Awesome way to list your WooCommerce Products Items in responsive, user-friendly table view or order form with a quick view option.
Error de sincronización con zoho databridge
Hola! Tengo una consulta de SQL Server que se sincroniza c/3 hrs, desde el viernes pasado marco un error relacionado con Databridge, revise las conexiones y aparentemente todo esta bien. Revise la conexión a detalle y me sale este tipo de error Se revisa
IF statement to Convert TZ before and after time change
Hello! Background: I use "convert_tz("last_received_at", '+00:00', '-05:00')" in a formula column to adjust a date from UTC into Eastern time. After the recent time change for Eastern, I need this formula to continue to adjust for -05:00 before March
Ask the Experts #18: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event - Ask the Experts #18 on 24 March 2021 between 05:30 AM - 10:30 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion with
Baseline Data missing from Zoho Analytics
Baseline data is not available in the standard projects data extract making reporting to baseline impossible.
How to modify query from a DataBridge Connection
Hello, I just installed the new DataBridge tool to import data to our Zoho Analytycs account from our local database. It works well so far, and data gets sync every day. The only issue that I found is that we do not know how to modify the query that imports
Dash with a default result
I applied a filter criterion to a report link. But by deleting the piece of the criterion, the user can see all the results of the report. How to leave the link with a default result ???
The Thick Film Resistor Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Thick Film Resistor Market” is published by Whipsmartmi.com Keywords: thick film resistor market, thick film resistor industry, Thick Film resistor report, thick film and shunt resistors market, thick
The Robo-Taxi Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Robo-Taxi Market” is published by Whipsmartmi.com Keywords: robo taxi market, robo taxi industry, robo-taxi market, robo-taxi industry, Robo-taxis market, robo taxis report, robotic assistance market
The Railway Cybersecurity Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Railway Cybersecurity Market” is published by Whipsmartmi.com Keywords: railway cybersecurity market, railway cybersecurity industry, railway ecosystem market, railway traffic management systems market,
Is it possible to remove the names of city / region / country on the Map - Scatter chart ?
Hello, I would like to see this map without the labels ! Is it possible ? Thanks
The Electric Vehicle Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Electric Vehicle Market” is published by Whipsmartmi.com Keywords: electric vehicle market, electric vehicle industry, electric vehicles report, fuel cell powered vehicles market, FCEVs market, fuel
Graph labels
Is it possible to have a a graph with multiple columns where the column labels are shown below the grapth (instead in a legend like shown in the image here)?
The Electric Vehicle Communication Controller Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
The Electric Vehicle Communication Controller (EVCC) Market is projected to grow at a CAGR 29.12% rate from 2021 to 2026. The growth of the controller market is driven by the increasing demand for electric vehicles. The evolution of high-power batteries
The Automotive Pumps Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
The Global Automotive Pumps Market is projected to grow at a CAGR 5.49% rate from 2021 to 2026. Automotive pumps perform different functions including raising, compressing, or transferring fluids by mechanical action and facilitate circulation of fluids
Aggregate formulas in tabular view?
Why can't we use aggregate formulas in a tabular report? Why is such a simple feature missing? This says that you use aggregate while creating "all reports" and "as you would use a column in a table", but tabular reports are not included so you can't
The Blind Spot Solutions Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
The Blind Spot Solutions Market is projected to grow at a CAGR 11.97% rate during the forecast period. Factors such as increasing adoption rate of advanced technologies by OEMs, the introduction of stringent government programs pertaining to vehicle safety,
How to Connect with 2 different Organization with 1 Data-bridge
Hi, I have as issue I have 2 different Organization with 2 separate Database at 1 server and I have connected 1 Database to 1 organization using Databridge. But when I'm trying to connect with other Database with another user it's saying download Databridge.
The Automotive HUD Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Automotive HUD Market” is published by Whipsmartmi.com Keywords: automotive hud market, automotive hud industry, OEM technology market, passenger safety systems report, automotive hud key players market
Connectivity with SAP BW BEx Queries
Dear Zoho Analytics Team, SAP BW is an Enterprise Warehouse in SAP ERP and we have SAP Business Explorer (SAP BEx) tool to create reports on SAP BW. We can connect to SAP BEx queries using SAP Business Objects (BO), a reporting tool like Zoho Analytics.
Is there any way to translate months?
Hi, When i make a SQL Table i Want a column to have the month, but if I use absmonth() or month() I get the month name in english. Is there any simple way to translate the names to spanish?
Drill Down
Dear Team, Am trying to add all columns as drill down path using below option while sharing link. It is not working. Added in individual reports also, but some random column names come as drill down option.
ZOHO_CRITERIA not working with LIKE
API is working fine pulling data when using ZOHO_CRITERIA as $critera = "column = 'value'". However, in the API docs, it says that you can pass any SQL WHERE arguments including LIKE statements, which are not working. $critera = "column LIKE '%val%'"
Pivoting a selected dataset at source itself
Hi Team, We have Query table for Pivoting a dataset. But we don't have a feature to Pivot the selected dataset at source file itself. In Tableau, we have the functionality to pivot the selected dataset at excel file itself. We can see Pivot option at
How to get a Column Series into Rows Series in a Chart
I have data like the below table. Years are as column headers corresponding to City. City 2010 2011 2012 2013 2014 2015 2016 Chennai 12.5 22.5 34 23 36 39 45 Bangalore 23.6 24.8 30 34 34 38 49 Vizag 13.9 23.9 20 43 45 40 44 Hyderabad 34.8 44.8 39 23 36
Zoho checkout data in Zoho Analytics?
Is it possible to import Zoho checkout data into zoho analytics?
String Aggregate function
I am doing a summarize view but i have a problem where I want to apply an aggregate funcion in one string column to take a Max Value to get only one result, but there´s no place to indicate an aggregate function with text type.
Countif double condition
countif does not work with doble condition or expressión with logic operator AND Countif(("Ingresos Clientes"."OFICINA" = 'Veracruz') AND (Isempty("Ingresos Clientes"."CLAVECORRESPONSAL")) I've been recived an alert message which tells about a problem
[Webinar] 5 ways to supercharge your IT Help Desk with Advanced Analytics
Hi, The rapid adoption of remote and hybrid work models across the globe is disproportionately building pressure on IT help desks—adding more tickets to handle, assets to manage, projects to execute, and a lot more. Agility is one of the key factors that
Join in summary view
Hi, Can any one know how to join more then one table in summery view
Drill down on shared Dashboards
I'm sharing a Dashboard embbeded in my site whithout an user loggeg in zoho reports and the drill down feature doesn´t work. Is it possible to use dril down and data views whitout an authenticated user ?
Zoho Analytics - Sum how much time my Sale man talk with leads?
Hi, I was trying to create in Zoho Analytics Summary View which shows me on each salesperson how many minutes of conversation he made in month X The thing is that the field is in the CALLS module Call Duration is a text type and I can not do Sum Is there
GROUP BY with If statement and Table Join
I am attempting to execute the following query in a query table: SELECT "Filtered Gift Master"."Client" AS 'Client', "Match"."Match Amount" AS 'Match Amount', IF(SUM("Filtered Gift Master"."Amount") >= "Match"."Match Amount", SUM("Filtered
Next Page