The Avenue platform enables you to access and query the data stored in your company's data warehouse, which can contain a large volume of information. By utilizing filtering capabilities in conjunction with SQL queries, you can effectively refine and filter the output of your SQL query results, facilitating more refined signals and alerts. The filtering process can be accomplished through the utilization of the user-friendly graphical interface based filter within the Avenue platform.
​
After the data has been extracted from the SQL query, Avenue includes a section for the implementation of filters to further refine the data.
To add a filter, simply click on the plus sign within the Add filters section.

This will give you the ability to utilize different logical schemas to filter data.

​

In order to filter data according to specific requirements, the user must first input the column name and select the appropriate data type within the filter section. Once these selections have been made, a range of filtering schemas will become available for the user to choose from.
​
Upon the successful implementation of a filter, the display will resemble the following representation.

​