The latest Zoho Analytics update brings in the ‘Query over Query’ functionality, which has been one of the top request from our users. You can now have SELECT queries that combine already existing Query Tables. Let’s see an example of how this comes in handy. Say you have a Sales table with sales figures for various customers, products, regions etc across years.
Say you would like to know who your Top 10 customers with respect to sales value were in 2006. Your query table would look like,
The above Query Table in ‘View Mode’ with the top 10 customers arranged in alphabetical order.
And now you want to
know how much you sold to those top customers of 2006 in 2008. This is
where the new functionality will come in handy. You will arrive with
the required data by joining the base Sales table with the above top 10
customers of 2006 Query Table. The new Query Table will look like,
The above Query Table in ‘View Mode’ with the customer names in alphabetical order.
You can save the resultant query table and create the necessary reports over it.
this new “Query over Query” feature, you can create very powerful
reporting queries on your data and use it for your report generation
and analytics. It also helps in organizing your queries into reusable
functional units. To know more about how to create a Query Table,
checkout this video.
Previously, direct import was restricted to CSV files. And you had to do a copy-paste from Microft Excel (XLS) files. From now on, you can directly import XLS files too.
Also, for xls, html files larger than 3 MB, you can now zip them and import into Zoho Analytics.
Try these new features in Zoho Analytics and let us know your feedback comments.
- Zoho Analytics : Pivot Table Enhancements
- Relational Data Modeling in Zoho Analytics
- Quickly Generate Similar Reports in Zoho Analytics