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
Timeline Filter In Dashboards I receive NON-EXISTENT date column, for column that should be present
I have created a dashboard called "member & customer" counts. I have added a few KPIs, which I'd like to be filtered by the timeline filter. In one widget, I have the discount count of invoices, filtered by status = closed. This data is based off the "invoices(Apliiq)" table, a standard generated table from the zoho books integration. When I attempt to add the Invoice Date from the "invoices(Apliiq)" table, then click save, I receive the following error: " Non-existent date columns provided for
DateDiff but Working Days only
Hello, I would like to have use DateDiff but only considering Working Days, because I need to get the numbers of days between two tasks excluding weekends. I don´t know if this is possible with a mix of current formulas that are available or if a new one has to be created. BR, Edgar
User Defined Date Filters In Dashboard Don't Work For Widgets
I have a few widgets setup, and I'd like to filter them by date (New & Returning), I setup user filters in the dashboard, based on the date in that table (create_date). When I select a relative timeframe for that filter, the widgets using that data table are not filtered.
Calculation of correlation between two series
Is there a way to calculate correlation between two series? I tried both custom and aggregate formulae but couldn't make it. I guess the problem is correlation requires combining aggregate formulae (Avg) with custom formula (X-Avg(X)).
Incluir dos valores en una sola Columna
Saludos. Estoy deseando elaborando un Gráfico de Barras que permita evaluar los montos y las cantidades de productos vendidos en un solo Gráfico La Vista Actual es la Siguiente: Vista Deseada: Gracias por su atencion.
Counting empty cells in pivot
Hello all, I have created a pivot view and I have problem with empty cells. For some reason there is no calculated data in "Tyyppi count" -column in cases where the value "Tyyppi" is empty. How can I get this problem fixed?
How to optimize embedded views for search engines?
Hi, I'm an analytics startup trying to build my online presence with the help of Zoho Reports. I've embedded quite a few interactive views on my website. However, all my efforts seem to be coming to naught because Google is picking irrelevant words like 'loading', 'columns', 'filters' as keywords of my site, overpowering the real meaningful keywords. While I understand it is not an issue with Zoho Reports but how search engines see and index AJAX and other dynamic content, I would like to know if
Next Page