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
  • Create your filters
  • Select time range
  • Inherit filters from existing topics

Was this helpful?

  1. Crystal Console
  2. Create Topics

Topic Creation: Filter

This page is currently under review. Stay tuned!

PreviousModify Data TableNextTopic Creation: Train

Last updated 1 year ago

Was this helpful?

crystal provides insights through topics. Building your topics is the core of the Self-Service Console. The topic creation flow is made of four main steps:

  • Filter

In the first step, you select the data source and the data tables that are needed to build your topic and prelude to the configuration, which is the phase where you decide the information you want to get out of your data.

Then there is the filter step, where you can add dynamic filters to your topic, in order to narrow down the results and cover a variety of user needs. For example, an agent might be interested in filtering Total sales by their specific agency, whereas a manager would like to see Total sales for all agencies they follow.

Keep in mind the filter step is not mandatory: the topic creation can be completed even by skipping this phase, however the opportunity to add dynamic filters to a topic is crucial to better define the insights that will come out of it.

In this view, you will see as a subtitle the details of the data used to build the topic, thechosen and the type of visualization connected.

You can also preview data, as explained

Create your filters

In this section, you must specify information for each dynamic filter you need to add to the topic. In particular, you need to provide:

  • Column: the variable on which the filter will be applied (e.g. sales, product…).

  • Filter type: a type is a classification that is used within crystal to employ the best approach to recognize these values. Depending on the data type of the selected column, the filter type can be location, people or other.

  • Mandatory filter: it allows to specify whether the filter should be mandatory when crystal is asked for the topic: in this case the user is forced to specify a default value. This allows you to ask for the topic in the advisor without necessarily specifying the filter. You can select a maximum of three mandatory filters. For example, let’s assume that you are an insurance company and you created a topic named Sales to monitor your business. If you set the list of the agents of your company as a mandatory filter, this means that you can specify the name of an agent when asking crystal for the topic Sales. However, if you don’t specify any value in your question, then crystal will just use the default one.

  • Default value: this is the value that crystal will apply by default to a filter if you don’t specify another value. It is only needed when you are using a mandatory filter and it is determined by the chosen Column.

Select time range

If you configured your topic by selecting an over time objective, you already selected a time column to filter by. You can still modify the default time range (for example, from “last month” to “last year”). This will be applied to the topic when it is not specified in the conversation.

However, there might be other charts for which you determined a time column in the configuration step. Adding time filters can help you getting more precise insights by choosing a period of interest for your data.

In order to do so, you need to choose the following elements:

  • Column: the variable on which the filter will be applied, e.g. time, date or year. The type of this column must refer to a given period of time.

  • Time filter: the default time range that will be shown in relation with the topic. For example, if we have a topic with default value this year, it means that when you ask for the topic in the advisor, it will show by default for the current year.

crystal offers a few choices by default to define your time range, but you also have the opportunity to customize your choice based on your needs.

If you click on Create custom time range, you will have the option to set the time range that better suits you. You can choose among different presets, static or custom dates:

Inherit filters from existing topics

To speed up the filters configuration process, you can also import filters from other topics: depending on the topic configuration, you can check and select the available filters to import by clicking the browse filter button on the top screen:


We hope that this article was helpful! Do you want to know how to complete the topic configuration process by training your topic? Check it

here.
Connect
Configure
Train
objective
in the related article.