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.
Every Crisp data dashboard comes with standard filter options. The filtering tool is at the top of each dashboard, appearing before your data visualizations.
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.
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.
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.
Click the reload icon 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 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.
Clicking on a state within a heat map such as Sales by State will automatically filter dashboard visualizations by that state.
Clicking on a point in a line graph such as Sales Quantity Over Time will automatically filter visualizations by that date.
Clicking on a bar within a bar chart such as Qty Shipped by Product will filter your other visualizations by the selected product.
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.
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.