Sum -> difference from in chart
Hi, is it possible to use the function Sum difference from in chart? Greg
Column headings not visible in internet explorer
Hi For some reason from this morning the column headings of the tables aren't visible in internet explorer but works in other browsers. Does someone know why? Thank you
Multiple Joins Timing Out
Hi, I am trying to get a Query Table to run with multiple Joins. Its fine for up to 3 joins but when I put the 4th one in it times out. Any thoughts Query Below SELECT opportunity_type,opportunities.deleted as opp_deleted,opportunities.description as opp_desc, sales_stage,opportunities.assigned_user_id as opps_assigned_userid,amount,user_name,cost_amount_c,actual_close_date_c,contract_line_c, curr_prov_c,reptowho_c,nextsteps_c,probability,deal_stage_c,inf_dec_c,nomfd_dev_c,softapp_c, end_user_c,machinesprodsoft_c,noofprint_c,useav_c,creditcleared_c,financeco_c,mpscontract_c,
Give access to single report in DB in design mode
Hi, I would like to give access to a single report. this access needs to be able to "edit design". I dont want to provide access to complete data base. What are my options? tnx
Cannot publish reports winthout login in free plan
Why can´t I publish reports anymore? I'm on a free plan and can build reports unlimited, but now when I try to publish it says to upgrade my plan, this was always possible before.
Net Gain metrics
Hi, I am trying to create Net Gain metrics which produces the difference in values of a metric across two time periods. For example, I have a report that tracks number of subscribers on a weekly basis broken down by the subscriber type. I would like to track the Net Gain as well as the change/movement of subscribers since the previous week. Below is the sample report: "Subscriber Type" "This Week" "Net Gain Since Last Week" Direct Subscribers
Relative filter based on user filter
Hi, Is possible to create a report that has relative filter that is linked to a user filter? For example: Say I have a report that has the measure "Number of Orders" and "Order Date". I would like to create a report that shows the "Number of Orders" for the current week and previous week. In addition the report has a user filter that allows the user to select a week - set by default to current week. If the user selects the current week (say 25 Jan 2013), then the report would look like:
How to display date in dashboard
Hello, I have sales report generated daily and want to display the report generated date in the dashboard title. Tried with html code but it doesn't display the date . Is there any solution to display date in dashboard along with tittle ? It should appear as: Daily Sales Report as of DATE. Thanks Yash
SQL LIMIT and URL filtering
Hi Zoho team, I'd like some advice in order to do the following. We have a report which contains all data for different companies. We display the report using its URL and we filter it using ZOHO_CRITERIA to display one company at a time. Now we would like to display only the top 5 rows for this report. I've read the post "https://help.zoho.com/portal/en/community/topic/top-5-expenses-for-each-month" but when I try to do the same it displays the top 5 rows for all the companies, not on a per company
Limit decimals in chart
Hi, How do i limit the number of decimals displayed in the chart view? Please see attached screenshot. Thank you! //Julius
import from zoho invoice to zoho analytics
I am trying to set up importing payment data from Zoho Invoice into Zoho analytics. It would be great to do this on a set schedule. Please advise. thanks Bruce
Financial Reports from 2 Views
Hmmm, I'm not sure how to do this, nor if I'm even approaching this in the right direction. I have a form for all my expenses (Expenses). I have another form (Client Work) for the work I do for clients. How do I create a report that shows my monthly income total and my monthly expenses to give me a net total? Thanks
scheduled import from zoho creator? how
hi i just did first import from my zoho creator's app. it seems well. but there is no any button (in "import") for scheduling it. how can i install scheduled import from creator's app to my reports database? https://reports.zoho.com/ZDBDataSheetView.cc?DBID=778397000000144124
Exporting report pdf or Exceel
Hi,
Table filter
Hi How do i set up filter similar to the ones on this web page http://mydatamine.blogspot.co.uk/p/diabetes-dashboard.html I have set up a table with imported data from my google sheet.
Changing Design Modification - Look-up
I currently have relationship established between two tables Table A (Parent) & Table B (Child)......the relationship is set-up so that if I delete a record in my parent table (table A)....all related child records (table b) will be deleted....I would like to change the set-up so that the child records in table B will not be deleted....if I delete a related parent record.....Is it possible to change this setting? Or is it to late? Thank you
Dynamic fiscal year query
I have several years (and growing) of data that I need to query whose results need to be grouped by our fiscal years, Oct to Sep. So I don't have to create a new sub-query and edit the primary query every year, I would like to have a dynamic moving window of time that goes back 5 fiscal years or so, 1 sub query per fiscal year counting back from the current one. As an example a sub-query for the last fiscal year would be something like: Sub-Query name: "FY-1" SELECT "Staff_ID", "Amount" FROM
Import from Google Spreadsheet not working
Hi, For the last 5 days, the scheduled import from Google Spreadsheet is not working. Support has promised to look into it but no resolution so far. Please resolve this asap. Sunil Tadepalli
Is there a way to restrict access to a Reports PermaLink / URL using an IP address range
I like the ability to publish a report and dashboard without the need for users to have to login but I'm concerned about access by users outside our company. I had thought I could restrict access to these using allowed IP address range in my profile but that does not seem to restrict anything. Any ideas on how I can limit access to just people who are on our corporate network but still use the Publish Report Link without login feature.
Get Embedded code for all Views
Is it possible to get the iframe embed code of all the public views in my database with one or 2 clicks instead of manually copy & pasting them individually? Another option would be to get the title & obj id of all the views and I can construct the iframe code in my website Let me know
Upload Tool: Randomly Stopped Working
I have had an automated version of the upload tool working for about a year and a half now. Yet I noticed it stopped randomly last month. The only error that I get now is this: ServerException (HttpStatusCode 200 Error Code: 407 , URI: https://accounts.zoho.com, Action: ZOHO_LOGIN, Message: Could not login. Could be because of username/password mismatch) Any ideas? I changed nothing. I went back and looked at the username and passwords and they are all fine. Any ideas?
Equivalent of Oracle TO_CHAR function
Hi, I was trying to the Oracle equivalent of TO_CHAR(<date field>, 'YYYYMMDD') as derived column in a Table using the GUI as well as Query table. However, I could not figure out how to do it. Do we have an equivalent for TO_CHAR or Format command that converts data types from one form to another using format arguments? Cheers Sunil
Selective cascading of user filters to table/charts in dashboard
Hi, I have an expense dashboard which has tables and charts that track expense data for the current financial period i.e. April 2012 to March 2013. I would like to add a table to the dashboard that compares the expenses for the current financial year - April 2012 to March 2013 to the previous financial year - April 2011 to March 2012. However, if I apply the FY 2012 filter to the tables/charts that track expense detail for the FY2012 year in the dashboard (which is what I want), the other table that
Can't Export a View
I'm in a table, I select 'Export' > 'Export this View' > 'As CSV'. Normally, this immediately downloads my file. Now, I'm taken to a page "Export As CSV: Settings" with a ton of options. Even with these options, there's no way to export the file. What's up? I do this all the time. I'm trying to extract a simple 200 row table. The workaround is to select the option to email the attachment which works. Pls correct. Thanks.
zoho-migration fails to uplaod Excell workbook to Reports
Hi I am having a problem getting a multi-worksheet Excel workbook uploaded to Reports. The workbook loads into Migration fine but after entering credentials for upload to Reports the app loads for a second and then nothing happens. Repeating the same process for an upload to Creator works perfectly, but I need the data in Reports. Does anyone have any ideas. Running Windows 7.
Zoho Reports - New features rolled out on December 7, 2012 update
More Chart Customization options With this update, we have added many more options to customize the appearance of the chart as you wish. These options enhance the look & feel of the chart, to match your taste or to go along with the look & feel of the application, where you are embedding the charts. Also a newly designed chart Settings screen with a user-friendly layout and ample spacing to capture the various customization options is introduced in this update. The Axis tab, in the Settings screen
Why can't i publish Reports to website anymore on free plan ?
Hi, i was able to publish my dashboards to my website without the login option, but i cant do it anymore. I get this message "Sorry, you cannot publish reports using Without Login option in Free plan. Kindly Upgrade your plan to use this option." Why is this?, Why did it suddenly changed?
INCOME ALLOCATION AGGREGATE FORMULA IN PIVOT TABLE
Hi, I have the following pivot table: Jan Feb OFFICE CLIENT INCOME INCOME New York Nike 1 2 Adidas 3 4 Atlanta Nike 5 6 Adidas 7 8 ALL 9 10 ALL Nike 11
Nested IF in Table does not refresh
Hi, I have the following nested IF custom formula in one of my table columns. It gives me the results I want. However, it does not run on newly imported records. Can you please tell me why? IF("CURRENCY"='EURO',"(+) AMOUNT INCOME"*2.3,IF("CURRENCY"='USD',"(+) AMOUNT INCOME"*1.8,"(+) AMOUNT INCOME")) The intended meaning of the formula is: Dear table, please look in your currency column, if you see Euro than multiply the amount for 2.3. On the other hand, if you see USD multiply for 1.8. Finally,
Column with percentage of row total
Hi, I have data like this in a matrix, which I have no problem doing based on the quantities from my data source: Green# Yellow# Blue# Total# Europe 5 3 8 16 Asia 7 9 7 23 What I need is to add a column where the values are a percentage of the row totals, calculated on basis of the quantities I already have - like this: Green# Green% Yellow# Yellow% Blue# Blue% Total# Total% Europe 5 31% 3 19% 8 50% 16 100% Asia 7 30% 9 39% 7 30% 23 100% Any input on how to do this? Thanks, Anders
Specify JSON callback function name
In the API, when using the JSON repsonse format, it would be really useful to me if I could specify a callback function name. This option is available in the Writer API and the Sheet API.
csv upload tool failure
Hi, if I upload my data via website it upload fine, but when I use upload tool, it add a new column with the same name that first column. So, data in the first column is not imported. I also attach an image. I apreciate if you can hel me. Thank You in advance.
Previously saved query that executes for reports is not saving/parsing.
I have a query table that I use in reports without a problem. Without even making a change in Edit Design mode I will get a parsing error when executing or saving. Based on the location of the parsing error, it seems the source of the error is a logical operator I had been using in an IF statement. I had been using "||" instead of "OR" because "OR" had been generating an error when I wrote the SQL Query a few months ago. I guess now "OR" works. But when I change my "||" operators to "OR" operators,
Relational Data Modelling
Hi, I have two tables from my Magento web-shop TABLE 1: All orders in system TABLE 2: All customers in system I'm trying to create a list of customers who haven't purchased anything. Both tables share a "customer ID" column - but how do i define the lookup/relationship? I've trying changing the TABLE 2 ID column to a lookup column, but since not all ID's are present in the order table, i'm left with many blank rows in the ID column. Both tables will continuously be update. Thank you in advance for
How to control ranges in table when using Actual[R]
I don't see how to control the ranges that are displayed when using the Actual[R] type for a decimal data field. The ranges provided by default by the report are not useful.
How to check if text field is numeric
I have data in a field that I only want to use if the data is numeric. Is there anything simple that works like the Isnumeric() function in Excel? I tried writing something using REGEXP but it does not make it through the syntax check. (It should work since I got it off of a MySql forum). Here's an example. The field that contains my data is called "VWAP". "VWAP" REGEXP '^(-|\\+)?([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$' I have also tried using the CAST function to convert to a decimal. This converts
Producing Variables Not Present in Data
Hello, I am wondering if Zoho Reports has the ability to interact with my data on variables that are not explicit in the data, but for which the data exists. For instance, I have uploaded a transactions log into Zoho, including Customer Names. I would like Zoho to tell me things like: Of the customers that we saw for the first time in July, how many have we seen since? Of those people, what is the average number of visits? What is the length of time between transactions, on average, for these people?
Zoho integration
Hi. Am working on zoho reports.I want to know can it possible to generate an empty graph without taking values from the data.Clearly i will explain you ----- I created an report by filtering X-axis and Y-axis, by taking two drop down options , It taking the default values and genenrating the graph but I want an empty graph to be generated first then after selecting the feilds from graph it should generate the related graph. I hope you got my problem. Can you please help how to do it Thanks in Advance.
Custom formula "if" statement
I need to create a custom formula column that will reference 2 other columns and based on the contents of those, display the output designated. Example: I have the columns "Inquiry Funnel Formula" and "Market." (The "Inquiry Funnel Formula" is a custom formula column). I would like my new custom formula column to do the following: If(instr("Inquiry Funnel Formula", 'Application')>0 AND ("Market",'Albuquerque')>0,'5' Basically I want my column to look at the variable in my Inquiry funnel column,
Query that works not saving or parsing in Design mode
I am trying to edit a query that works when I open it (and when used by reports). However, when I go into Design mode and try to save it without even modifying anything, it will point to a parsing error. The error it first pointed to was a place where I had been using a "||" operator instead of "OR" because previously "OR" would not work. So I switched them. It would then display another parsing error, but without any reference location. So I copied the query section by section into a test query
Next Page