Crystal Docs
English
English
  • Welcome
  • Fundamentals
    • Crystal
    • Crystal Topics
  • Crystal Advisor
    • Access to Crystal
      • Signup
      • Login
      • Discover the Advisor
        • Notifications
        • Account
    • Talk to Your Data
      • Conversation
        • Request Topics
          • Entity-Based Conversation
          • Context Memory
          • Autocomplete
        • Request a Data Analysis
        • Disambiguation
    • Explore Your Data
      • Suggestions
      • Topics Overview
      • Filter Topics
      • Ask Topics
      • Past Questions
      • Change Chart
    • Analyze Your Data
      • Automated Insights
      • Insight Analysis
      • Alerts
        • Anomaly Detection
        • Threshold Monitoring
        • Topic Scheduling
      • Forecasting (Beta)
    • Report and Discuss Your Data
      • Export Topic
      • Share Topic
      • Data Storytelling
    • Customize Your Experience
      • Choose Language
      • Choose Theme
    • Crystal on Mobile
      • Siri & Shortcuts
    • Crystal on Microsoft Teams
      • Download Crystal on Teams
  • Crystal Console
    • Configure Crystal
      • Discover the Console
      • Choose Project Settings
      • Prepare Your Data
    • Create Topics
      • Topic Creation: Overview
      • Topic Creation: Connect
        • Supported Data Sources
        • Supported Data Fields
        • Manage Data Sources
        • Tutorials for Specific Data Sources
          • Connect Google Sheets
          • Connect Google BigQuery
          • Build a Web Connector
      • Topic Creation: Configure
        • Objectives and Visualizations
        • Data Binning
        • Configure Custom Entities
        • Configure Key Values
        • Modify Data Table
      • Topic Creation: Filter
      • Topic Creation: Train
      • Topic Creation: Topic Details
      • Topic Creation: Set Permissions
      • Topic Creation: Review and Publish
      • Specifc Visualizations Guides
        • Build a List Table
        • Build a Single Line Chart
        • Build a Multi-Line Chart
        • Build a Ranking Table
      • Topic Creation: Custom Topic Titles
      • Topic Statuses
      • Data Preview
      • Manage Your Entities
    • Manage Users
      • Discover the Users Area
      • Invite Users to Crystal
        • Invite Users Manually
        • Invite Users via Identity Providers
          • Enable the Microsoft Identity Provider
          • Enable the Google Identity Provider
      • Create and Manage Groups
      • Manage Permissions
  • Limitations
    • Limitations on Crystal Advisor
    • Limitations on Crystal Console
  • Support
    • Support on Crystal Advisor
    • Support on Crystal Console
  • Release Notes
    • 2024
      • Crystal Web
        • Crystal Web v2.59
        • Crystal Web v2.58
        • Crystal Web v2.57
        • Crystal Web v2.56
      • Crystal Mobile
        • Crystal Mobile v3.1.7
        • Crystal Mobile v3.1.6
        • Crystal Mobile v3.1.5
        • Crystal Mobile v3.1.4
        • Crystal Mobile v3.1.3
        • Crystal Mobile v3.1.2
        • Crystal Mobile v3.1.1
        • Crystal Mobile v3.1.0
        • Crystal Mobile v3.0.39
        • Crystal Mobile v3.0.38
    • Archive
      • 2023
        • Version 2.55
        • Version 2.54
        • Version 2.53
        • Version 2.52
        • Version 2.51
        • Version 2.50
        • Version 2.49
        • Version 2.48
        • Version 2.47
        • Version 2.46
        • Version 2.45
        • Version 2.44
        • Version 2.42
        • Version 2.41
        • Version 2.40
        • Version 2.39
        • Version 2.38
      • 2022
        • Version 2.37
        • Version 2.35
        • Versions 2.29-2.30
        • Versions 2.27-2.28
        • Version 2.26
        • Versions 2.24-2.25
        • Version 2.23
        • Version 2.22
        • Version 2.21
        • Version 2.20
        • Version 2.19
        • Version 2.18
        • Version 2.17
      • 2021
        • Version 2.15
        • Version 2.14
        • Version 2.13
        • Version 2.12
        • Version 2.11
        • Version 2.10
        • Version 2.9
        • Version 2.8
        • Version 2.7
        • Version 2.6
        • Version 2.5
        • Version 2.4
        • Version 2.3
        • Version 2.2
        • Version 2.1
Powered by GitBook
On this page
  • Filter Topics from the Topic Card
  • Time Range
  • Dynamic Filters

Was this helpful?

  1. Crystal Advisor
  2. Explore Your Data

Filter Topics

This page describes the Filter Topics capability.

PreviousTopics OverviewNextAsk Topics

Last updated 6 months ago

Was this helpful?

In every Topic Card, there is a "Filter" button located at the bottom of the Actions Bar.

Click on it to to keep exploring your Topic in greater depth by applying , both Dynamic Filters and / or Time Ranges.

Note

  • Applying filters this way is an alternative to directly in a conversation.

  • You can also filter a whole list of Topics from the

  • The filters applied to the Topic will also be kept when you save that Topic in a

Filter Topics from the Topic Card

After clicking on the "Filter" button, you will be to select which Filters you want to edit or add.

As usual, you can choose between Time Ranges and Dynamic Filters.

Note

You can also edit Filters by clicking on the "See More" option on the Topic Card, which signals that some Filters are applied to the Topic. You can also choose the "Edit" option from "View Filters" page.

Time Range

When you click on the calendar on the top left side of the screen, you will see a list of options, allowing you to pick a time range for the selected Topic.

Time Ranges options include:

  • "This year" preset: selects the time range between January 1st of the current year and today, dynamically updating "today" over time

  • "Last year" preset: selects the time range between January 1st and December 31st of the previous year, with a dynamic consideration of the current year

  • "Custom" Time Range: you can select a time range with the starting and ending dates you prefer (ending dates can also be in the future, if the underlying data allow for it).

Dynamic Filters

You can find all the available filters listed by filter name: e.g. Sales Agent, Forecast Month, Account, etc.

The Search Bar may help you speed up your Filter research should there be too many Filters to choose from.

Alternatively, you can sort the Filter list by choosing an A-Z order, a Z-A order, or choosing to only view selected or unselected Filters.

For each filter, you can select a specific value.

Just click on the chosen Filter to view and select the values available.

You can also apply multiple values from multiple filters.

To finalize the operation, select as many values as you need, then click on the "Apply" button down below.

You can also remove one or more filters and / or filter values in one of the following ways:

  • by manually de-selecting each of them inside the filter space

  • in bulk, by clicking on the "Clear" button on the right

This last action will result in the removal all of the values selected inside that filter.

Alternatively, click on "Clear all" to completely remove all the filters applied.

Please Note

In the cases of Databases with custom Row-Level Security policies applied, the displayed suggestions of Filter Values are restricted to the values that you have permissions for at Database level only.

Keep exploring your data!


Filters
asking Crystal
Topics Section
Data Story
See more
View and edit filters
Apply Time Range
Apply Dynamic Filters