Urgent ! Attention Required "Query Issues"
Hi I have two tables Testing101 and testing102 . testing101 has to columns A and B while testing102 has two columns A-1 and B-1, each has got two rows Now I want to sum up Columns A from testing101 and column A-1 from testing102, how can I do that? I am a novice and new to zoho, help me out ASAP !
QUERY issues
hi, i am using the sum query and using it to sum different columns from two tables but it is returning double the value than expected. can u plz urgently explain me why is it happening here's the query: SELECT SUM("A")+ SUM ("A-1") FROM "Testing101" ,"Testing102"
Combine values from multiple columns.
I am not sure about the best way to go about this so let me explain what it is that I am trying to do. I have essentially a golf score card with each hole as a column and each player score in the row's. I would like to create a pie chart that shows their percentage of 1' 2' 3' 4' and so on. I can easily do this for one hole by creating a pie chart. How could I do this for a whole game 18 holes not just the one? I was looking to do an aggregate formula and try to combine all columns but I am unable
User filtered dashboard
Is there a way to apply a user filter to a whole dashboard? I have a dashboard with 4 charts on it. I want all charts to be user filtered by the same criteria. I don't like the idea of making the user select a filter for each chart. Is this possible?
Desparate help please - reporter and creator
Dear Zoho Creator and Reporter Teams, Many thanks for your help – your apps have huge potential. I have a number of problems with using your programmes. I am attempting to use Zoho Creator/Reports to run a live audit tool, which will real-time produce reports regarding the data stored - this is potentially to be implemented into large business scale. In Zoho creator I have encountered the following problems: CHECKBOX DATA CANNOT BE PRESENTED IN A GRAPH. This needs to be fixed. It should
Strategies for transferring a Zoho Reports database to a customer
Hello, We are in the process of devloping a Zoho Reports database with al dashboards and import tables that go with that, and after implmentation we would like to transfer full ownership and admin to one or more persons within the customer organization. What would be the best strategy for transferring admin ownership of the database, including sharing of import tables, dashboards etc.? How would we best work with sharing/making public, and the necessary Zoho accounts that our customer will need?
Drilling down into details from Charts
Let me illustrate with an example of the situation that I am hoping to solve. The DB in question is Super Store Sales. Let us say that I have a bar chart which shows me the data for the SUM(Sales),SUM(COST) [Y - Axis] against Date in terms of quarters [X - Axis] with User Filters for Product Category and Product. Image shown below: Now if I click on any of the bars I will be displayed the underlying data for the selected parameters corresponding to the bar. But what I want is to be able to do is
Combining data from two colums into one column...
In ZOHO Reports, is it possible to combine data from two columns "Last Name" and "First Name" into a third column "Passenger" using the "Custom Formula Feature"? EXAMPLE: ----------------------------------------------------------------------------------------- Last Name First Name Passenger ----------------------------------------------------------------------------------------- SMITH JOHN JOHN
String into Numeric Argument
Collaboration Forum, Need some help! How do i convert a string into a numeric calculation so i can avg, sum, count etc... in edit Aggregate Formulas(Zoho Reports)? String is: Cradle to Grave (mm:ss) Desired outcome: I want to be able to Aggregate this field in a report. Thanks Arron Blue Pumpkin Hosting www.bluepumkinhosting.com
Query Table to Split Comma-delimited values into multiple records
I have a table that stores Labels (aka "tags") in one column, comma separated for each row. Here is an example: Id, Labels, .... <- These are the column headers --------------------------------------------------------------------------- "123", "usability, subscriptions", ... "325", "usability, membership, reports", ... I would like to report on the Labels column but it's impossible to build a pie chart breaking down the Labels usage in the current format, so I went searching online for some solutions.
Adding SELECT UCASE( ) to a Query Report.
Everything works fine with the Query, however, I would like to know how to add SELECT UCASE( ) to the SELECT "Agent" and "Passenger" fields? Any help would be greatly appreciated. Thanks! ======= SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "August 2011" WHERE "Agent" = 'JOHN' UNION SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "September 2011" WHERE "Agent" = 'JOHN' ORDER BY "5" =======
Sql statement for cumulative sum.
Hello guys, how are you doing? Thanks for the time answering this. I want to make a cumulative sum using a sql statement. Can you help me telling whats the error in this formula: select t."data da operação",t."Cliente", (select sum(x."saldo inicial") + IF(x."TIPO"='SALDO INICIAL',0,if(sum(x."Quantidade")=0,sum(x."profit"),0)) as teste from "Futura Completo" x where x."DATA DA OPERAÇÃO"<= t."DATA DA OPERAÇÃO") as "Patrimônio" from "Futura Completo" t order by t."DATA DA OPERAÇÃO" ? Tks Guys Leonardo
Is truncating dollars on the Y-Axis data labels possible?
I have total dollars on my Y-axis and the numbers are extremely large. This is creating an extremely jumbled and illegible axis. Can I put the numbers on the axis in millions so people can read the report. Image is attached. Thanks!
Report that list's most recent date.
I have a table that lists "tags". Users trade these tags with one another. I check what users have what tags every so often. Not all tags are checked at the same time. I want a report that shows what user has what tag and the last time the tag was checked. I seem to be having a hard time getting a report to show me this. I am also not sure if my table is formatted correctly to do this. Idealy i would want somthing like: tag 1 - user1 - oct 5 tag 2 - user2 - oct 10 tag 3 - user5 - feb 6 Currently
Reporting on All Projects
HI, We are currently using ZOHO Projects for maintaining our projects. However, we are looking for a reporting tool that can list all the projects, tasks and milestones and the status for a specific period of time. I am wondering if that kind of reporting is possible through ZOHO reports. If yes, how do we integrate ZOHO reports with ZOHO projects? Appreciate your time Ramesh
Is possible reach tables from two differents Zoho Reports Database?
Dear Support, Can we access tables from 2 ou more different Zoho Reports DB? Sample : I've one DB called DB1 with 1 table called Tablexxx I've another DB called DB2 wiith another table called Tableyyy I'd like to reach the Tableyyy inside DB1. Is that possible? Thanks Paulo Miguel.
Applying formulas to totals in summary view?
I'm trying to run formulas on my data totals in summary view. Is there a way to do this? Or another way to calculate totals and do the same? Seems like a simple feature to not provide. Anyone analyzing large amounts of data would benefit. The last post I saw about this was over 4 years ago and the rep claimed you were working on it?
Chart total amounts from start to end date
I have a created a table to track bonding by month. The table tracks the date a bond is issued, when it expires, the bond type, and bond amount. I wish to create a chart which displays the total amount of active bonds by type and month. In example if a bond was issued in the amount of $10,000 on 01/01/2010 and expires on 01/01/2011, I would like for the total to be reflected each month the bond is active (01/01/2010 – 01/01/2011) rather than the date it was issued.
Create Dashboard
Do we create dashboard just by dragging and dropping charts and tables? I can't seem to be able to drag and drop any of the items?
Authenticated share
Hi, I have created a chart view in Zoho Reports, now I'd like to embed it in another webapp. I don't want to be accessible to anyone having the link, but I need to do authentication to allow it to be displayed. This authentication would be managed by this other webapp. Is it possible to share but forcing authentication (for example sending credential in a HTTP POST request)? If not directly, can be done using Zoho API? Regards Asier
Set default date range on embedded report
Hi Guys I feel this should be quite easy, however when i search google i get some odd results. We have some reports that we embed in documents for viewing. What i would like to do is set a default date range for those reports. Currently it is using over two years of data which is annoying as it must be changed every time. any help would be appreciated. andy
Custom formula returning "NaN" and doc won't save. Help!
I created a simple custom formula that operates like: column1 / column2. The data in column 2 is occasionally 0 (it's click data from a PPC campaign and some days there are zero click on a particular ad) but this prevents me from saving my report because it reads as an error. Can someone please help me solve this issue? How can I tell Zoho to discard 0s when using this formula?
Uploading data from MS Access
Hi, I have issue uploading data from Microsoft Access. I searched the forum and could not find a suitable answer. The MS Access database is located at: C:\temp\OperationalDatabase.accdb. I set the configuration file database_connection_params.conf: # $Id$ DBTYPE=msaccess HOSTNAME= PORT= USERNAME=root PASSWORD= DBNAME=SalesDB MDBFILENAME=C:\temp\OperationalDatabase.accdb And I receive the following error in the logs: 2011/10/07 17:31:51 NZDT:TESTRUN :: false 2011/10/07 17:31:51 NZDT:2011-10-07 17:31:51.851
Asistance with Zoho Reports, CRM, Recruit
Hello: We are looking for a resource with experience with Zoho Reports, CRM, Recruit. Proven experience and credentials a must. Thanks, Raúl González Bleumasters Consulting . Technology . Outsourcing t us + 1 (956) 329-4535 t mx + 52 (81) 1808-1687 n 62*12*76688 www.slideshare.net/bleumasters
Advanced IF for BUDGET vs ACTUAL charting
I have the following table: DATE VALUE TYPE 01-01-2012 10 ACTUAL 01-01-2012 12 BUDGET 01-04-2012 11 BUDGET I need to calculate: BUDGET (as of 01-04-2012) = 23 (12+11) ACTUAL (as of 01-04-2012) = 21 (10+11) and chart it (see attached image) BUDGET data is already in table ACTUAL data is added daily Can you give me any idea.. should I create a new column formula? But then how do I chart the
Newbie needs help
I am trying to create my first report. I created a database and imported about 650 records. I am trying to create a report and it is telling me that it only allows 100 distinct values. My reports usually contain 300 records. How do I get around this or am I not understanding it correctly! Thanks. Also is there people on here who will create my basic database and reports like I want them for a reasonable rate? Thanks, Rena www.thepricematchreport.com
Query Table: Case sensitivity
Hi, I try to do a SQL query table where I match two strings: SELECT * form DBA, DBB, WHERE DBA.A = DBB.A The matching is case in-senstive, I'd need case sensitive matchin however. What can I do? best, Zoltan
Sorry, we are unable to regenerate this report
Hi, My reports are often not including all of the data. So when I notice this happen I regenerate the report. I've been trying to regenerate my reports throughout the day, but I keep getting the error message 'Sorry, we are unable to regenerate this report'. I tried re-creating a report with no filters but it still excluded data. Are you able to explain to me why there are often problems with reports not including all data requested and also why I cannot regenerate my reports.
Displaying Total for each chart
Hi there, I hope I'm not duplicating a previous thread by suggesting this. Would it be possible to have an option to display the Total for each chart (ie chart attached) as at the moment I can seem to only be able to have the details figures. Would be great therefore if we could display both details figures and Total figure. Thanks,
Weighted Means in Zoho Reports?
I need to display a weighted mean in a chart report that recalculates when user filters change. There is a formal definition of the weighted mean at http://en.wikipedia.org/wiki/Weighted_mean#Mathematical_definition. But here is an example: Category Value Frequency California 25 100 Arizona 35 50 Nevada 10 25 The weighted mean of the unfiltered data would be (2500 + 1750 + 250) / (100 + 50 + 25) = 25.71. The arithmetic mean would be (25 + 35 + 10) / 3 =
Count of Unique Occurances in Pivot table
I am looking for a way in Zoho Reports to display "counts" of a unique value in a pivot table or summary table. I can display total number that occur in a data set. Is there a work around or any new features coming up ?
Unable to regenerate reports ...
Hello, Since last week, I get "Sorry, we are unable to regenerate the report" when trying to do so ... very annoying ! Also, my report doesn't refresh when data is added thru one of my form (vote) carmar01\solumax (public app) Marcel
May 17, 2010 Update - Thresholds and Show/Hide Options in Pivot Tables
Here's what the latest update to Zoho Reports brought in new. Thresholds in Charts You can now set threshold markers in a chart for better visualization of your key performance data. You can add a maximum of 4 threshold values and also name each of these thresholds too. Click on 'Settings' option of a chart and you'll see a new 'Thresholds' tab in the dialog for creating thresholds. For example, say your Sales team has a monthly minimum target of $25,000 and a maximum target of $40,000. You can
Calculated value in Summary View
I am trying to work out how to get percentage of 'Appointment' to calls when Summarising by a week. I can do this per day by using a custom formula by in the Summary View I can only group data by SUM or AVG which does not give me the correct value. Table Fields Date, Calls, Appointments Percentage of 'Appointment' to 'Calls' formula Appointments / Calls Example 05 Jan 2012, 20, 8 (40% 'Appointment' to 'Calls') 06 Jan 2012, 10, 7 (70% 'Appointment' to 'Calls') Total 30 Calls, 15 Appointments The
Multiple criteria filter for a single column
Hi I have a column consisting of a spread of data as well as some empty rows. I need to filter out all the empty rows and also filter out specific values. I therefore need a filter criteria such as "Is Not Empty AND not equal to Value". I potentially need this to scale to "Is Not Empty AND not equal to Value AND not equal to Value AND not equal to Value". How can I do this? Thanks Brendon
How do you build relations with imported Creator main and subform data?
Zoho Creator parent form records that contain subform data store the subform record ID's in a multi-line or memo type field with commas delimiting the subform ID's. The normal SQL database way would be to wright the parent form ID to the child/subform record and relate it that way, but Creator doesn't do that. So how can I do relational queries with Zoho creator data between a parent and subform?
Export a table to other Zoho Accounts
I would like to copy a table I created from one account to a permanent Zoho account. Is there a way I can do this
HOW TO CALCULATE A TRACKING NUMBER FOR END OF MONTH
SO I have 1 salesperson. They work 20 shifts a month. They complete 4 sales on 01/12/2011 and 3 sales on 02/12/2011. Total of their 2 shifts was 7 sales I want to work out how to show them what is the forecast monthly result. I could do this using a formula in google sheet. Can some one help with how to help on this one in zoho reports. Btw: it is for a table 14 salespeople. Thanks Reuben
Multiple Databases or not
Currently I am developing a report solution so customers can login and see reports regarding his stores (one or multiple). and I want to use the best approach. - We will upload the same tables to ZOHO from multiple locations - A customer can have one or multiple stores that needs to see on ZOHO. What will be the best approach. 1) Have only one database receiving data from all customer/stores with a UniqueID and filter by SQL statement (maybe UserId) for the reports. 2) Create multiple databases
Combine similar name data
I have information in Reports on several branches of the same company. ie: Coy 1 , Coy 2 , Coy 3 I simply wish to do a lookup for any "Company Name" that begins with "Coy" and prepare an amalgamated sales list.
Next Page