Filtering data allows you to remove rows from your data results so you can drill in on a subset of your data. By design, you can click and filter-down into any data in Hashboard. This means there are lots of ways to filter data and we'll walk you through all of those here.
The fastest way to filter data is by using attribute panels. See the attribute tray page for lots of details on how to filter data from the attribute panels.
Charts generally support two types of filtering: 1) filtering by dragging chart areas and 2) filtering by clicking items in a chart. Both of these are described in the Chart Interactions section.
While you can use a drag filter to drag to a time range eg. a specific month or series of months. Sometimes you want more control over, like picking specific days (or times) to filter to. To do this, you can filter for a very specific range with the date filter control:
- In the control pane, click the
- If the current chart supports the date control, you will see it listed at the top of the configuration. Click the date range to open the date filter control.
- Relative filters: You can either select a relative time filter (eg. 6 months) which will filter for the last six months.
- Exact time filter: selecting exact dates with the calendar will limit data to a fixed time frame.
When data updates, relative time filters will slide over time while fixed time filters will be fixed in time. So if you filter to September 1st through September 8th, you'll always be looking at that one week of data. If you filter for 1 week, you'll always see the most recent one week.
Array filters are used to narrow down data based on specific elements within an array. They are applied on the items in the array before grouping the data. For example, let's say you have a dataset of customer contact events, and each event has an array field of all the associated campaigns. When you filter the array for a specific campaign, you will be able to see all the events that include that campaign. If you filter for multiple campaigns, you can choose whether you want to see events associated with all of the campaigns or events associated with any (at least one) of the campaigns. You can also filter for events that do not contain one or multiple campaigns. But be careful, because if you choose does not contain all, you are only excluding events with all of those campaigns. Events associated with some but not all of them will still appear in your results. You may want to use the does not contain any filter, instead.
There are two ways to view all filters and remove any filters that are applied.
- In the Control Panel, click the
Filterssection to open it. This will list all filters that are applied.
- Click the
xon a filter to remove it.
The Top Control Bar will always show you how many columns are filtered.
- From the Top Control Bar will always show you how many filters are applied with a number in parentheses. Click the filter label to open the list of filters.
- Click an individual column to remove the filter.