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
  • Objective & visualization type
  • Build your topic
  • Measure (numerical) column

Was this helpful?

  1. Crystal Console
  2. Create Topics

Topic Creation: Configure

This page is currently under review. Stay tuned!

PreviousBuild a Web ConnectorNextObjectives and Visualizations

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:

  • Configure

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. In this article, we will follow the Configuration, step by step: it’s not as hard as it might look!

Let’s begin.

Objective & visualization type

Once you have selected the data to build your topic, you have to choose which objective you want to use.

An objective is essentially the insight you want to get out of this data (such as a comparison, ranking, or progress overview of your data).

Check to know everything about which objectives to choose for your purposes and which visualizations are related to each objective.

You will choose the objective that is most accurately going to respond to your needs.

Once you have selected an objective and chosen the type of visualization you want to use, it’s time to build the topic!

Build your topic

We will use the single column chart as an example for showing the topic building process. Keep in mind that the required fields will be different depending on the visualization type selected in order to guide you through the process.

In this phase you will indicate which data needs to be considered to transform your insights into a visualization.

In the header, you will see the objective and visualization type previously selected: if you want to modify them you can click on the edit icon. Keep in mind that if you change them after having already selected data columns for your topic, those selections will be lost.

Measure (numerical) column

The measure column contains numeric, quantitative values that you can measure and can be aggregated. For example, in our single column chart, on the y axis sales could be measured.

The function selection is when the values of multiple rows are grouped together to form a single summary value. A function can be an operation, such as sum or count, or a parameter, such as average or the minimum and maximum of selected data.

For example, you want to know the total sum of sales for each product. In this case you would select SUM as your function.

Note that, as of now, only sum, average, count and count distinct can configured as operations.

The column type selection refers to the data type and its related unit of measure. Depending on the data, it can be numeric, weight, power, distance, currency or percentage. For example, you would select currency if you are measuring monetary sales.


Remember that you can click on at any time to consult the data available.

You might also want to insert a static filter to better detail the insights you want to get out of your topic: read the article on how to to know how to use static filters.

There are more actions you can do to refine the configuration of your topic: check out the article dedicated to and the to know more, or

If you want to go ahead with the topic creation process instead, go to

Preview data
modify data tables
data binning
key value
how to create a custom column.
Topic creation: filter.
Connect
Filter
Train
Objectives and visualizations