Refining data for charts

From the Filters or the Filters and predictions tab, refine your data selection. Filters allow you to select a subset of data that you want to focus on, or to exclude data. A time range can already be set at the dashboard level but you can also set a specific time range only for a chart.

Procedure

  1. In your chart editor, go to the Filter or Filters and Predictions tab
  2. Select Filters: pie chart
    1. Click on the + next to Filters
    2. From Data Item, select the data item that you want to focus on
    3. Choose the operator you need
    4. Set the value:
      • For items of type keyword or date with the operator =, !=, is in or is not in, you can write a custom value or select a value from the existing ones in the dropdown. Also, empty values and special characters are allowed.
      • For is in and is not in operators, click the + or - to add or remove a value.
    5. The preview on the right side is updated with this Filter
    6. (Optional) Click again on the + next to Filters to add another filter. Filters are combined with the AND operator.
    7. (Optional) To remove a filter, click the trash icon at the end of the respective line.
  3. Set a Time Range
    1. In the Time range section, check the "Override the dashboard time range in this chart" checkbox.
    2. You have different options to set the range
      1. Fixed date. Pick a start date and time, and an end date and time. Your timezone will be automatically accommodated.
      2. By choosing Sliding date, you will be able to select a dynamic date range.
      3. No range. If you select this option, no time range will be applied for this chart even if your dashboard is configured with a time range.
      4. The shortcuts helps you filling automatically the time range with the last 7, 30 or 365 days for instance.
  4. (For period Metrics and period KPI only) You can activate and configure the predictions feature. See Enabling predictions.