Configuring the Zoho upload toll to run on the Server with rhe scheduled cron.
Can i configure Zoho Upload tool to be running on My Linux server. I want it to automatically be uploading data with the cron Job on my Linux server...
UMBRAL (solicitudes Varias)
Saludos. He estado configurando en Parámetros la opción del Umbral y quisiera hacer varios aportes al respecto de forma que puedan incluirlos en sus tareas por evaluar y lograr una nueva mejora en el producto (si este no lo tuviese). 1) Colocar el Valor numerico del umbral visible en el Grafico y poder darle formato (Tamaño, Tipo, Negrilla, etc) 2) Poder Modificar el formato de la linea del umbral visible en el Grafico (Tamaño, Tipo, espesor, Negrilla, etc) 3) Poder establecer un Umbral bajo el
HTML edit mode of Dashboard view stripping out Style tags
Good morning, My organization uses hand-written HTML tables with style (because Zoho dashboards only support two columns, making them useless for production reports). Recently, the "html" edit mode of the Dashboards editor has started stripping out style tags, which prevents our table formatting from working correctly. Can we have the use of style tags restored?
NEW Contacts by Day Count
I just spent a couple hours trying to figure this out myself, then another hour with chat support trying to figure this out. I've been told by two chat agents now that what I'm trying to do is not available. I find this super hard to believe. I would think this would be a canned report that EVERY customer needs. Simply: Bar graph showing new customers (contact records) by day for the past 7 days. Mon 7 Tue 5 Wed 10 Thur 9 Fri 2 Sat 11 Sun 4 Why is this so hard in Zoho Reports? Doesn't every single
Can you make report for Outstanding Sale Invoices for Customers & Bills for Vendors
HiCan you make report for Outstanding Sale Invoices for Customers & Bills for Vendors which only show fully or partially unpaid Sales Invoices and Vendor Bills. Currently there is statement which showing all transaction which are closed (Payment received and payment made). Regards Muhammad Younas
Mongo refrence not works
Hi, Try to load data from my MongoDB But reference type give null in Zoho Report { "_id" : ObjectId("57baba1ce4b039915181cf08"), "_class" : "com.myapp.entity.ActivityEntity", "act" : "ORDER_CUSTOMER", "use" : "momo", "oCstM" : "57baba1ce4b039915181cf07", "creDt" : ISODate("2016-08-22T08:38:52.300Z"), "ord" : { "$ref" : "order", "$id" : ObjectId("57b6a733e4b03991517a5332") } } "ord" give null "ord.$id" give null too Help Regards
Import CSV with UTF-8 or any other encodign
I've tried to import utf-8 encoded csv data. The imported result is garbled. For instance "Jānis Actiņ�" gets imported as "J?nis Acti??" or "Jānis Actiņš" The same thing happens importing either from file or with copy-paste from clipbord. I tested with utf-8 and with window-157
Mongo queries with date not works
Hi, I'm trying to query a collection and filter by date. Query woks in mongo shell but not with Zoho Report Upload Tools <Query dbname="mudb" tablename="order" importtype="UPDATEADD" matchingcols="_id" selectcols="" skiptop=""> <CollectionName>order</CollectionName> <FieldNames></FieldNames> <FieldAliasMapping></FieldAliasMapping> <Find> { "creDt": {$gte: ISODate("2016-08-21")} }, {"pjQ": 0, "pjP": 0, "billS": 0, "billC": 0, "advPay": 0} </Find>
Filters: Using Range + Needing Further Filter Criteria
Hello, Yesterday I had to use a combination of Zoho and Excel, and I am hoping that there is a way to do all of the following in Zoho. Here is an overview of the report needed and my process: The ask: 1. GROSS revenue of > $10/month each month: a. From Jan-Jun 2016: 6 months total. What's the number of unique segments, with above condition of gross revenue. b. Same as "a." for Apr-Jun 2016: 3 months total. My Solution (via Zoho + Excel): Zoho: Used the Range
Feature Request: Size of "dot" in scatter chart, related to number of records matching that criteria... i.e. Bubble Chart in Zoho Reports Please.
I have a graph of Min and Max hours on the x, y axis. I would like the ability to create a bubble chart in Zoho Reports. That is, size of the bubble at certain point (say 5, 10) would be relative to the number of records with those matching values. So if 10 records have (5 ,10), and 5 records have (4, 16) , the bubble at point (5, 10) would be twice as big as the bubble at (4, 16) Currently, the scatter chart, shows all the data points, but I'd like the size of the bubble to be related to number
New Features rolled out on August 24, 2016
Chart Chooser Dialog Revamped In our continued efforts to provide visually rich and powerful chart engine, we recently revamped our entire charting library and announced its public beta. In continuation of that, we have now revamped our Chart Chooser dialog. Our new intuitive and smooth Chart Chooser dialog will help to preview the chart types available and switch between them real fast (with lesser clicks). This dialog can be invoked using the Other Charts option in the toolbar. Try out and post
Change scale for time spent
Is there a way to change the format of the time spent field from hours to minutes? When creating a report with Average or Sum of 'Time Spent by Hours' we notice that Technicians who enter time of less than 1 hour in the Worklog appear in the report as working '0' hours. For example: Technician A closes 4 tickets with 15 minutes spent per ticket. The report shows their time spent as 0 hours instead of a sum of 1 hour. Same result for Average time spent -- appears as '0' instead of 0.25 hours. Technician
Average on a time: how to include periods with no data
Hi guys, I want to build an average hourly revenue report for some period, for example, for a month. If I count it manually for 00:00-00:59 I sum all revenues from 00:00 till 00:59 and divide by number of days I want to get average for. In Zoho Reports I've made an aggregate formula for Sum of Revenue: sum("Sales Raw Data"."Revenue")/count(Distinct(date("Sales Raw Data"."Purchase date"))) and then tried to build a chart with hours on X axis. The problem is that the aggregate formula doesn't include
Weighted Monthly Revenue Forecast
I want to add a chart to the dashboard that shows weighted monthly revenue forecast. I am able to create a stacked bar the shows monthly volume based on closed date, but have not been able to figure out a similar chart for weighted revenue.
Reports on Shared Database
Hi guys, I have an admin account when I upload my tables (two for a while). I shared this tables with one user and when the user try to create a report based on a table, the system ask to save on "My Reports" folder. After saving, the user cant find this folder, even the report. How/Where can he find the report saved? Thanks.
Can't see Account Name on Activity Report
Hi, I have created two different types of Activity Reports: 1. sorted out according to: a) Industry b) Account Name c) Project Name (own created name) 2. sorted according to: a) Account Owner b) Account Name c) Project Name (own created name) My Problem lies in report number 2. It shows me the column called "Account Name" however none of the fields are filled in. In other words I have an empty column called Account Name without showing me any names. How can I get all these names back on my report?
Table name as user filters
Is it possible to add Tables as user filters? To elaborate and as example, I have financial information (e.g. Sales, Profit) of companies in U.S.A and China in two tables called 'USA" and "China", respectively. Both the tables are structured uniformly with identical column names and data types. I would like to have a filter to let users select the country (in other words, the TABLE) first. I don't want to merge the data into one table because number of records per country are huge. On the other hand,
No.of Days in a month
Hi Is there any function to know the no.of.days in a month ? Regards Smitha
No. of Drill Down Levels
Hi, Is there any limitation to set drill down levels. In date field, i can set 5 drill downs. But i can set drill down Store->Category-> Sub Category. But can not set Store->Category-> Sub Category->Product Regards Kiron
Continuous data in line chart
Love the new version of charts, but there's one issue that is problematic for me. In the prior version, the smooth line chart would maintain a continuous line along a date axis, even if there was missing data for a given period. This is not true in the new version. The use case is that I want to show actual sales vs. weekly sales targets (straight-lined) across the year. So, if you're in the 6th week of the fiscal year, you want to see just the first six weeks of sales but the full 52 weeks
if syntax with boolean
why don't work expression "if("Student"='true',1,2)", when "Student" is Y/N type
Variable Parameter
I have a json weblink and I have few parameters. How can I keep a variable parameter like "fromdate" and "todate" so that iI can generate the reports for any dates as needed.
Report - Sync Data
Hello, I currently use Pipedrive as my CRM software. I love it for my staff but I the reporting and dashboard falls a little short. I would love to use Zoho reporting but I am trying to figure out how to intergrate them seemlessly. I have used 3rd party softwares such as Zapier to sync data in the past but my data changes so although Zapier can add a row to the Zoho database it can not update a row. Does anyone have a solution? Seeing the changing data is pivotal for me. I really wanted to see
Zoho Projects "My Calendar" in Zoho Reports
Is there a way to build a report in a calendar format that will pull my task over from Zoho Projects?
Duplicate dates on Group By
I have date column in query table where it is formatted with date+time. Now when I query table because of time with date group by clause returns duplicate rows. I wan to remove the time field from the table. I tried changing date format in base table but it don't work.
Pie Chart - Value not showing.
Hi, In Pie Chart Settings, there is an option to show Values by checking Value. But when selected both Value and Percentage, it does not show Value or percentage. In Tool Tip in Pie Chart, Value Field shows 5 or 6 decimal places. Is there any option to format this ? I think instead of giving option to format everywhere, it will be better to add option in the table design. By default take it from there. Regards Kiron
Stipulating a Range in if statement
This if statement works and gives 3 outputs. if("score" > 75, 'Good', if("score" <45 , 'Poor','Average')) I now want to split the Average range i.e. 45-75 into 2 categories - 45-60 Below ave and 61-75 Above ave but don't know how to stipulate the ranges. Want something like 45-60 or >44 and <61 - How is this done? Regards Mark
Edit Custom Formula - Zoho Reports
Hello, I have added several Custom Formulas in a large Table in Zoho Reports. I want to edit one of these formulas. When I click "Edit Formula," the window that pops up is to "Add a New Formula," and I'm unable to make changes to my existing formulas. Any tips on how I can simply edit vs. add an entire new formula? Thanks
Extending if statement output to more than 2
I'm using this formula that works - if(("score") > 75, 'Good','Poor') This recodes score into two answers. What is the formula code for something like - i.e. 3 output options If score > 75 'Good' If score < 40 'Poor' Rest 'Average' I'm using Zoho Reports. Think answer lies in "Else if" but can't find an example for Reports. Regards Mark
Recode a numeric field into a text field
Im struggling with this. Have a numeric field Scores.I want to make a new custom column where Scores >50 are "Good" and Scores <51 are "Poor". Trying variations of if("Score">'50',"Good","Poor") ....... but keep getting errors. Any assistance appreciated. Regards
No of items in the Pivot
Hi, In pivot table, why all the items not showing. I have a customer analysis. In the table, there are 1200 agents. but Pivot is showing only 32 customers. Is this a intended behavior ? Or Can i configure the no of Customers to display ? Regards Kiron
Average Value problem
Hi, I have table with fields "Sales Value" , "No. of Covers"and "APC". The value of APC is Sales Value/No. of Covers. I want to Analyze APC. I have given APC (Avg) as Y Axis. and Year as color. But when drill down it does not tally. What is the solution ? Regards Kiron
Option for Custom Season
Hi, Is there any option to create "Custom season" for date field. I am working for a Hospitality. In South India, there are 3 seasons, ie. Apr to May, Jun to Sep, Oct to Feb. Now I can analyse compare yearly, quarterly or monthly. But can not compare values to same seasons. If there is an option to create seasons globally and select in report's drill down path, it will be great. I think this seasonal sales are very common. Regards Kiron
Contar Tres Valores diferenciados en un solo campo
Saludos. Poseo tres Valores en un Campo (A,B,C) y deseo hacer un gráfico combinado con esos valores de forma que me permita contabilizar la cantidad de cada valor en un rango de fecha. Este es el tipo de grafico que deseo hacer, solo que en este caso cada valor se encuebtra en un campo diferente. Gracias por su Atencion. Saludos. Adel Bahsas.
Zoho Reports - Time to Breach SLA
Hi We are trying to create a report which lists Requests that are due to breach their SLA. This will give technicians a visual reminder to get these requests done. Ideally this will be separated by requests that are due in the next 1 hour, 2 hours, 3 hours I have been advised that this may created using a custom formula. I am unable to work out a formula that would give us this information. Is anyone able to advise? Thanks Dan
Problem in setting Drill Down path
I was trying to set "Drill Down Path" bar chart based on the Date Column. When created a new report it inherited the Drill down path set in the column column of table. I unselected the Drill down check box in the report settings. But when reselected the check box, i can set Year->Quarter->Month. but not showing Week and day. Is this a known problem ?
Color in Drill Down
Hi, I have created a bar report using date column. and selected Year as the Color parameter. in view mode it shows in different color. 2014 in red, 2015 in blue, 2016 in green. but when drill down 2014, it shows in blue. It would be great if red bar drill down shows in red and green bar drill downs in green. it will be easy to understand
Question about titles of the pivot view
I have created a simple pivot view and I have a question about titles of the view. Title is a link to a table where I can see the data used in column. In table there is same row multiple times. Why is that? Number of rows is 295 which is more than a summary in my pivot view.
Is it possible to get two series out of a single column?
Hi Let's say, I have the below columns. Column Name (example of data) Year (e.g. 2000, 2001) Country(e.g. India, China) Sex (e.g. Male, Female) Population (Numeric field) I want to plot two lines, each one to show population of India and China for years 2000 to 2015. Not sure how to achieve this simple-sounding objective because population of all countries, years and sex are in the same column 'Population'. Thanks for any help.
Displaying Table and Chart in a single report
Hi All, I have been experimenting with Zoho Reports. Is it possible to display tablular data and graphs in a single report? I am not able to find this option anywhere. Thanks in advance. Regards, Darren
Next Page