Analytics Help » What's New
Recently there was an update to filter, sort or expand the fields in the reports designer. We have now additionally implemented an option to Show Involved Columns. This will be useful to quickly list only the data fields used in creating a particular report.
Support to Export/Email Multiple Reports in a HTML Format
Virtutem Analytics now supports exporting/emailing multiple reports in a HTML file format. So far these features were only available for a single report.
Now you can export or email multiple views as a single zipped HTML file by clicking Export -> Export Multiple Views -> As HTML (ZIP).
So far this multiple export feature was supported for PDF file format.
Enhancements in Dashboard
Virtutem Analytics Dashboard has been enhanced with the following feature.
Themes
Virtutem Analytics now allows you to apply a range of visually appealing themes over your dashboard. By default Virtutem Analytics provides six theme layout, which can also be customized as needed.
You can choose the required theme by clicking the Themes toolbar option in the Dashboard. You can customize any theme by clicking the Customize option displayed when you mouse over the themes listed.
The new themes support will definitely make your dashboards look really appealing. You will find it more handy in case of embedding as you can customize the dashboard to suit your website or application look & feel.
KPI Widget Color Customization
Now Virtutem Analytics allows you to customize the display color of the Primary value of the widget, when the value is lesser than zero or greater than or equal to zero.
Handy Contextual Options for Reports
Virtutem Analytics now provides a set of handy contextual options for reports embedded in Dashboard. With these new options that appears on mouse over, you will be able to perform the following operations.
The options will appear to a dashboard viewer/user based on the permissions granted by the author of the dashboard.
Virtutem Analytics now provides Conditional Formatting support for Pivot Table and Summary View. This enables in visually highlight data points in your pivot & summary views, thereby enabling to do better and easy analysis.
To know how to apply conditional formatting over your Pivot, refer here.
Enhancements in Query Table Editor Interface:
We are introducing a new feature rich query table editor in this update. The salient features of our new query table editor are as follows.
Add Description for Aggregate/Custom Formula:
You can now add descriptions for your Aggregate or Custom formulae. These will be pretty useful to add contextual notes about the formula you create.
Support to Auto Format Units of a Numeric Column
Now Virtutem Analytics provides an option to auto format the unit value as thousand (K), million (M) and billion (B) based on the data in the corresponding column.
Recently , Virtutem Analytics introduced formatting the numeric columns values with thousands (K) or millions (M) or billion (B) unit notations.
Now with this 'Auto' option, Virtutem Analytics auto detects the data in each record and formats the unit accordingly. This allows the flexibility of setting the right unit based on the actual value in each row, instead of fixing only particular unit always.
Charts Enhancements
Display Missing Values
Now Virtutem Analytics provides a new option to include the tick label for the data point, which does not have any value. This is available for both the date and the category columns.
So far when you plot a chart with a date or category column, if a particular data point does not have any value, then the chart would skip this from the plotting it in the axis. With this new option you can choose to even display the point which does not contain a corresponding value in your chart.
This feature will be pretty useful to visualize the complete trend considering all data points.
Charts Look and Feel
Virtutem Analytics has enhanced the Charts look and feel by fine tuning the color effects. Now it sports a more trendy and light look & feel.
Enhanced Upload Tool - Up to 4 times faster
The new version of Upload Tool supports executing multiple database queries in parallel, thus enabling quicker data uploads from your local databases. This version of upload tool can handle data uploads up to 4 times faster than the previous versions.
The previous versions of Upload Tool will execute the database queries configured in database_sql_queries.xml one at a time, pulling data from your local database and uploading the same into Virtutem Analytics. In the new version the tool smartly identifies dependencies between the queries configured and looks at parallelizing the execution.
The tool considers the following cases as dependent queries:
For the above mentioned cases, queries will be executed sequentially one after the other based on dependency . In all other cases, where there are no dependencies, query execution will be done in parallel, thus enabling faster data uploads.
You can download the latest version of the Upload Tool from here.
Virtutem Analytics now allows you to create multiple groups to share & collaborate easily in a reporting database. You can group a set of users based on functional roles/needs to create a group. Within this group you could easily share data, reports and dashboards to enable easy collaboration.
Till now there was a limitation to have only one group in a database, which has now been removed.
Virtutem Analytics now allows you to E-mail reports as a in-line mail content. So far reports can be mailed only as an attachment. Now they can be sent as part of the mail content, which will be very easy for users to view them.
Google Analytics Advanced Reporting Add-on now supports syncing Goal data from Google Analytics into Virtutem Analytics for reporting & analysis.
With this update the following formulas have been supported in Formula Columns.
Enhancements in KPI Widgets
Support to Customize the Comparison Indicator
Now Virtutem Analytics allows you to customize the comparison indicator. Till now the indicators will only be displayed based on the result of comparison between latest and previous value. From now on you will be able set the indicator by choosing what to compare with the given aggregate values.
With this you can display the indicator based on various patterns such as comparison between maximum & minimum value and so on. You can also set the indicator by comparing it with a constant value.
Now Virtutem Analytics allows you to set a drill down path for your chart axis from within Charts settings. This enables you to define drill down paths a lot quicker for a chart. You can find this option in Settings section, which allows you to define the complete path in the same dialog. This path is specific to the chart where you are defining it.
When you open the Drill down settings, any drill paths paths already defined at the table level will be displayed by default.
If you want to define the path globally (i.e., for all charts), then you need to define that for the corresponding columns at the table level. To know more refer this documentation.
In the databases that you setup using any of the default Business Application Data connectors (like Salesforce etc.,) offered by Virtutem Analytics, till now you cannot define Lookup columns in the data tables pulled (synchronized) from these applications. Now we support this too.
With this option you can combine data sets (using the auto-join feature) across business applications (e.g., combine Zoho CRM Leads data with your Marketing Campaign information that you might have stored Google Drive etc.) and easily do cross functional analytics.
Refer How to define Lookup columns and join tables.
Virtutem Analytics now allows you to set report specific formatting for data columns displayed in your reports. Till now you could set column formatting only in the Tables in which these columns are part of which was just inherited to every report that was created involving these columns. Hence it was not possible to change the formatting at the report level. The new reports specific formatting options addresses this limitation. You can set this using Setting section of the report you create. This feature is available for Charts, Pivot View and Summary View. In Charts this will format the data displayed as tooltip. The following screenshot is from a pivot table settings dialog.
Virtutem Analytics has now enhanced the dashboard PDF export with the following features.
Zoom Factor in % (Font size)
With this option, you can scale the font size of the reports in your dashboards to fit to the page size appropriately. This could be scaled between 1 to 100%.
Column Width Ratio
This allows you to define the column width radio for the table styles reports (pivot, summary, table etc.,) in your dashboard. You can either choose to have equal width for all columns or set proportional column width based on the design of the original report.
Support for Custom Modules in Salesforce Advanced Analytics Add-on
Salesforce Advanced Analytics Add-on now supports pulling data from custom modules setup in your Salesforce account into Virtutem Analytics. You can add up to five custom modules from Salesforce into Virtutem Analytics.
Schedule Imports in your own Time Zone
So far data imports can be scheduled only in GMT time zone. Now Virtutem Analytics allows you to set these schedules in your own time zone of preference.
Virtutem Analytics Query Table has now been enhanced with the following new functions.
Virtutem Analytics now allows you to sort the Pivot Table columns in a custom order that you define. Custom sorting was a feature that is already available in Charts, which has been extended to Pivot tables now.
You can find the Custom Sort order item under the "Sort" menu in Pivot Tables. Invoking the same will allow you to customize the order in which the values of the columns are to be sorted. Setting the order and applying it will sort the column values accordingly.
Virtutem Analytics now supports data and time difference functions in both Formula Columns and Query Tables. With this function you will be able to calculate the date and time difference between two date columns based on the unit specified. The supported units are SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR. For more details refer here.
Enhancement to Auto Generated Reports
Auto generated reports in Virtutem Analytics has now been enhanced. With the new update you will find new combination of analysis done and reports created automatically. That apart now the reports generated also covers some the valuable features that has been recently introduced into the product. Do give it a try...
Trash and Restore Support
Virtutem Analytics now supports to the concept of trash and restore for better handling your deleted views in your reporting database. With this, you can easily restore views deleted accidentally from Trash. You can view all the deleted view list using the Trash option at the bottom left of your navigation tree. You can find the options to restore or delete the view permanently, when you mouse over the views listed under Trash. The views will be maintained in trash for 45 days from the date of deletion.
Virtutem Analytics now provides an useful option to view the dependency list of any Query Table. With the "Dependency List" option you can view the parent tables ( & query tables) on which the selected Query Table has been created on. You can also view the list of child query tables which have been created over the selected Query Table.
In the dependency list, you will also be able view the hierarchy level of each table (or query table) in the dependency list. Level indicates the proximity of the dependency. The lower the level the more direct is the dependency.
Dependency list will be a pretty useful feature to facilitate easy management & maintenance of your query tables, especially if you are a power user of query tables.
From now on you will be also able to import millisecond data into your date column in a Virtutem Analytics table
Virtutem Analytics now supports applying Advanced Summary Functions (Windowing functions) even over Aggregate Formula while creating reports. So far when you use an Aggregate formula in a report, you will not be able to apply other functions on the formulae. The function will always be selected as 'Actual' and cannot be modified. Now you can apply other windowing calculation such as Running Total, Difference from, Moving Calculation etc.,
Virtutem Analytics now allows you to choose between Left or Right type join while creating reports (Charts, Pivot Table and Summary View) over related (linked) tables. This option will provide much more flexibility in creating reports. You can find this option in the Table Relationship dialog.
Left Join - Report will be computed with all the rows from the child table (left) and only the matching rows from the parent table (right). Matching is done based on lookup columns defined between child & parent tables. This will be the default join type.
Right Joint - Report will be computed with all the rows from the parent table (right) and only the matching rows from the child table (left). Matching is done based on lookup columns defined between parent & child tables.
Let's say you have joined Employees (parent table) and Tasks Completed (child) tables through a Lookup column Employee Name . If you want to create a report to show the tasks completed by each employee.
Left join will return all employees who have 1 or more completed tasks in their name.
Where as Right join will return all employees, including those with no completed tasks at all.
© Copyright 2017, Virtutem. All Rights Reserved.
The word and design marks set forth herein are trademarks and/or registered trademarks of Virtutem and/or related affiliates and subsidiaries.
All other trademarks listed herein are the property of their respective owners.