InetSoft's award-winning dashboard software allows users to combine data from disparate and seemingly incompatible sources with sophisticated aggregation options. View the example below to learn more about the Style Intelligence solution.
When you define grouping or aggregation on a Data Table, the resulting table is automatically placed in “aggregate view,” which shows only the grouping and aggregation columns.
• To switch a table from aggregate view to detail view (displaying all columns, without grouping and aggregation), click the 'To detail' button on the table title bar.
• To switch a table from detail view to aggregate view (hiding all non-aggregate and non-grouping columns), click the 'To Aggregate' button on the table title bar.
| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
The following example illustrates how to toggle from detail to aggregate view.
1. Create a new Worksheet.
2. Expand the 'Query' node, and the 'Orders' node.
3. Drag the 'Order details' query on to an empty cell in the Worksheet. This creates a new table named 'Order details1'.
4. Right-click on the table's title row and select 'Group and Aggregate'. This will open the 'Aggregate' dialog.
5. Select the 'Group' option for the 'Product' column and 'Aggregate' for the 'Total' column.
6. Ensure that the aggregate function for the 'Total' column is set to 'Sum'.
7. Click on the 'OK' button to apply the grouping and summarization.
8. Click on the 'Show Live Data' button, located in the upper right corner of the table.
Notice that since grouping and summarization is specified for this table, the 'To Detail' button appears on the table's title row. Also note that only the summarized data is displayed in the table, and all of the columns that are not included in the grouping or summarization have been removed.
9. Click on the 'To Detail' button to switch to the detail view. Notice that all of the columns are now displayed in the table, but the group and aggregate columns are displayed with darker headings.
10. Now click on the 'To Aggregate' button to switch back to the summarized view of the data.
More Articles About Dashboards
3rd V of Analytics: Variety - Data is not found in a single type. You can find varieties of data in different types coming from various sources. Usually, data comes from the organization as well as from external media. It is not a condition that all the acquired data is of the same format and size. So, standardizing and distributing the data will be a challenge for companies. Data collected is of three types: Unstructured Semi-Structured Structured Unstructured data refers to the unorganized data that comes into the company in different sizes and formats. This type of data is difficult to use for mainstream applications and cannot be used for analytical models...
DXP User Engagement Metrics - Any digital experience revolves on user engagement, and DXPs assist businesses in measuring it successfully. Typically, DXP dashboards incorporate the following KPIs to evaluate user engagement: Page Views: The number of times a certain page has been seen on a website or application is indicated by page views. Tracking page views makes it easier to determine which material is well-liked and which can need some enhancement. Session Duration: The length of a session offers information on how long visitors spend on a website or application in one session. Extended session times are often linked to increased user involvement...
Education Dashboard KPIs - Schools and universities face a daunting challenge in assessing and enhancing student performance as the education sector changes over time. To make sure they are providing high-quality instruction and meeting the expectations of students, parents, and other stakeholders, they must monitor a number of metrics. An education dashboard that shows key performance indicators (KPIs) to track student growth, teacher efficacy, and institutional success may be a solution to this problem. We will discuss the KPIs to include on an education dashboard in this post as well as their significance to the education industry...
Explaining Analytical Operations Dashboards - An analytical operations dashboard is a powerful tool used by organizations to monitor, analyze, and visualize key performance indicators (KPIs) and operational metrics in real-time or near-real-time. It serves as a central hub where data from various sources and systems are collected, transformed, and presented in a visually intuitive format, enabling stakeholders to make informed decisions and gain actionable insights into the overall health and performance of their operations...
Features for Exploring Data - One key aspect of data exploration with visualization software is the ability to create various types of charts and graphs to represent the data visually. Users can choose from a wide range of visualization options, including bar charts, line graphs, pie charts, scatter plots, and more, depending on the nature of the data and the insights they wish to glean. By experimenting with different chart types and configurations, users can identify the most effective visualizations to convey their findings accurately and effectively...
InetSoft's Weekly Dashboard Examples - Weekly dashboards are vital for the regular monitoring and control of business conditions. But in many cases, the production of weekly dashboards puts additional demands on administrators and employees. And with so much business travel and work done out in the field, dashboard accessibly and deliverability can also be an issue. InetSoft's solution, Style Intelligence, makes the setting up and delivery of weekly dashboards easy and efficient...
Need Mobile Reporting Tools? - Organizations that frequently monitor key performance indicators and quickly respond to changes in the market will always outperform their slower, less informed competition. And if you find that users need to access information at all times, be it at the office, in a meeting, or at home, you need to be looking into mobile reporting tools. Organizations equipped with mobile BI are able to deploy important information to twice as many employees as those who do not...
Role of an Operations Dashboard - The role of an operations dashboard is to provide a real-time, consolidated view of essential operational data and key performance indicators (KPIs) in a visually informative and easily accessible manner. Operations dashboards are used to monitor and manage various aspects of an organization's operations, processes, and performance. Here are the main roles and functions of an operations dashboard: Centralized Data Visualization: An operations dashboard serves as a centralized platform that brings together data from multiple sources and systems. It aggregates data from various departments, processes, and systems, providing a comprehensive and holistic view of the organization's operations...