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
  • Discover The Hidden Insights
  • How Do They Work?
  • Insights Catalog

Was this helpful?

  1. Crystal Advisor
  2. Analyze Your Data

Automated Insights

This page describes the Automated Insights capability.

PreviousAnalyze Your DataNextInsight Analysis

Last updated 5 months ago

Was this helpful?

Sometimes, a graph alone is not sufficient to convey all the granular meanings hidden under data, and digging into it can be very time consuming and require specific technical skills.

For this reason, along with the Topic Chart, each Topic always comes with a set of additional information, called Automated Insights, which are directly related to it.

This set of information can be extracted from the dataset underlying the Topic but cannot be represented on a graph.

Therefore Crystal doesn't just answer your questions providing punctual graphic information, but also helps you understand them better by providing a complete and accurate description of what the data is actually revealing below the surface.

In particular, Automated Insights are based on a Data Analysis technique called Descriptive Analytics.

Pills of Data Analysis

Descriptive Analytics are called this way because they describe the dataset, with a special focus on past and present events.

Discover The Hidden Insights

Accessing the Automated Insights of your Topics is straightforward:

  1. First, ask your question to Crystal

  2. Spot the Right Sidebar of the Advisor Workspace

  3. There, you will find the list of all the Insights available for your Topic

At this point, you can scroll through the Insights provided and let them guide your analysis. The information provided will help you get a better understanding of the most relevant aspects of the Topic and how to continue your analysis.

Please Note

  • The number of Insights available for each Topic can range from a minimum of one Insight to a maximum of 12, depending on the Topic's underlying data.

  • Insights are dynamic. Since they are always related to the Topic you just asked about, they will always change based on your questions

How Do They Work?

As Descriptive Analytics, the Automated Insight can shed light on an amount of information related to what happened to your data in the past and what is happening right now.

The number of Insights available for a Topic depends on the type of Objective and Visualization, because each Objective / Visualization has specific information that can be extracted from it.

However, the actual number of Insights shown for a requested Topic depends on the specific requirements needed to calculate each Insight.

Therefore, whenever you ask about a specific Topic, Crystal detects the type of Objective / Visualization, and from the list of related Insights available, calculates as many applicable Insights as possible based on the specific data underlying the Topic.

The final result of displayed Insights can be a number between 1 and 12 Insights.

Insights Catalog

Below is a complete list of Automated Insights that Crystal is able to extract.

Please Note

This list reports the general purpose and logics of the analysis for each Insight.

However, in practice, the specific calculations vary slightly to adapt to the Objective / Visualization they are applied to.

N.
Insight
Logic

1

Average and Variability

Calculates the Mean and the Standard Deviation of an Entity.

2

Major Mean

Calculates the Entity with the highest average of all entities.

3

Minor Mean

Calculates the Entity with the lowest average of all entities.

4

Highest Sum

Calculates the total sum of the relevant values associated with a specific Entity. It then groups these values according to a category and identifies which category has the highest total sum, thus highlighting the Entity with the highest value within the dataset.

5

Lowest Sum

Calculates the total sum of the relevant values associated with a specific Entity. It then groups these values according to a category and identifies which category has the lowest total sum, thus highlighting the entity with the highest value within the dataset.

6

Extreme Values

Calculates the Minimum Value(s) and the Maximum Value(s) of an Entity.

7

Unique Values

Calculates the number of distinct values of an Entity.

8

Focus on Last Timeframe

Calculates the Entity Value at the beginning and at the end of the last consolidated timeframe, based on the Time Aggregation configured for the Topic (Months, Quarters, Years, ...).

Calculates the Average of the Entity across the Time Range.

9

Global Change

Identifies the Entity Value at the beginning and at the end of a Time Series, based on the Topic’s Time Range.

Calculates the difference between the starting point and the end point of the Time Series.

Calculates the percentage difference between the starting point and the end point.

10

Highest Difference

Calculates the highest difference, both in absolute value and in percentage, among consecutive values.

11

Lowest Difference

Calculates the lowest difference, both in absolute value and in percentage, among consecutive values.

12

Interesting Event

Searches for statistical anomalies.

If multiple anomalies are identified, selects the most “anomalous” anomaly.

13

Timeframe Comparison

Compares the values of on Entity in two different time periods, then highlights the variation.

14

Top Contributor

Ranks all Entity Values from highest to lowest.

Identifies the one with the highest value.

Calculates the percentage of this highest value against the Total Sum of the Entity across all Values.

15

Bottom Contributor

Ranks all values of the Entity from highest to lowest. Identifies the one with the lowest value. Calculates the percentage of this lowest value with respect to the Entity's total sum of all values.

16

Best Performer

Groups in one category, then identifies an entity that is first for an entity in another category and at least third for another entity.

17

Worst Performer

Groups in one category, then identifies an entity that is last for an entity in another category and at least third last for another entity.

18

Percentage Difference

Calculates the difference between two percentages.

19

Cluster Comparison

Finds the total average, then the average for the top N, and the average for the bottom N.

20

Distribution of Data

Calculates how many positive and negative values are present.

21

Mean of Positive and Negative Values

Calculates the mean of positive and negative values.

22

Total of Positive and Negative Values

Sums up the positive and negative values.

23

Correlation

Calculates the correlation between two variables.

24

Highest Similarity

Calculates how often the time series overlap with each other.

25

Value of Progress

Highlights the value of the progress towards a target.

26

Percentage of Progress

Highlights the percentage of target reached.

27

Most Common Value

Highlights the most common value found.

Keep analyzing your data!


Automated Insights
Topic Insights