Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Apply a Row-Level Filter to a Visual

You can apply row-level filters for the data in a visual. When more than one filter is applied to a visual (either via the visual itself or via a dashboard filter), the filter conditions are ANDed. In other words, both filter conditions must be met for the data to appear in the visual.

Steps to apply a row-level filter to a visual

  1. Select the filter icon () on the visual or select Edit Visual from the visual menu() and then select on the sidebar menu.
  2. The filters sidebar appears showing any filters that have been applied.
  3. Three tabs appear on the filters sidebar, allowing you to create a row-level filter, a group filter, or a saved filter. If these tabs do not appear, select Add Filter to see them.
    TabDescription
    RowThe Row tab allows you to create a row-level filter, as described in the rest of this article.
    GroupThe Group tab allows you to create and use a group filter. See Apply Group Filters. If you are using a KPI, raw data, histogram, or map markers visual, the Group tab is not available because all filters on these visuals are row-level filters.
    Saved

    The Saved tab shows saved filters that you can apply to the dashboard or visual. See Edit Saved Filter.

  4. Select the Row tab and then select the filter attribute, number, or time field you want to use from the list. The process of creating a row-level filter varies based on the type of field you select.
  5. You can also select to access the Create Derived Fields or the Create Custom Metrics to create or modify derived fields and custom metrics to be used as filters.
  6. After the filter specifics have been provided, select Apply. The filter is applied to the selected (active) visual. Note that a number appears in a green circle next to the filter icon on the visuals to which the filter has been applied. The number represents the number of filters applied to the visual.

Example

Suppose you want to learn what the planned sales are for different product categories for male customers in San Francisco. You might apply a series of row-level filters using the following steps.

  1. On your sales visual, select Group (x-axis) and then select Product Category from the list. The visual data is grouped by product category purchases.
  2. On your sales visual, select Planned Sales for the Metric (y-axis). Your visual might look like this:

  3. Select the filter icon () on the visual.
  4. On the Row tab, select City.
  5. On the next page, select the Value tab and ensure Include is selected on the tab. Then locate and select San Francisco from the list of available attribute values.
  6. Select Apply. Your filter is now displayed on the Filters sidebar and is applied to your visual. The visual shows all planned purchases in San Francisco by category.
  7. In the Filters sidebar, select Add Filter again.
  8. Select the Gender attribute on the Row tab.
  9. On the next page, select the Value tab and ensure Include is selected. Then select Male from the list of available attribute values.
  10. Select Apply. The filters sidebar shows both filters you have applied to your visual. The visual shows all planned purchases in San Francisco by men. The purchases are grouped by category and might look like this:

  11. Filters are not saved automatically. To save your filter, select Save Filters on the filters sidebar. The Save Filter Set dialog appears.

  12. Enter a name for the saved filter and, optionally, a description. If you want to share your filter, slide the Share Filter Set switch on (to the right). This shares the filter with other users when they view dashboards created using that same source.

Published:

Apply a Row-Level Filter to a Visual

You can apply row-level filters for the data in a visual. When more than one filter is applied to a visual (either via the visual itself or via a dashboard filter), the filter conditions are ANDed. In other words, both filter conditions must be met for the data to appear in the visual.

Steps to apply a row-level filter to a visual

  1. Select the filter icon () on the visual or select Edit Visual from the visual menu() and then select on the sidebar menu.
  2. The filters sidebar appears showing any filters that have been applied.
  3. Three tabs appear on the filters sidebar, allowing you to create a row-level filter, a group filter, or a saved filter. If these tabs do not appear, select Add Filter to see them.
    TabDescription
    RowThe Row tab allows you to create a row-level filter, as described in the rest of this article.
    GroupThe Group tab allows you to create and use a group filter. See Apply Group Filters. If you are using a KPI, raw data, histogram, or map markers visual, the Group tab is not available because all filters on these visuals are row-level filters.
    Saved

    The Saved tab shows saved filters that you can apply to the dashboard or visual. See Edit Saved Filter.

  4. Select the Row tab and then select the filter attribute, number, or time field you want to use from the list. The process of creating a row-level filter varies based on the type of field you select.
  5. You can also select to access the Create Derived Fields or the Create Custom Metrics to create or modify derived fields and custom metrics to be used as filters.
  6. After the filter specifics have been provided, select Apply. The filter is applied to the selected (active) visual. Note that a number appears in a green circle next to the filter icon on the visuals to which the filter has been applied. The number represents the number of filters applied to the visual.

Example

Suppose you want to learn what the planned sales are for different product categories for male customers in San Francisco. You might apply a series of row-level filters using the following steps.

  1. On your sales visual, select Group (x-axis) and then select Product Category from the list. The visual data is grouped by product category purchases.
  2. On your sales visual, select Planned Sales for the Metric (y-axis). Your visual might look like this:

  3. Select the filter icon () on the visual.
  4. On the Row tab, select City.
  5. On the next page, select the Value tab and ensure Include is selected on the tab. Then locate and select San Francisco from the list of available attribute values.
  6. Select Apply. Your filter is now displayed on the Filters sidebar and is applied to your visual. The visual shows all planned purchases in San Francisco by category.
  7. In the Filters sidebar, select Add Filter again.
  8. Select the Gender attribute on the Row tab.
  9. On the next page, select the Value tab and ensure Include is selected. Then select Male from the list of available attribute values.
  10. Select Apply. The filters sidebar shows both filters you have applied to your visual. The visual shows all planned purchases in San Francisco by men. The purchases are grouped by category and might look like this:

  11. Filters are not saved automatically. To save your filter, select Save Filters on the filters sidebar. The Save Filter Set dialog appears.

  12. Enter a name for the saved filter and, optionally, a description. If you want to share your filter, slide the Share Filter Set switch on (to the right). This shares the filter with other users when they view dashboards created using that same source.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk