Standard & Poor's publishes the Case-Shiller® Home Price Indices on the last Tuesday of every month. The indices are calculated from data on repeat sales of single family homes. The indices are normalized to have a value of 100 in the first quarter of 2000. It is calculated monthly using a three-month moving average and published with a two month lag. We imported the data released today into Zoho Reports and created a few charts to see how the house prices have performed over the years.
We posted about enhancements done to the pivot table recently in Zoho Reports. Here's more. Pivot tables (and charts, filters) now support quarterly and weekly intervals. This adds to yearly, monthly intervals before. This can be best explained in the sales context. What if you want to know how you did in 1Q 2009 Vs 4Q 2008 (previous quarter) or 1Q 2008 (previous year, same quarter)? Or what if you want to know how you did this week compared to last week or see the trends of the earlier weeks? It is easy now to have reports for such scenarios.

The screenshot above is for the Actual Values - Quarter & Year, sales in various quarters of each year. Seasonal/Cyclic - Quarter option differs from this as it will give the sum of Quarterly Sales summed across years.

Similarly, the Weekly option is available too. Sales figures of different regions for the various weeks in 2008 shown as a Pivot table.

The same quarter & week concepts are available in Charts and Summary Views.


You can also Filter the data using Quarter and Week timelines.

Try the new Quarterly & Weekly options in Zoho Reports and let us know your feedback in the comments.
Related Links







The latest update of Zoho Reports brings in dynamic filter in live charts and support for URL (HyperLink) as a datatype.
Dynamic Filtering in Live Chart
Say you are analyzing how the various campaigns of your Google Adwords account have performed using your Adwords Reporting database in Zoho
Reports. Let's say you have three campaigns for mountain bikes, one each for the Europe and the US and one for other countries/continents. And you want to look at the data from Europe and the USA alone. You can mouse over on the chart legend and uncheck that data alone.

Zoho Reports hides that particular data and will dynamically regenerate the chart with the remaining data.

You can click on the same checkbox again to see the hidden data back.

You can hide multiple data lines too. For example, you can see the data for the US alone (hiding Europe and Others) by clicking on the yellow checkbox as shown below.


The dynamic filter functionality is available on charts that are embedded in any of your web applications or blogs too. Embedding the chart used in the above screenshots below. Go ahead, click on the checkboxes and try the functionality yourselves.
URL Data Type
Zoho Reports now supports URL (hyper links) data type. You can now set a column data type as URL and store accessible web URL addresses in those columns. When you view the data, Zoho Reports automatically places a
HTML link sign besides URLs, clicking on which will open the URL in a new browser tab.

Like what you see and interested in knowing more about how Zoho Reports can help you analyze your business data? Contact us for a personalized demo.
Related Links






Zoho DB & Reports has recently introduced a new and very easy way of report generation with its Automated Analytics feature. With Automated Analytics, Zoho Reports applies an advanced rules engine to scan your data and based on pre-defined rules, generates reports automatically, which could be customized later. Auto-generation of reports drastically reduces the time spent by you on manual report generation and analysis.
You can auto-generate reports either for the entire table (which contains your data) or on specific columns in the table. Auto generation of reports for the entire table can be triggered when you import data into the table from either of CSV, XLS, TSV or HTML files. It just takes a couple of steps to auto-generate the reports:
1. Import the data from csv, xls, tsv file or copy-paste the data from csv, tsv or HTML
2. Once the data gets imported successfully, you will get a prompt of whether you would like to see Zoho Reports auto-generate the reports for you.
3. Clicking on Yes will generate multiple reports neatly grouped inside folder(s). The reports are a mix of visual charts & pivot tables (also called matrix view or cross tabs)
Now, those are the default reports produced. You can also get more auto-generated reports based on any column. Choose any column, right-click on it & choose the Analyze Column option. You will get the reports that are arranged in a new folder.
The below slide show explains the steps in detail.
If you are interested in knowing more about how Zoho Reports, the Online Reporting and Business Intelligence Service can help you bring more clarity to your business, contact us for a personalized demo.