Filters allow you to dig deeper into your data. Whether you're trying to compare last year's sales to this year's, or trying to look at product performance in a specific state, filters will help you uncover the information you need. Applying a filter will quickly update most of the visualizations in your dashboard to reflect only the information you're looking for.

In this tutorial, you'll learn more about applying standard filters and cross-filtering, as well as how to select multiple filters.

 

Standard filtering

Every Crisp data dashboard comes with standard filter options. The filtering tool is at the top of each dashboard, appearing before your data visualizations. 

basic_filter.png

Standard filters typically include a combination of date, date granularity, state, chain or banner name, location, customer, or product. Clicking on a filter option will reveal a drop down menu for greater control over the filter settings. 

basic_filter_dropdown_options.png

The + icon beside the filter drop down menu allows you to add additional filtering rules to hone in on exactly what data you want to see. 

additional_filtering_granularity.png

Not sure what to filter by? Click the empty text entry box to see a list of options. It may take a few seconds for the options to populate, especially if you have many to choose from. 

filter_options.png

Click the reload icon reload.png beside the filter tool to refresh your data. Most visualizations will then update to reflect only the information that falls within the specifications of your filter settings. 

 

Cross-filtering 

Cross-filtering is a feature that allows you to click the elements in visualizations to automatically apply a filter. Clicking on the following types of visualizations will apply cross-filters that immediately update others in the dashboard.

Screen_Shot_2020-09-22_at_3.11.47_PM.png
Clicking on a state within a heat map such as Sales by State will automatically filter dashboard visualizations by that state. 

Sales_Quantity_Over_Time.png

Clicking on a point in a line graph such as Sales Quantity Over Time will automatically filter visualizations by that date.

Screen_Shot_2020-09-22_at_3.14.30_PM.png
Clicking on a bar within a bar chart such as Qty Shipped by Product will filter your other visualizations by the selected product. 

Screen_Shot_2020-09-22_at_3.12.51_PM.pngScreen_Shot_2020-09-22_at_3.12.34_PM.png

Selecting colors in stacked bar graphs such as Channel Share and Product Share Over Time will filter your visualizations by channel or product and time period. 

Sales_by_City.png

Sales_by_City_Filter.png

Clicking bars or cells within a table such as Sales by City will also apply a filter.

Applying multiple filters

Press and hold command on your keyboard when clicking to apply multiple items as filters.

Select_Multiple_Filters.gif