Custom Filter Functions
Nick talks about some common use cases for custom filter functions and then explores how we might use them creatively to improve upon our user experience even more!
Filters
Sorting by Aggregates
To sort groups by the summary, or aggregate, calculation of each group of an Advanced Report, use Top/Bottom filters. Top/Bottom filters look for the highest or lowest values in a set, and then put those values in order. Any arbitrary cell in the report can be the Top/Bottom filter.
Top/Bottom Filters
Top/Bottom filters, also known as Top N filters can be added to a report. Top N filters allow you to filter data to only the rows with the top or bottom values, for either data fields or data summaries, per group iteration.
Top/Bottom filters work after all other filters have been applied. ...
Custom Filter Functions
Custom Filter Functions provide the ability to make functions that will dynamically calculate a value for a filter using high level code.
Dashboard Designer: Filters (v2019.2+)
The Filters menu in the Dashboard Designer toolbar is where filters are created, modified or removed, and imported prompting report filters can be modified. Use the Filters menu to add interactive filter tiles to the Dashboard Canvas.
Dashboard Designer: Interactive Filters
Interactive filters are filters that appear as tiles directly on the Dashboard itself. Filter tiles have several different styles to choose between, and can resize and scale just like any other tile. Filters can apply to as many or as few reports as needed. This article applies to versions of the application released prior to v2019.2.
ExpressView: Filtering (v2021.1)
To show only data that matches certain criteria, filters can be added. Filters can also improve performance by only including relevant information. There are two kinds of filters that may be applied to an ExpressView: Standard and Top/Bottom.
Filters
Filters narrow the scope of reports by restricting the data by specified criteria.
Group Min/Max Filters
Group Min/Max Filters cause the report output to display detail containing either the highest/latest or lowest/earliest values in a field for either one group, multiple groups, or an entire data set.
JavaScript API: Filters and Parameters
Runtime filters and parameters can now be modified via the JavaScript API prior to a report's execution.
JavaScript API Filters
Nick Cortina walks through applying filters and parameters via the JavaScript API, a feature new to v2019.1!
Basic Training 09. Filters
In this video, we discuss filters in the Report Designer, which allow us to narrow down the amount of data being displayed.
