You can select attribute values to filter the data that is displayed on a sheet, by creating an attribute filter. A filter on a sheet filters the data in all the visualizations and also in any dataset objects displayed in text fields on the sheet. (A sheet is a layer of data, filtered independently of other sheets on the dashboard; for background information, see Adding, modifying, and deleting sheets in a dashboard.)
For example, a sheet contains a grid that displays revenue and profit data by geographical region and employee. Create a filter on region. In the Filter panel, you can then select the region or regions to display.
The filter applies to the sheet that it was created on, and any pages that the sheet contains. The filter is not applied to any other sheets that the dashboard contains. If the sheet in the example above contained other visualizations, the attribute filter would filter those visualizations too. For an example of a filter applied to multiple visualizations in the same sheet, see Adding, modifying, and deleting sheets in a dashboard.
You must have Edit Dashboard and Run Dashboard privileges.
To create an attribute filter:
Click the name of the dashboard to run it.
Click the tab of the sheet to filter.
From the Datasets panel, click the attribute you want to use to filter data, and drag it onto the Filters panel. You can place the attribute before or after any filters already displayed in the panel. You can select and add more than one attribute to the Filters panel at a time. Press CTRL and click each attribute to select it.
If the Datasets panel is not displayed, from the View menu, select Datasets Panel.
If the Filters
panel is not displayed, from the View
menu, ensure that Filters Panel
is selected. If the Filters panel is hidden behind another panel,
click the Filters icon 
to display the Filters panel
To filter on a date value, you can compare the date to a date that automatically adjusts according to the current date. For example, you can filter for yesterday, to display only the previous day’s sales data. This is referred to as a dynamic date, as it changes every day. You can create a dynamic date for the beginning date, the end date, or both dates of the filter.
To use a dynamic date on the filter, complete the following steps:
Click the Date icon in the filter. A calendar is displayed. As you make changes, the calendar updates to reflect the dynamic date.
Select the Dynamic Date check box. The Dynamic Date area is displayed.
To offset the current date by days, select Plus or Minus from the drop-down list before Days. Type the offset value in days.
To offset the current date by months, select Plus or Minus from the drop-down list before Months. Type the offset value in months.
To offset the current date by both days and months, complete both of the previous actions.
Click OK.
Select the style to use to display the filter. Hover the cursor over the name of the filter that you just added, click the arrow icon, point to Display Style, and select one of the following:
Check Boxes: This style allows multiple selections.
Search Box: This style is useful for a long list of items.
Slider: This style is effective for browsing data in a graph.
Radio Buttons: This style allows only a single selection.
Drop-down: This style allows only a single selection.
Calendar: This style is automatically selected for Date/Time values. It displays From and To boxes, to enter the date range.
You can include or exclude data using the attribute values selected in the filter. Hover the cursor over the name of the filter that you just added, click the arrow icon, and select one of the following:
To display data only for selected values, select Include.
To display data for all values except the values that are selected, select Exclude.
If the Filter panel contains multiple attribute filters, you can determine whether making selections in the filter affects the items displayed for other attribute filters in the Filter panel. For a more detailed description of how filtering attribute filters works, including examples and steps, see Filtering the attribute elements displayed in an filter for a sheet.
By default, as you make choices in the Filter panel, data is automatically updated in the sheet. You can change this behavior so that you control when the update occurs by disabling automatic apply. When automatic apply is disabled, you click Apply in the Filter panel to update the sheet with the filter choices. For steps, see Applying filter changes individually or all at once.
Creating filters for a sheet of data
Adding, modifying, and deleting sheets in a dashboard
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices