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
The Weather Forecasting Systems Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Weather Forecasting Systems Market” is published by Whipsmartmi.com Keywords: global weather forecasting system market, global weather forecasting system industry, big data analytics market, weather
The DC-DC Converter Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “DC-DC Converter Market” is published by Whipsmartmi.com Keywords: DC DC Converter Market, DC DC Converter industry, DC DC by input voltage market, DC DC by output voltage market, DC DC converter power
New Features rolled out on Mar 04, 2021
Share Slideshow UI Revamped with More Interactive Options! The Create Slideshow and Manage Slideshows pages have been revamped with more interactive options. The new UI captures: Slideshow Preview: You can now preview a created slideshow in the Copy URL
Multiple choice
I’ve imported a CSV file from Google Form. Some of questions in Google Form are multi choice. When I save the CSV file, the multi choice are saved with “;” between each one. Can you explain me how to handle these data in Analytics to make reports, chart,
The Flight Simulator Market Detailed Analysis Of Current Industry Trends, Growth Forecast To 2026
Summary: According to the new market research report “Flight Simulator Market” is published by Whipsmartmi.com Keywords: flight simulator market, flight simulator industry, aviation safety market, pilot training report, commercial aircraft market, military
Duplication of a widget is not working "viw is not present in the workspace" message
Upon duplication of a widget this what I'm getting
How to group clients by age range?
Hi all, I'm trying to create a graph with the client's age range (18-24, 25-35, 36-45) from the date of birth. How can I do it? I already tried everything but didn't find any way to group by age range. TIA
UN/LOCODE
For Geo Mapping, I suggest to use UN/LOCODE which will take care of Airport and Port codes. https://www.unece.org/cefact/locode/service/location There are similar requests for airport code, my request if for port codes. Both of these will be taken care of by using the UN CODE. Best regards, Sony
Using Analytics as Zoho One user
Hi, We are Zoho One subscribers, and we want to use Analytics across different departments. However I see that only Zoho One Super Admin (ie called Admin in Analytics) is allowed to create, import, edit Analytics workspaces and data. Users can only get a view. We need sales people and BI people to manipulate data and dashboard, but are unable as we can't share Super Admin credential with them (for security reason obviously). What do you suggest so that BI people can build their metrics. Zoho One
"Performed changes in the query is not allowed due to following reason" when adding columns or reordering data
I'm trying to make changes to a query but every time i try to save it i get this error message. I'm not touching the data it's flagging. All I've tried to do is reorder a couple of fields and add a new one. Why won't it let me do this? It's a core
Next Page