Wyn Enterprise understands the importance of advanced dataset filtering. All users, regardless of their comfort level with their data and technology stack, need to filter their data. Filtering helps business end-users narrow their analyses and answer questions with data-driven evidence.
Wyn Enterprise 4.1 introduces a new filter editor in the WynReports Designer that better empowers business end-users in filtering their enterprise data. The filter editor operates on an intuitive user interface built into Wyn Reports Designer. It lets both technical and non-technical end-users create complex filters on their reports.
The new filter editor has vast capabilities to handle collections of filters, filter groups, hierarchical filters, and logical operators.
The new Filter Editor simplifies the process of applying filters to a report and its contents, including the dataset(s) and controls, such as Table, Tablix, and other data regions. Click Edit to open the new filter editor. Configure the filters from a dedicated interface instead of adding filter collections, which was necessary with Wyn 4.0.
The new filter editor looks like this:
It provides users with several new options.
Prior to Wyn Enterprise 4.1, the “or” operator was only supported on semantic models. With Wyn Enterprise 4.1, it is supported on more common report types such as RDL and page reports.
Add filter values based on expressions and existing report parameters that match the data field's type
Create new parameters or prompts based on selected field type from within the filter editor interface
This saves users time as they no longer have to move between panels to add parameters as values on filter conditions.
Outlined below are the steps for creating a complex filter query using filter conditions, groups, parameters, and operators. This example uses a simple sales report.
A store manager in a retail outlet may want to prepare a sales report with year-over-year results for specific products, consumer segments, and shipping methods (see image below).
To prepare such a report, apply various filter conditions:
To follow along on your own Wyn instance, import the linked data source, dataset, and report layout to your Wyn server.
In the Report Designer, select the Tablix control and open the Filter Editor from the Properties panel. Once inside the Filter Editor, add a filter criteria on the Order Year data field as shown below:
Note: For the sample data, we are comparing data for the years 2018 and 2019.
Next, add a filter rule to select the products. This rule needs to work in conjunction with the previous rule on Order Year, so keep the default logical operator All Of in the Filter Editor.
Choose a list of products from the database. Use the In operator with values passed in via parameters added from inside the Filter Editor as shown below:
Finally, add a filter group that filters out data for a particular consumer segment or shipping method. Add a filter group with two criteria and the Any Of operator as shown below:
The improved Filter Editor in Wyn Reports is designed to structure complex filter queries to fit specific business requirements. With this new tool, end-users with any level of technical experience can easily apply intuitive filtering to their enterprise data and get insights faster.
For questions about the Filter Editor, reach out to us at Wyn.Experts@grapecity.com
Wyn is a web-based BI and data analytics platform that provides greater insight into your data.
Wyn offers built-in tools for report and dashboard creation, data governance, security integration, embedded BI, automated document distribution, and a business-user-friendly interface for self-service business intelligence.