Calculating Working Days in a Month
Hi there, I need to be able to calculate the number of working/business days in any given month. I have found existing functions for SQL such as the below: (DATEDIFF(dd, "Month", DATE_SUB(ADDMONTH("Month",1),1)) + 1) -(DATEDIFF(wk, "Month", DATE_SUB(ADDMONTH("Month",1),1)) * 2) -(CASE WHEN DATENAME(dw, "Month") = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, DATE_SUB(ADDMONTH("Month",1),1)) = 'Saturday' THEN 1 ELSE 0 END) However it seems that Zoho does not recognise the "dd" or "wk"
New Features rolled out on April 19, 2017
Beta Release: Teamwork Projects Advanced Analytics Add-on We at Zoho Reports are very happy to announce the release of Zoho Reports Advanced Analytics Add-on for Teamwork Projects (Beta). This add-on empowers the users of teamwork app with advanced analytical capabilities thereby giving a greater visibility & control on their project execution. The Teamwork Advanced Analytics connector comes bundled with over 50+ default reports and dashboards that will help you keep track of your Key Project Metrics.
Widget - Choose source table/query list not alphabetized
In a Dashboard, if you select "Add Widget", the drop down list of potential table/query sources is not ordered in any way that makes sense. For users like myself that have 100+ tables and queries in a database, it is incredibly annoying to have to scroll through one by one to find the correct source. I would think it would be in alphabetical order like other lists. Thanks.
Duplicate Values when using Look-Up columns to generate reports
Hi All, I have 2 Tables [Employee Data Leave and Tasks]. I have done Look-up using common Field [Employee Name] I then created report based on below values: X-Axis - Date Y-Axis - Total Allocated Hours [From TASKS table] - Total Daily Working Hours [From Employee Data Leave Table] The actual value of Total Daily Working Hours is = 8 Hours for January 2017. The Report is showing Total Daily Working Hours = 16 Hours . [This is Incorrect] The reason it is showing as 16 hours is because it
Problem with old/new Charts
Dear Zoho guys. I'm concerned about the following issues I'm facing in a Combination Stacked Chart: Issue 1: When I use the OLD Graphs in a combination stacked chart, the bars are shown stacked but the line are shown in the same scale. Whet I turn into the new Graphs the bars are still shown stacked and the lines are ALSO shown stacked (here is my problem, I need to show both lines under the same scale): Issue 2: When I try to show numeric values in a chart, everytime i Try to show values with 0
Multiple Color combination for Text Field in Charts
Hi All, I have a Report that has a "Text" Field [In Edit Design] values as "Billable" and "Non-Billable". My other fields such as X-Axis, Y-Axis, Color, and Size is already filled. My problem is I am getting the below Chart with both "Billable" and Non-Billable" in the same color demarked by only a LINE as given below: Does ZOHO has the ability to apply multiple colors for the same "Text" Field? I want different colors for "Billable" and "Non-Billable" demarked by a LINE. Please see the attachment
Custom Module connecting Potentials and Leads
I created a custom module called Partners. I put a lookup field on the Potentials and Leads module linked to my custom module (Partners). I want to make a report that lists Potentials and Leads for each Partner. However I go to create a report with Partners, and do not see Leads nor Potentials listed. How do I do this?
Edit report scheduling
Hi - I am trying edit the emails within reports that are already scheduling and I've reviewed the Zoho documentation and other questions on here however I can't find anywhere on our system which shows the email schedules or anywhere within the report itself to amend the emails. Please help. Thanks
New Features rolled out on March 30, 2017
New Packed Bubble Chart type for Zoho Reports The Packed Bubble chart type is used to display data in a cluster of circles or bubbles. They are used to display the values disregarding the axes. The difference between a normal bubble chart and a packed bubble is that the latter is tightly packed rather than spread over a grid. You can use a packed bubble chart to visualize large amount of data in a small space. Please do note that, this chart type is available only as a part of the New Charts feature
Widget Font
Dear Zoho Guys. Is there any way to increase the font of a widget? Currentle the highest value is 72 and I need at least to double this value. Can you help me to do this? Thanks
Not able to see Add Custom Formula
Hi All, I am unable to see "Add Custom Formula" option for my Tables. I can only see the below options. [Please find attached the snapshot] "Add Formula Column" "Add Aggregate Formula" Thanks, Vikram
New Features rolled out on April 4, 2017
Zoho Finance Analytics expands with support for Zoho Invoice The Zoho Finance advanced analytics add-on (so far called as Zoho Books Advanced Analytics) gets much more power packed with the Zoho Invoice integration. You can now import your Zoho Invoice organization data into Zoho Reports for advanced reporting and analysis. Till date, this add-on supported analytics only for Zoho Books. From now on you can import and analyze both your Zoho Books as well as Zoho Invoice modules. We have plans to support
IPhone - Pivot/Summary View
My reports have Pivot View and Summary View. We use iPhones to view the report; It was working good till March 23rd. Suddenly it stopped displaying values. The reports are not showing correctly on phones; The details are not coming up. I already tried to contact the support team and left voicemails and email. Nothing back from them yet.
How to make an aggregate formula COUNTIF with 2 conditions
Hi, I'm trying unsuccessfully to create an aggregate formula that counts items if 2 conditions are matched. I thought this would work: countif("Sales Data"."Adhesive"='Yes',"Sales Data"."SalesAgent"='JH',NULL) But it doesn't, the first part works, but the second part doesn't. Please can anyone help me with knowing how to do this successfully? Also, is there a way to define in the formula which column it counts if these conditions are met? Thanks Jon
New in Zoho Reports: Scheduled Emailing of Reports
Scheduled Emailing of Reports Zoho Reports now supports periodic emailing of reports. Tables, charts, pivot/summary tables, dashboards can all be scheduled to be emailed. You can choose from a variety of scheduling options: Daily - repeat every [x days] Weekly - repeat every [x weeks]; repeat on [week day] Monthly - repeat every [x months]; repeat by [day of month] or [day of week] Yearly - repeat every [x years] on [y month z day] Scheduled emailing is now available for all paid users of Zoho Reports
Google Analytics: non-Adwords cost data
Hi! I use several ad systems except Adwords and import cost data into Analytics directly. Can I import those data into Reports database now?
New Features rolled out on March 23, 2017
Microsoft Dynamics CRM Advanced Analytics (Beta) We at Zoho Reports are extremely excited to present to you the Microsoft Dynamics CRM advanced analytics add-on (Beta). This add-on empowers you with analytical capabilities over your Microsoft Dynamics CRM data thereby giving you a greater visibility on your Sales data. The add-on comes with over 100+ handpicked reports and dashboards that you will find of great value. You can also create insightful reports to predict your sales pipeline, know your
Day End in local timezone instead of GMT
I don't understand why Zoho Reports automatically changes the date at midnight GMT.... it should be the local time zone of the user ... I don't care what time your day ends for reports I'm concerned the date where I am
Reports by Client for Zoho Projects
I am using the Advanced Analytics add-on for Zoho Reports and I am trying to create a report which will report on the following for each account by month: Projects (Open) Task lists Open tasks Closed tasks % complete Projects (Archived) Closed tasks Date of archive (Accounts have been associated to Projects in Zoho CRM and synced to Zoho Projects.) I cannot seem to find a way to identify the account in Reports. Can you please advise? (Note, we are not using time logging and we have no need to time
Problem in Dashboards
Hi Team, I had prepared a dashboard which was working properly last week. Suddenly today it is taking lot of time in loading the dashboard through link and even unable to do correction in Dashboard Page. Please check and update ASAP. Regards, Anil
Table does not update real information
I have one table in zoho that I need to update everyday, the problem is that if the query i am using does not retrieve any row, the table keeps the information for the last day, showing old information This is the parameters i am using for the upload tool: <Query dbname="ReportingDB" tablename="MacCalls" importtype="TRUNCATEADD" matchingcols="" selectcols="" skiptop="" batchsize="1000" queuesize="-1"> How can I make the table update information even there is not information retrieved for the query?
ZOHO Reports Regarding
Hi, In ZOHO Reports if I want to get list or count of tasks that I have worked on a particular, how do I get them. The start date could be in any other date, but worked in current week.
ServiceDesk Plus Region
Are there plans to incorporate the ServiceDesk organizational details into Zoho Reports? We have our organization mapped out the regional level and it would be nice to produce rankings and drill down reports by region. Craig Rice
Parameter in a Query
Hi, I have a query that includes the typical FROM a date TO a date. I change this FROM / TO value all the time and I have to change it manually in the query all the time in several sentences. Does someone know how can I make to select the FROM date and TO date just one time, maybe in a kind of form previous to run the query? Thks for your help! Enrico
Filtered tabular view in Zoho Report Dashboard
Hi, is thera a workaround to put in a dashbaord a filtered tabular view. Here is the example that I have: I have in a query table all information about deals. I would like to provide in a dashboard tree tabular views that give info about renting, paymemt of commissions, direct sales. I do not want to provide the data in a single tabular view because e.g. the payment of commission report consist of 6 fields but direct sales tabular view of 15 fields.
Query table creation option to shared users
Is it possible to give a shared user option to create Query tables?
How to Rename a Column in Tabular View
Hi. I have found the instructions for renaming a column, but it appears to be different in Tabular view. There is no "Edit Design" button. I have tried all available menus and contextual menus, but I cannot see how to do this. Is it possible?
Does anybody dealer with ORA-01861 error with date?
I'm trying to export data to a table in Zoho Reports using Zoho Upload Tool. I can successfully run the query and get the results in Oracle (using TO_DATE conversion for text fields with date value), but using the exactly same query in database_sql_queries.xml gives me the following error when I run the UploadFromDB.bat: java.sql.SQLException: ORA-01861: o literal não corresponde à string de formato at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
Inserting a carriage return or new line in SQL code of a Query Table for readability
My queries are working correctly, this is a formatting question to make it easier for me to see the structure of my queries when I am editing them. In a SQL Query Table, the SELECT commands easily allow me to put each field on a new line by using the carriage return after the comma: SELECT "Table 1"."Field Name 1" As "Alias Name 1", "Table 1"."Field Name 2" As "Alias Name 2", "Table 1"."Field Name 3" As "Alias Name 3", etc. all I had to do was hit "Enter" after the comma. When I hit
Records being truncated by 10,000 rows exactly
I have been using the UploadfromDB.sh tool for a few months now and it has never given me a problem. However, when i'm trying to load a new report it truncates the data exactly by 10,000 records no matter how large the data set. The database that I am pulling records from grows daily so the records uploaded grows daily. Yesterday the number of records the tool says were written was 24367 (which is the correct number) but the report on zoho.com showed 14367. Then when I tried it today the upload tool
New Column Is Not Calculating
Created a new calculated column in our request table but it is not calculating all records. The calculation is: datediff(curdate(),"Completed Time") and the column name is Days Since Closed, numeric. What am I missing to get this new field to calculate correctly? Thanks - Craig Rice
Zoho Reports
Hello, Is there a way to pull reports for individual users?. Example: We have a small sales team and need to track progress of individual users ideally with out running independent reports for each, or at least filter. Thanks, -Wyatt
Shared report with variable filter not opening
The user with whom I've shared a report using a variable filter is not able to view the same. He encounters the time-out error. Report name is 'Dashboard-Micro-YE'. What could be the reason? I've shared the DB with support to look into this.
Filter using row numbers in pivot table
In a pivot chart, is there a way to filter the chart using the row numbers that are provided by Zoho? My use case is that I am using the pivot view to display individual rows of data from my table (without showing all of the data columns using a summary or tabular view). I want to filter so that the report does not display any data if there are less than 5 rows of data. I've tried building an aggregate formula to count on a field, but the field counts are unique to each data row since I'm displaying
Filter using row numbers in pivot table
When creating a pivot view of data, is there a way to build a filter using the row count that Zoho Reports automatically creates? The use case is that I am using a pivot view to show individual rows of data. I want to limit the pivot report so that it does not display if there are fewer than 5 rows of data. I've tried building count aggregate formulas and use the aggregate formulas to filter the data, but this does not work because I'm trying to show individual rows, so the count is always 1.
Query Sorting Records First Entry By Group
SELECT "IORef", "PaymentDate", SUM("FCIRecognition") FROM "Dave Live - Income Details" GROUP BY "IORef", "PaymentDate" I wrote the above simple select query - I would like the result to be that for the 'IORef' the earliest date for each 'IORef' is only displayed. So for example, using the results below only row 1 and 11 would appear IOB00000004 - 2016-01-28 35.32 IOB00000009 - 2016-01-22 0.51 I have 1000's of rows that I would like the earliest instance of the 'IORef' to only appear in the
the report brings an incorrect result
Hi, I'm doing a report. But the result seems wrong. I want the users to see only the lastlogindate in the report of 1900. the users that a value is true I want to see. The Result Seems Wrong. MY TABLE SAMPLE MY REPORT FİLTER : As a result of the report from: when I questioned the data, I see that people in that position who do not meet this criterion affects reports, and report the result seems wrong. Please help
Reports Status
Is there a service that displays the status of Zoho servers? At times, we notice a performance drop in the reports and would like to know if the problem is on the servers where Zoho reports is hosted.
Zoho Offline
Hola. Saludos. Existe la Posibilidad de Trabajar con ZOHO "Offline"? Local? Gracias
Formatting not working within tooltips
None of the formatting, whether for Y-axis or Tooltip columns, are working within the tooltip message area of New Charts.
Next Page