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

Was this helpful?

  1. Crystal Console
  2. Create Topics
  3. Topic Creation: Configure

Modify Data Table

This page is currently under review. Stay tuned!

PreviousConfigure Key ValuesNextTopic Creation: Filter

Last updated 1 year ago

Was this helpful?

During the topic configuration phase there is the possibility to modify the data table by adding static filters or a sort, in order to get more precise insights out of your data.

These are optional functions, but they can be very useful to narrow down your results and analyze your data according to given parameters.

Filters can help to refine the insights by setting parameters for the retrieved data.

The types of operations supported are:

  • Equal to

  • Different than

  • Greater than

  • Less than

  • Greater than and equal to

  • Less than and equal to

  • Between

  • Empty

  • Not empty

  • Is

  • Is not

  • Contains

  • Not contains

  • Starts with

  • Ends with

The sort function gives the user the capability of sorting the dataset along some dimension. For example, given that the column Age is present, a user may want to sort the data according to ascending or descending order.

For some visualizations the sort option is not available. For instance, for a single line chart where the time series is considered on the x-axis, no sorting should be allowed since the data is presented in chronological order. Thus, timestamps cannot be sorted since they are already in the correct sequence.

Sorting is an option for the following visualizations:

  • Single column

  • Single column pos neg

  • Cluster column

  • Stacked column

  • Scatter plot

  • Gauge chart

  • Table.

You will have to choose the column to sort and the type of sorting (e.g. ascending or descending). It is possible to apply a sort to only one column.

Remember that for some objectives (list and ranking) the sort function is set by default, but you change the order (for example AZ to ZA).

Do you want to know more about the single visualization types and the many opportunities that you have for getting insights from your data?


For example, you might like to exclude all data that is below zero. The filters applied to the data table are static, meaning that they will always be applied by default to the topic. Not to be confused with the that are found in the next step, where you can choose what filters values to apply to your topic in the conversation. Once you select the filter data option, you will have to indicate the column and the operation you want to execute.

You can add multiple filters. In order to check the effect the filters had on your topics data table, you can always click on the button in the top right corner of the view.

Check out and !

dynamic filters
Preview data
How to build a ranking table
How to build a list table