Users can produce comprehensive real-time reports from InetSoft's award-winning dashboard software by incoporating specific aggregation measures. View the example below to learn more about the Style Intelligence solution.
The table below shows the crosstab aggregation measures available for table grouping.
| Aggregate Measure | Description |
|
Sum |
Displays the sum of the measure values for the given row and column headings |
|
Average |
Displays the average of the measure values for the given row and column headings |
|
Max |
Displays the maximum of the measure values for the given row and column headings |
|
Min |
Displays the minimum of the measure values for the given row and column headings |
|
Count |
Displays the total count of measure values for the given row and column headings. This represents the total number of records corresponding to the given row and column headings, and is the same value for any selected measure. |
|
Distinct Count |
Displays the count of unique measure values for the given row and column headings. |
|
Correlation |
Displays the Pearson correlation coefficient for the correlation between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'. |
|
Covariance |
Displays the covariance between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'. |
|
Variance |
Displays the (sample) variance of the measure values for the given row and column headings. |
|
Std Deviation |
Displays the (sample) standard deviation of the measure values for the given row and column headings. |
|
Variance (Pop) |
Displays the (population) variance of the measure values for the given row and column headings. |
|
Std Deviation (Pop) |
Displays the (population) standard deviation of the measure values for the given row and column headings. |
|
Weighted Average |
Displays the weighted average of the measure values for the given row and column headings. The weights are given by the corresponding values in a second column, which is specified by the menu labeled 'with'. |
Automating Scheduled Report Distribution - We have shown an example of writing a report from scratch, inserting a pivot table and a chart. We have seen sample reports where you can automatically refresh the data and filter the data. And lastly, wouldn't it be great if there were a handful of reports that you simply wanted to run on a weekly basis or a daily basis and have them automatically run and either emailed to you or printed or saved? Well, you can do that, too, with automated scheduled report distribution...
Capabilities of an Airline Dashboard - Self-service travel management Every dashboard consists of tabs or as they are also called workspaces or views. The number of these pages can vary from one airline to another, depending on its size and goals. Below we will tell you what elements these tabs include and how airlines use the obtained data. 1. World map and main key performance indicators Remember when companies needed paper help because there were ceiling-high piles of documents on the desks? Those times have long gone because modern technologies provide airlines with comprehensive information on the KPIs on a single screen. The world map gives information about the status of your company and recent flights...
Dashboard of Number of Healthcare Providers by Ward - A crosstab table (also known as a cross-tabulation table or contingency table) is a type of table used in statistics and data analysis to summarize the relationship between two or more variables. Crosstab tables display the frequency distribution of the data in a matrix-like format, where each row represents a category of one variable and each column represents a category of another variable. The table displays the count, percentage, or proportion of observations that fall into each combination of categories...
Definition of Graph Data Science - A branch of data science called data science focuses on the analysis of data presented as graphs. A graph is a type of mathematical structure made up of a set of nodes (also known as vertices) and a set of connecting edges. Each edge depicts a connection or relationship between two nodes. Numerous types of data, such as social networks, transportation networks, biological networks, and others, can be represented using graphs. To glean insights from such data, graph algorithms and machine learning methods are used in graph data science...
Interactive KPI Reporting Tools - Once a business has selected their most critical KPI's to track, InetSoft's reporting software allows users to display this information in multiple visualizations such as charts, tables, and crosstabs which are fully customizable and easy to manipulate, even for non-technical users. With InetSoft's KPI reports, bare data turns into actionable information that provides insight as to where the business stands and where improvement is needed. For example, if it seems that there is a disparity from where the company should be in an area, InetSoft's reporting software allows for interactive drill-down on data so that users can pinpoint exactly where the issues are coming from so that they can be fixed...
Example of Writing a Personnel Report - So we've just gone through an example of writing a personnel report from scratch, and you say this is great. We can save it, and rerun it at a different time, and this will allow you to distribute the reports and allow multiple users to run these reports whenever they want. Now we're going to help you with that. We're going to start you off with a series of sample reports to build from. Clicking into the sample report, this is a list of sample reports we're going to give you. It includes accounting and financial reports at the top and HR and payroll reports down at the bottom. I'm going to walk you through these briefly so you can see this, but first, you simply click on...
Visualization Off of Excel Spreadsheets - I can choose a database. I could even be using an Excel spreadsheet to build this visualization. And then I open up a new worksheet, and you see here those fields that I was showing you before come up on the left hand side. And the basic user experience is all visual. The whole desire of visual analysis is to make it so that people can think with their data...
What Are Some New Chart Types? - Sparklines are becoming pretty popular chart types. They're really just tiny line charts with no axes or legends that are used on a dashboard that is displaying many kpis at once. The idea is you can eyeball the trends for many kpis at a glance. Typically they'd be ones that you are used to looking at every day, and if you saw an aberration up or down in the sparkline, you can drill into to try to analyze what happened. Bullet charts are another similar new popular chart type. They're good for showing the performance of many kpis, where the actual is now vs the target. They're little horizontal bars like in a bar chart, again with no axes or legends, and you have one for each KPI, and a lot of times, they'll have red, yellow, and green bands with a tick mark showing...
| Previous: Dashboard Crosstab Table |