Building charts from Configuration pane

Configure informative and comprehensive charts tailored to meet your needs

The chart configuration in Tellius is designed to be intuitive and flexible, allowing you to easily customize data visualizations to fit your specific needs.

Fields and their usage

Here's a brief description of prominent fields found in the Configuration pane:

Configuration pane for bar chart

• Measure: This field is for the numerical data you want to analyze, like sales or revenue. It defines the basis of your chart's quantitative analysis. Example: Profit, Revenue, Quantity

• Dimension: Dimensions are the categories you're measuring by, such as time periods, regions, or product categories. They provide context for the measures. Example: Category, Market, Country

• Dimension (Date): This field accepts only date-based columns. ➤ Set a time grain (e.g., YEARLY, MONTHLY, DAILY) to define the sparkline cadence.

To know more about the difference between measures, dimensions, and date columns, check out this page.

• Color By: Assign colors to different segments of your data, such as regions or products, to visually distinguish and analyze patterns and trends. Example: If you select the column "Region" for Color By field, then the chart uses different colors to represent sales data from different geographical areas.

• Sort By: Determines the order of data presentation in your chart, which can be ascending or descending, helping to prioritize or sequence data points. Example: If you select the column "Sales" (descending order) for Sort By field, then the chart prioritizes higher-selling items.

• Tooltip: When hovering over elements of the chart, tooltips provide additional information like exact figures or related data, enhancing the detail available on demand. Example: If you select the column "Units sold" for Tooltip field, then the chart shows the exact number of units sold in tooltip when hovering over it.

• Unused: Here, you can store columns that are currently not in use but might be needed for future reference or analysis because the chart type or other chart configurations changed.

• Pagination (Enable/Disable Toggle): This controls whether your chart breaks data into pages or shows all data at once, useful for managing large data sets.

• Show Rows (Number Field): Decide the number of rows to be considered for preparing the chart, focusing on a specified amount of data entries.

• Include Nulls (Checkbox): This option includes or excludes null values from your data, allowing you to decide whether to consider or ignore incomplete data points. Example: In a product performance analysis, include nulls to see all products, even those without any sales.

• Dual Axis (Checkbox): Enables you to plot two measures on the same chart with separate Y-axes, useful for comparing different types of data. Example: Display website traffic (first axis) alongside conversion rate (second axis) for a digital marketing analysis.

• Show Query Time (Enable/Disable Toggle): Displays the time taken by Tellius and other external engines to execute the query.

Please note that each type of chart will have a unique configuration. Not all charts will have all the above-mentioned fields. For example, KPI charts will have only Measure, Tooltip, and Unused fields for simple yet effective visualization, whereas bar charts offer a wider range of fields to provide more detailed and complex visualizations.

To know more about the additional fields that are not listed here, check out this page.