What's New
Changelog - 5.2.1
Release 5.2
Changelog - 5.1.3
Changelog - 5.1.2
Changelog - 5.1.1
Release 5.1
Changelog - 5.0.5
Changelog - 5.0.4
Changelog - 5.0.3
Changelog - 5.0.2
Changelog - 5.0.1
Release 5.0
Changelog - 4.3.4
Changelog - 4.3.3
Changelog - 4.3.2
Changelog - 4.3.1
Release 4.3 (Fall 2023)
Changelog - 4.2.7
Changelog - 4.2.6
Changelog - 4.2.5
Changelog - 4.2.4
Changelog - 4.2.3
Changelog - 4.2.1
Changelog - 4.2.2
Release 4.2
Changelog - 4.1.5
Changelog - 4.1.4
Changelog - 4.1.3
Changelog - 4.1.2
Changelog - 4.1.1
Release 4.1
Release 4.0
Release 3.9
Release 3.8
Release 3.7
Release 3.6
Release 3.5
Release 3.4
Release 3.3
Release 3.2
Release 3.1
Release 3.0
Release 2.4.1
Release 2.4
Free Cloud Trial
Release 1.8
Release 2.3
Release 2.2
Release 2.1
Release 2.0
Release 1.7
Release 1.6
Release 1.5
Getting Started
Quick Guide
Best Practices Guide
Search - Best Practices
Vizpads (Explore) - Best Practices
Insights (Discover) - Best Practices
Predict - Best Practices
Data - Best Practices
Glossary
Tellius 101
Navigating around Tellius
System requirements
Tellius Architecture
Installation steps for Tellius
Guided tours for quick onboarding
Customizing Tellius
Search (Natural Language)
Search in Tellius
Guide Me
How to Search
Business View List / Columns
Query
Query
Percentage Queries
Time Period Queries
Live Query
Generating Insights-based queries from Search
Search Result
Discover Insights
Interactions
Chart Operations
Add to Vizpad
Table View
Switch Chart type
Change Chart Config
Apply Filters
Change Formatting
Measure Aggregation - Market Share Change
View Raw Data
Download/ Export
Embed URL
Partial Data for Visualization
Best-fit visual
Add to Vizpad
Adding the chart to a Vizpad
Customize the auto-picked columns
Search Query Inspector
Teach Tellius
History
Guided Search
Add Guided Search Experience
Display Names in the Search Guide
Guided Search
Guided Search Syntax and Attributes
Deep Dive
Maps in Search
Search Keywords
Percentage Queries
Time Period Queries
Year-over-Year Analysis
Additional Filters
Pagination
List View In Search Results
Marketshare queries
Embed Search
Personalized Search
Search Cheat Sheet
Filters in Help Tellius Learn
Explore (Vizpads)
Dashboards in Tellius
Vizpad Creation
Create Interactive Content
Create Visualization Charts
List of Charts
Common Chart Types
Line Chart
Bar Chart
Pie Chart
Year-over-Year Functionality in Vizpad
Area Chart
Combo Chart
KPI Target Chart
Treemaps
Bubble Chart
Histogram
Heat-Map Charts
Scatter Chart
Other Charts
Cumulative line chart
Cohort Chart
Explainable AI Charts
For each chart
Create Visualization Charts
Global Filters
Embedded Filters
Other Content
Anomaly management for charts
Creating Interactive Content
Vizpad level Interactions
Viz level Interactions
Discover Insights
Drivers
Discover hidden insights - Genius Insights
How Genius Insights works
Discoveries in Insight
Anomalies on Trend
Interactions
Chart Operations
Switch Chart type
Change Chart Config
Apply Filters
Change Formatting
Add X/Y Axis Target Lines to Scatter Chart
Improvements to Conditional Formatting
Adding Annotations to Tables
Displaying query execution time
Embedding Vizpad
Vizpad Consumption
Collection of Interactive Content
Vizpad level Interactions
Global Filter on the fly
Global Resolutions
Refresh
Notifications / Alerts
Share
Download / Export
Unique name for Vizpads
Edit Column Width
Viz level Interactions
Importing bulk filter values
Multi-Business View Vizpads
Discover (Genius Insights)
Discoveries
What are discoveries
Type of Discoveries in Tellius
Create Discoveries
Kick-off Key Drivers
Edit Insights
Key Driver Insights
Components of Key Drivers
What are Key Drivers
Edit Key Driver Insights
Segment Drivers
Trend Drivers
Trend Insights (Why Insights)
Components of Trend Insights
WHAT: Top Contributors
WHY: Top Reasons
HOW: Top Recommendations
Seamlessly navigating to "Why" from "What"
Create Trend Insight
Edit Trend Insights
What are Trend Insights
Comparison Insights
Components of Comparison Insights
Create Comparison Insight
What are Comparison Insights
Edit Comparison Insights
Others Actions
Save
Refresh
Share Insights
Download
Adding Insights to Vizpad
Insights Enhancements
Embedding Insight
Impact Calculation for Top Contributors
Marketshare
Live Insights
Predict (Machine Learning)
Machine Learning
AutoML
How to create AutoML models
Leaderboard
Prediction
Others
What is AutoML
Point-n-Click Predict
Feed (Track Metrics)
Assistant (Conversations)
Tellius on Mobile devices
Data (Connect, Transform, Model)
Connectors
Connector Setup
Google BigQuery
Google Cloud SQL
Connecting to a PostgreSQL Cloud SQL Instance
Connecting to an MSSQL Cloud SQL Instance
Connecting to a MySQL Cloud SQL Instance
Snowflake
PrivateLink
Snowflake Best Practices
OAuth support for Snowflake
Integrating Snowflake with Azure AD via OAuth
Integrating Snowflake with Okta via OAuth
Edit Connector
Live Connect
Data Import
Cache
Direct Business View
JDBC connector for PrestoDB
Amazon S3
Time-to-Live (TTL) and Caching
Loading Excel sheets
Looker SQL Interface
Databricks
Connecting to an AlloyDB Cluster
List of Connectors by Type
Tables Connections
Custom SQL
Schedule Connector Refresh
Share Connections
Datasets
Load Datasets
Configure Datasets (Measure/Dimensions)
Transform Datasets
Create Business View
Share Datasets
Copy Datasets
Delete Datasets
Swapping datasources
Metadata migration
Data Prep
Datasets
Data Profiling / Statistics
Transformations
Dataset Transform
Aggregate Transforms
Calculated Columns
SQL Transform
Python Transform
Create Hierarchies
Filter Data
SQL Code Snippets
Multiple Datasets Scripting SQL
Column Transforms
Column Metadata
Column type
Feature type
Aggregation
Data type
Special Types
Synonym
Rename Column
Filter Column
Delete Column
Variable Display Names
Other Functions
Metadata View
Dataset Information
Dataset Preview
Alter Pipeline Stage
Edit / Publish Datasets
Data Pipeline (Visual)
Alerts
Partitioning for JDBC Datasets
Export Dataset
Write-back capabilities
Data Fusion
Schedule Refresh
Business Views
Create Business View
Create Business View
Datasets Preview & List
Add datasets to Model
Joins
Column selection
Column configuration
Primary Date
Geo-tagging state/country/city
Save to Fast Query Engine
Publish
Business View
What is Data Model
BV Visual Representation (Preview)
BV Data Sample
Learnings (from Teach Me)
Custom Calculations (Report-level Calc)
Predictions on BV
BV Refresh
Export/ Download Business View
Share Business View
URL in Business View
Request Edit Access
Tellius Engine: Comparison of In-Memory vs. Live Mode
Projects (Organize Content)
Monitor Tellius
Embedding Tellius
Embedding
Settings
About Tellius
User Profile
Admin Settings
Manage Users
Team (Users)
Details & Role
Create a new user
Edit user details
Assigning the user data to another user
Restricting the dataset for a user
Deleting a user
Assign User Objects
User roles and permissions
Teammates (Groups)
Authentication & Authorization
Authentication
Authorization (Roles)
API Access (OAuth Access)
Audit Logs
Application & Advanced Settings
Data
Machine Learning
Genius Insights
Usage tracking & Support
CDN
Download Business View, Dataset, and Insights for Live BV
Customize Help
Impersonate
Data Size Estimation and Calculation
Miscellaneous Application Settings
Configuration for time/date-related results
Dataflow Access
Enable In-memory operations on Live sources
Language Support
Administration
Setup & Configuration
Installation Guide
AWS Marketplace
Autoscaling
Backup and Restore
Help & Support
FAQ
Data Preparation FAQs
Environment FAQs
Search FAQs
Vizpads FAQs
Data Caching
Security FAQs
Embedding FAQs
Insights FAQs
Tellius Product Roadmap
Help and Support System
Guided Tours
Product Videos
Articles & Docs
Provide Feedback
Connect with Tellius team
Support Process
Notifications
Tellius Kaiya
Say hello to Tellius Kaiya 👋
Automating the generation and validation of SQL/Python code
Kaiya Learnings
Automating the generation of metadata
Kaiya mode in Search
Chart and tab summaries
Getting Started Videos
Getting Started
Tellius Connect
Tellius Data Overview Video
Connecting to Flat Files Video
Connecting to Data Sources Video
Live Connections Video
Data Refresh and Scheduling Video
Tellius Prep
Getting Started with Tellius Prep Video
Transformations, Indicators, Signatures, Aggregations and Filters Video
SQL and Python Video
Working with Dates Video
Data Fusion Video
Business View Video
Business Mapping Video
Report Level Calculations Video
Writeback to DB
Natural Language Search
Getting Started with Search Video
How-To Search Video
Customizing Search Results Video
Search Interactions Video
Help Tellius Learn
Explore - Vizpads
Getting Started with Vizpads Video
Creating Vizpads Video
Creating and Configuring Visualizations Video
Viz-Level Interactions Video
Vizpad-Level Interactions Video
Auto Insights
Getting Started with Auto Insights Video
Discovery Insights Video
Segment Insights Video
Trend Insights Video
Comparison Insights Video
Iterate on Insights Video
Tellius Feed Video
Predict - ML Modeling
Getting Started with Predict Video
AutoML Configuration Video
AutoML Leaderboard Video
Point-n-Click Regression Video
Point-n-Click Classification Video
Point-n-Click Clustering Video
Point-n-Click Time Series Video
Point-n-Click PythonML Video
PredictAPI Video
Apply ML Model Video
ML Refresh and Schedule Video
Admin
Best Practices & FAQs
API Documentation
Vizpad APIs
User & user groups APIs
Machine Learning APIs
Fall 2023 (4.3)
Table of Contents
- 🚀 New feature
- 📈 Enhancements
- Multi-dimensional analysis for pivot table subtotals
- Axis labeling for charts in Tellius Assistant
- Static header in Feed
- Deleting conditional formatting in tables
- Multi-sorting of pivot tables
- Customizing the display name in browser tabs
- Removal of mandatory column field in pivot tables
- Efficient publishing of datasets
- 🛠️ Minor fixes
- All Categories
- What's New
- Changelog - 4.3.3
Changelog - 4.3.3
Updated by Ramya Priya
- 🚀 New feature
- 📈 Enhancements
- Multi-dimensional analysis for pivot table subtotals
- Axis labeling for charts in Tellius Assistant
- Static header in Feed
- Deleting conditional formatting in tables
- Multi-sorting of pivot tables
- Customizing the display name in browser tabs
- Removal of mandatory column field in pivot tables
- Efficient publishing of datasets
- 🛠️ Minor fixes
The improvements and fixes implemented in 4.3.3 show our commitment to continually enhancing the user experience and functionality of our platform. Each of these updates has been carefully crafted to address specific user needs and make your interactions more efficient and intuitive.
🚀 New feature
System date reference for columns in a Business View
We've upgraded Business Views with an advanced date reference feature, offering users control over their time-based queries. Previously, when users activated the “Use the current system date” toggle, the reference point applied universally to all Business Views across the instance, which could be challenging for datasets ending in a specific year with no subsequent data. To address this, we now allow users to set the current system date for specific columns within a Business View, providing granular control over date columns.
For example, users can now apply the current system date to specific columns like “Delivered date”, while other columns retain their maximum dates as per the Business View data. This feature is particularly beneficial for executing time-bound queries, such as “Show me delivered orders in the last 3 weeks.” It ensures that your data analysis is not only more accurate but also perfectly aligned with the specific requirements of your business timelines and needs.
📈 Enhancements
Multi-dimensional analysis for pivot table subtotals
Instead of showing subtotals only at the end of a pivot table, they will now appear at each dimension level for a clearer understanding of data at various hierarchy levels. Subtotals will also be displayed in shade of grey to easily differentiate subtotals from banded rows. Moreover, subtotals can now be generated for every possible combination of row and column dimensions. This means users can see aggregated data not just for individual dimensions but also for how these dimensions interact with each other across the table.
Consider a pivot table configured with "Category", "Sub Category", and "Brand" in the row dimensions, and "Year of Sales", "Payment Type" in the column dimensions. Previously, the pivot table would display subtotals at the end of the table for:
- Each "Category"
- Each combination of "Category" + "Sub Category"
- Each combination of "Category" + "Sub Category" + "Brand"
And for column dimensions, it would show subtotals for:
- Each "Year of Sale"
- Each combination of "Year of Sale" + "Payment Type"
In addition to the above, the pivot table now also calculates and displays subtotals for more detailed combinations, such as:
- "Category" + "Year of Sale" + "Payment Type"
- "Category" + "Sub Category" + "Year of Sale" + "Payment Type"
- "Category" + "Sub Category" + "Brand" + "Year of Sale" + "Payment Type"
Now, pivot tables are capable of dissecting and displaying multi-dimensional data in an intuitive format. For instance, if you're looking to understand how different "Brands" within a "Category" and "Sub Category" perform across "Years of Sale" and "Payment Types", the pivot table can show you specific subtotals for these combinations.
Axis labeling for charts in Tellius Assistant
We've added y-axis and x-axis labels to the charts in Tellius Assistant. This improvement not only adds clarity to the visual data representation but also makes it easier for users to understand and interpret the charts more effectively.
Static header in Feed
To enhance the user experience on the Feed page, we have made the header of Feed static. Users no longer need to scroll to the top of the page to search for a required Feed, manage existing Feeds, or create a new one. This makes navigating and interacting with the feed page more convenient.
Deleting conditional formatting in tables
In Vizpads, while applying conditional formatting and setting up conditions for all types of tables (including pivot and detailed), a delete option has been included for every added condition. This enhancement allows users to effortlessly delete any required condition.
Multi-sorting of pivot tables
In Vizpads, users were able to sort only the first dimension in rows or columns of pivot tables based on the “Sort by” column. The secondary and subsequent dimensions were automatically sorted alphabetically.
Now, when totals or subtotals are enabled in Pivot Tables, all dimensions—primary, secondary, tertiary—will be sorted according to the user-defined “Sort by” column.
Customizing the display name in browser tabs
We've introduced a new customization feature that allows users to configure the title displayed on the browser tab according to their branding needs. In addition to updating the logo and color scheme, users now have the flexibility to change it to their preferred name under Settings → Application Settings → Styles. By default, the browser tab will display "Tellius".
Removal of mandatory column field in pivot tables
We have lifted the restriction that required a mandatory field in the Dimension (Column) bucket for creating a pivot table. Users can now create pivot tables with just row dimensions and measures, offering greater flexibility in table configuration.
Efficient publishing of datasets
During the “Publish” step of a Dataset, Tellius is now optimized to checkpoint transformed data only when necessary. This refinement not only improves the overall performance of the dataset publishing process but also contributes to better resource management and faster processing times.
🛠️ Minor fixes
- Resolved an issue where metadata updates were not properly flowing from the parent dataset to the single-sourced scripted dataset after transformations and refreshes.
- Addressed the audit log rotation strategy, ensuring logs now rotate daily as per the updated strategy.
- Fixed the issue where enabling “Include Nulls” in Application Settings was not reflected in search results, ensuring more accurate data retrieval.
- Resolved the issue where newly created users assigned to specific user groups (in addition to the default group) did not retain these assignments.
- In Tellius Assitant, corrected the automatic pinning of the Business View selected from suggestions, streamlining the selection process.
- In Help Tellius Learn feature of Search, the issue with updating learning for dimension values has been fixed.
- Resolved the issue with outer join not functioning in Redshift Live connections, ensuring accurate data merging operations.
- In Data module, fixed a bug where Python transformations were failing on data containing date/time columns before “1900”.
- The issue with Trend Insights when a dimension with an empty string value was chosen as a contributor has been fixed.
- Fixed format issues with market share-related queries; the term “market share” can now be specified after the metric.
- In live datasets, resolved an issue where user-applied dimension/measure preferences were overridden with default values during refresh.
- Addressed time comparison search queries that were giving the same values for both periods in case of preceding time filters, ensuring accurate temporal comparisons.
- In Notifications, the issue with updating “Indexing” background jobs has been resolved.
- Corrected a mismatch in local time and filter time in absolute/percentage change date columns, ensuring accurate time-based data analysis.
- Fixed an issue where Trend Insights and Absolute/Percentage Change aggregations were failing for calculated columns with statements including the term “case”.
- The sorting issues when using “Top N Filter” in stacked bar charts have been addressed.
- Resolved issues where “Top N Filters” with row-level policies were not reflected in Vizpad charts.
- Fixed the display issue in the Help Us Learn of Search, ensuring the correct Display Names appear for each column instead of the original column names.
- In marketshare-related search queries, addressed a problem where aggregation keywords were incorrectly recognized as column names.
- Enhanced the search functionality to reflect updates in learnings immediately after updating definitions (in Help Tellius Learn), ensuring real-time accuracy in search results.
- Fixed the issue with the display of transformation nodes in the Metadata page when switching from the Data tab.
- The issue with changes made in the Metadata page not being reflected in the Trend Analysis created from Search has been fixed.
- Corrected a live query support issue on Databricks sources where the year-week value was used instead of the actual year value, ensuring more accurate query results.
- Tellius now accurately captures and reflects the identity of the actual user making updates to the Business View, resolving the previous issue of attributing changes to the Business View owner.
- Improved permanent data storage by checking and clearing any intermediate checkpoints in the Dataset lineage (in addition to the latest published state).
- Resolved an issue in scripted datasets where the presence of missing columns required the validity of old SQL scripts, now enabling smoother data management.
- In Vizpads, resolved the issue where the dropdown control filter was not functioning when resized to its smallest dimension of 1x1.