función "if" con algún caracter que cumpla la condición
Saludos. He usado la Función If con operador ">", "<" o con referencia de cadena de textos exactas. Mi solicitud en esta ocasión es la siguiente: Tengo un Campo de cadena de texto con varias palabras pero deseo categorizar esta información en un nuevo campo utilizando la función ÏF". Coloco un ejemplo para traficar la pregunta. Tipo de Estudio Área Rx TORAX Tórax EXPRESION: (if "tipo de estudio"contiene "torax", "Tórax", "XX")
Zoho to Zoho integration issues
Has anyone else noticed that Zoho products don't integrate well with each other? It would be great if before focusing on integrating more outside products they would focus on making sure their products (which are all paid for) integrate seamlessly.... 1) Zoho CRM to Zoho Reports - Why does this only update once a day?! It should be at the minimum every hour if not more 2) Zoho Reports to Zoho CRM - Why can't I view the reports I create through the Advance CRM Analytics in Zoho CRM... you have the
Regex/ Wildcards in User Filter search
Hi Let's say, I've a user filter called 'Industry', which contains, among 100 other values, the following- Consumer Services, Computer Services, Financial Services, Transport Services. I would like the users to be able to search for all 'Services' beginning with letter 'C' in the user filter, which in the above example should return 'Consumer Services' and 'Computer Services'. I tried using wild characters * and ? as I would in Excel, i.e. "C*Services" but it doesn't work. Is it not possible to use
Migrar a otra cuenta ZOHO Report Tabla de Datos y Graficos y Dashboard Asociados a esa Base de Datos
Saludos. En una solicitud anterior me fue explicado como migrar la base de datos de una cuenta Zoho a Otra. En esta ocasión requiero saber como trasladar también los gráficos asociados a esa BD y economizar el tiempo invertido en el desarrollo de los mismos. Gracias.
Maximum email addresses can be added in each email schedule.
Hi, I have to send a report to more than 5 users, at the moment I've created 5 copies of the same schedule to send the report to all users it concerns. Is there an easier way to send a single report to many users? Thank you, Andrea
Upload tool MYSQL query issue
I'm trying to upload from my MSQLD database with a query that changes the names of the columns to match my Zoho table. The query I'm using in database_sql_queries.xml is: SELECT count_endtime AS DATE, REPLACE (customer_id, '514', 'OZ')AS SITE, count_in AS InCount, count_out AS OutCount, count_occupancy AS Occupancy FROM `zone_activity` where customer_id = '514' ORDER BY `zone_activity`.`count_endtime` DESC This query fundamentally works, but it only changes the name of the customer_id
Date filtering using the user filter does not seem to work
Hi, I added a date user filter to an existing report. The date picker works i.e. select start and end date. However, when I click Go there is no change to the report. See screenshot. Can you confirm if the date picker user filter is working? Thanks Sunil
Zoho Reports Widget filters get applied to Report not vice versa
Hi, When i select User Filters for the Widget and select in the view mode , filter value gets applied to the Widget and report in the same dashboard but not vice versa; if i have filter on the report and it does not get applied to the widget. it appears that the widget filter is driving the dashboard. please see attached image. please suggest how i should i design the dashboard ?
User cannot schedule email
I have a need for users of type User (i.e. non-admin and non-database owner) to be able to schedule a Dashboard via email applying selected filters. This is no problem as administrator, but it seems the email schedule function is not available for Users?
New Features rolled out on December 15, 2016
Subtle Changes in the Home page Interface We have made the following changes in the Zoho Reports home page. 1. The Create Reporting Database option has been renamed as Import Your Data to reflect the first step any user would perform upon logging into Zoho Reports. You can continue importing your data from a wide variety of sources using this option as you used to with the create reporting database option. 2. The search bar in the Zoho Reports homepage has been made much faster. The search now suggests
Date Range More than 180 Days
Hi, Can we have report for more than 180 days, As it allows only for past 180 days report. Can we manage the date or extend the report for 365 days,
Monthly Customer Dashboard
Hi, I've always wanted a monthly dashboard style report for each customer. It could be a statement stuffer kind of thing. Is there a way in Zoho reports to print a dashboard for each customer? Can I clone a dashboard and set a filter for each clone, or is there a more elegant way?
TIME data is clipping. i.e. does not support MySQL documented '838:59:59' with Table Joins (Advanced Report Engine)
I've been informed one of our databases has been migrated to "Advanced Reports Engine" I've noticed strange behavior: According to MySQL: MySQL retrieves and displays TIME values in 'HH:MM:SS' format (or 'HHH:MM:SS' format for large hours values). TIME values may range from '-838:59:59' to '838:59:59'. https://dev.mysql.com/doc/refman/5.5/en/time.html Secnario 1: No Tables - On Advanced Report Engine ( Works as expected) Create a new Query Table with the following SQL SELECT SEC_TO_TIME(86399) as
Scheduled FTP import
Hi, I'm using FTP to import CSV files from my Magento Store. In the manual they show a scheduled import option for FTP, but I don't have that button: What is going wrong? I have the CRM Extra license.
New Features rolled out on December 1, 2016
Public Release: Xero Advanced Analytics Add-on We at Zoho Reports are extremely happy to announce the general release of Xero Advanced Analytics Add-on. Till now the beta version of this connector was only available for the paid users of Zoho Reports. With this general release it is made available for all the Zoho Reports users. The Xero add-on is priced at $15/month . This will enable you to import your Xero data into Zoho Reports, and avail all the features in the Zoho Reports free plan .
I have a problem with my email
I have been using my mail for a while and I never have problems, but today I can not receive emails, I can send but not receive. Why does this happen ? Please I need help. thanks
Sending failed;Reason:554 5.1.8 Sender Address Blocked
Hi There, please remove the block on our mail account. We are not able to send a single mail right now. My IP : 14.161.16.52 Thank you ! CÔNG TY TNHH TRUYỀN THÔNG VÀ DU LỊCH SAIGON STAR 62 Thành Thái, Phường 12, Quận 10, Tp Hồ Chí Minh, Việt Nam Email: info@saigonstartours.com Website : http://ngoisaotour.com/
What graphics are available in Zoho?
Hi all, Thanks in advance for your help. So I'm trying out Zoho, to replace our current dashboard software which isn't particularly user friend. As an initial testing I'm trying to recreate what we currently produce...however wanted to find out if additional graphics are available. I currently use some thermometer, dial style graphics...is there anything like this available in Zoho? Cheers, Jason
Número de registros en las Tablas Cargadas
Saludos. En ocasiones necesito conocer cuantas Bases de datos (tablas) tengo registradas y cuantos registros existen en cada una pero de manera practica. Existe la forma de saberlo en una presentacion (informe) tabular en algunas de las opciones del menu de suscripcion u otro? Gracias.
New Features rolled out on September. 27, 2016
Beta Announcements We are extremely happy to announce the Beta releases of two much-awaited integrations with Zoho Reports. Note As these integrations are currently in public beta testing you may encounter certain functional bugs and limitations. This add-on is currently enabled only for customers in the paid plan (Standard and above). We will come up with a pricing plan as a part of the general release. MailChimp Advanced Analytics Add-on (Beta) The beta version of Zoho Reports Advanced Analytics
Add an Edit Report Option to the Actions Menu
Hello Zoho Community, Currently, in order to edit a Query Table you are required to wait for the report to fully load. I'm a SQL Developer by trade and write some fairly complex reports... which have a tendency to timeout before I start optimizing the code (insert tears and lamentations here). Now, I know there is a "work around" where you open a faster table so that you have the edit button available and can jump in while the report is loading (probably a bug, but I see it as a feature :D). May
Export Information when Embedded on a Website
Currently, when you embed a report - perhaps a view or a table on an external site, you can run filters or sort the data, however there is no way of exporting this data (into XL or CSV or PDF etc) This simple feature would allow users to really start to syndicate reports with maximum control. Can you confirm whether this is on the Roadmap or if it is likely to be? Thx Cloud-Workforce.com
New Features rolled out on November 18, 2016
Improved Drill Down Feature (Available only in New Charts) Zoho Reports now allows you to dynamically select the drill down path from the Zoho Reports chart interface itself. Earlier, when you define a drill down path, you will be allowed to traverse only through the defined path. Now, the path that you define will be listed along with a wide list of connected columns that you can drill down with. You can also configure the list of additional columns that are to be listed as a part of the drill down
Unable to edit aggregate formulas
I don't know if something is wrong on the Zoho end, or mine, but I suddenly mid day today am unable to edit aggregate formulas. It will open the edit window and let me type, but won't let me save my changes, I also don't see the function names in the lower left anymore. Any idea what the problem might be?
5.1.8 Error
Hi, My account is blocked. I get an 5.1.8: Sender address blocked. Can you unblock my account please?
Report Column Width
Is there a way to adjust the column width of reports? I have 9 different columns which would fit fine on a standard 8 1/2 X 11 page in landscape view, but many of the columns are over sized so the document is autofit making it hard to read.
How to find rows used
Hi! Now that the Subscriptions page has been rebuilt, how do I find my current usage statistics for Zoho Reports?
Zoho Reports
Hi, I am new to using Zoho reports and was wondering if there is a way of changing the Customer ID field and Sales Person ID from number to text? I need it to show the name of the company and the sales contact's name. Thanks Katie
New Features rolled out on November 9, 2016
A simple approach to import data from Cloud Databases We are introducing a very simple model to import data stored in your Cloud databases such as Amazon RDS, Amazon Redshift or Microsoft SQL Azure into Zoho Reports for reporting & analytics. You can setup the import process using a simple setup wizard. Till now, users had to download and configure the Upload tool to import data from the cloud databases. This new model does not require any software to be installed. You can completely setup
Pie charts from Check boxes
Hi there, I have a form that integrates with Zoho reports. One of the fields are called interested. The user can select Car, bikes etc When I person choose Multiple choices it includes in the row in one column eg Car, Bikes The problem is that when I generate a pie report it output multiple choices eg Cars, Bikes 50% and Bikes 20% How can I separate these choices?
mixing databases for creating one single dashboard
hi, Please is there a simple way to create one single unique dashboard but from many databases without coding ? Thanks
Bulk Import via API failing, HTTP Status 500, Error code 7005
HI Zoho reports... I am trying to copy from one database into another. I select a query from database 1, table A and insert into database 2, table A. This works fine for "Table A"...but is failing for "Table B"... However, when I iterate through the list and call "addRow" on a record by record basis the data can be loaded. Here are my API parameters for the IMPORT: bulk_params={'ZOHO_ACTION':'IMPORT', 'ZOHO_API_VERSION':'1.0', 'ZOHO_OUTPUT_FORMAT':'JSON', "authtoken": Config.AUTHTOKEN, 'ZOHO_ERROR_FORMAT':'JSON',
Bulk Import with "String" (instead of File) / Add Multiple Rows
I would like the ability to add multiple rows in a single API call. My API code runs in a cloud task worker environment and I have a list of JSON objects in memory, that I can easily marshall / convert into a string ... I would like to be able to pass that String (list of rows to be added) to the API. Due to the restrictions of my virtual cloud file, I am not even allowed to create a temp file, to dump this list ot a file and then IMPORT the file. I am currently iterating the list calling the ReportClient
I can't change the currency format in zoho reports' zoho book extension
I use zoho books and zoho report. My currency is NOT $ in zoho books. But in zoho reports all the financial tables are in USD and it does not allow me to change the currency format.
Avg Packages per day
Hi, How to get average packages per day/month in a widget with the given data?
How to view more than 5 names
Hi I'm trying to figure how to view more than last 5 names on each list in the reports. Can you please advise? photo attached. You can explain the flow in English. Ill translate to Hebrew :) https://www.dropbox.com/s/gyztkefohdazjhp/Screenshot%202016-10-27%2016.31.49.png?dl=0
data connector to CRM Vtiger
Saludos. Quisiera saber si existe un conector para las bases de datos de vtiger o PHP y poder obtener información directa desde la Data. Gracias.
Unable to sort report columns
I have createda report, however I cant sort any of the columns (Asc,Desc). I have tried using the arrow in the column header and also tried the Sort menu at the top of the report window. Neither work. Does anyone know what the issue might be?
Creating Zoho Reports using data in Zoho Recruit
Hi, I am managing a group of my recruiters whom are using Zoho Recruits, therefore I would like to generate reports that will enable me to track the following aspects and etc. : 1) Recruiters Productivity - No. of Job Postings, Candidates and Clients 2) Progression of Stages of Job Postings 3) Sales Pipeline I want to create these reports based on the data present in Zoho Recruit using Zoho Reports. I am available for an online meeting anytime from 11am to 4pm tomorrow (14/10/16) My contact details
New Features rolled out on October 17, 2016
Introducing the Google AdWords Advanced Analytics Add-on (Beta) We at Zoho Reports are extremely excited to present to you the Google AdWords advanced analytics add-on (Beta). This add-on enables you to import your Google AdWords campaign data into Zoho Reports for powerful reporting and analysis. You can easily create reports to track your key ad campaign metrics such as best performing campaigns, conversion funnel, clicks vs conversion, ad analytics and much more... Click to learn more about
Next Page