Change Data Grouping and Aggregation in Visual Reports | Targetprocess - Visual management software

Change Data Grouping and Aggregation in Visual Reports

Data Grouping and Aggregation modes in Targetprocess Visual Reports are flexible. You can choose to sort (ascending or descending), compact (yes or no), aggregate (none, sum, avg, min, max), and group (none or by intervals of weeks, months, years, etc.) your data. There's also the ability to edit data calculations related to the axis field.

The settings can be configured by owner of the report or by administrator of your system.

Data Grouping

To customize settings open the Set up Report editor. Click the green field label on an axis. A popup with field settings appears. Settings can be configured on Data tab.

2017-07-17-17-01-52

Continuous and Period scale for date axis

Dates are now scaled as continuous axes by default. If you need to use periodic scales for dates, you can switch scale type from the field settings popup on Appearance tab.

2017-04-13-15-40-23

Custom Calculations

Calculations can be added or edited using the "+" sign, or by double clicking the x, y, color, size, or label. The "Calculation" popup appears.

Custom Calculations

More information: In-Chart Calculations Basics

Still have a question?

We're here to help! Just contact our friendly support team

Email us
The more details you can give us the better
Live chat
Prefer instant messaging? Try our live chat
Service Desk
Add tickets, comments and track status in our Helpdesk
Slack Community
Shape the future direction of Targetprocess

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.

Start your free trial

Enter your email
By clicking "Continue", you acknowledge and agree that we will process your personal data in accordance with our Service Privacy Policy and Terms of Service.

We’ve sent you a confirmation e-mail — please, go check it.

Or get a live
product demo