InetSoft Product Instructions: Staged Flows in Interactive Reports
It is possible to have a parallel flow of multiple stages in a staged parameter sheet. This is desirable when the multiple stages are independent of each other. For example, one stage may have levels Country and State; while another stage may have levels Product Category and Product Name.
These two stages are mutually exclusive, and it wouldn’t be logical to place them in a single flow. To add a parallel stage simply drag an element to the region titled ‘Drag here to add a flow’ on the right of the Staged Parameter dialog box. Elements in the ‘Default Level’ are always enabled.
| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index | Read More |
Cascading Parameter Sheets
A visual interface is provided through which you can add multiple parameter sheets and control the sequence of prompting. Using a simple GUI you can specify conditional branching of parameter sheets, i.e., the parameter sheet to be displayed next in the sequence is decided on the fly based on user inputs. We will now explore a sample scenario where this functionality is useful.
Although it is possible to accomplish parameter chaining on the same parameter sheet through the use of staging, the use of multiple parameter prompts allows each to be reused independently.
Walkthrough: Cascading Parameter Sheets
Assume that a company needs a simple report which generates an invoice for the orders placed by its customers. The report displays order information like product, price, and discount, as well as some customer information like Name and ID. The user would need to enter the Company Name and Customer ID as parameters. Consider a scenario where some customers are resellers to whom the company provides a special discount scheme. It would then be necessary to display different parameter sheets depending on the type of customer. Such a conditional display can be easily achieved using cascading parameter sheets. We create three parameter sheets.
Note that when we link these cascading sheets to a report (discussed next in Using Cascaded Parameter Sheets in a Report), the report is automatically passed through an accumulation of the parameters entered in all of the sheets which were part of the user’s selection flow. Therefore, the report will always get all parameters from either the ‘customer’ and ‘reseller discount’ sheets or the ‘customer’ and ‘customer discount’ sheets, the two possible user selection flows.
More Articles About Reporting
Best Tools for the Beginner Data Analyst - Modern solutions are useful to beginner data analysts to learn and carry out analytical work effectively. There are different BI analytical tools that they can use in order to gains skills fast and start working as analysts. When choosing analysts tools, beginner analysts should focus on tools that are open-source and used by a large community. This makes it easy for beginners to get insights into any problem they might encounter while learning how to use the data analyst tool. Another important feature for a data analysis tool is the initial cost of the tool. Beginners need to choose tools that are open-source to ensure they save on expenses...
Data Mashup + Visualization = the Right Tool - So far we have seen visual analysis aspects. Demographic analysis normally requires a good deal of data. Normally this data must be collected from different sources. These sources have their own formats and delivery mechanisms. In most cases, data collecting, cleansing and transformation consumes the majority of time and resources. Futhermore, this tends to be a iterative process where data work and visual work are intertwined. Therefore, the tool must be as much a visual tool as a data tool. The example dashboard is developed with InetSoft's Style Scope software. InetSoft's software fuses data mashup with visual analysis to deliver rapid analysis development. The single web app empowers analysts, power users, and casual users with different levels of self-service functionality...
Food Safety Analytics - With the powerful analytics functions provided by InetSoft, a health inspection dashboard such as the one above can be generated to help local health departments keep track of food safety issues in different boroughs and different types of establishments. It can also provide local restaurant owners with improvement guideline on common issues, enabling them to prepare for inspection. This health inspection analytics dashboard will show you how easy it can be to create instant visual representation of restaurant safety. food safety analytics By applying filtering and sorting functions on this InetSoft food safety analytics dashboard, local health departments and owners of restaurants can easily come up with the top violation cases among local restaurants through the intuitive charts on the dashboard...
KPIs and Analyzing Logistics - Tracking key performance indicators in transportation logistics is just as important as in any other type of business. KPI's are essential business metrics important for keeping track of an organization's performance. Any organization needs to measure performance, whether it's on a daily, monthly, or on a quarterly basis. KPI's are the most important statistics that analyze an organization's objectives, business goals, and risks. KPI dashboards for transportation logistics can easily be built with InetSoft's on-premise business intelligence software application, Style Intelligence. Style Intelligence offers drag and drop tools for creating a variety of chart types. Multiple KPI's can be tracked in a single report, which can include any of the various informational displays offered within the software...
Security Intelligence Dashboard Example - Security concerns have grown significantly for companies of all sizes. Nowadays, businesses spend money on effective security measures to safeguard their systems, networks, and data. They must have a thorough awareness of their security posture and dangers in order to do this. Security intelligence analysts can help in this situation. These experts are in charge of collecting, analyzing, and interpreting data to spot possible risks and weaknesses. They achieve this by using a variety of statistics and key performance indicators (KPIs). In this post, we'll examine in more detail the KPIs and analytics that security intelligence analysts use to safeguard the information assets of their organizations...
| Previous: Report Parameterization |