Topic creation: configure
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:
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!
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).
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!
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.
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.