Das Datalion Blog

DataLion Release 2025.1.181 – Streamlined Operations & Enhanced User Experience

admin

We’re pleased to announce DataLion 2025.1.181, which focuses on improving system reliability, user interface refinements, and better access controls across the platform.

🎯 Core Improvements

Chart & Display Enhancements

  • Improved Chart Sorting: Fixed sort priority logic to ensure charts display in the correct order based on your defined preferences
  • Cleaner Data Tables: Eliminated duplicate loading indicators for a smoother visual experience
  • Timeline Chart Colors: Color picker functionality restored for timeline charts, giving you full control over visualization aesthetics
  • Mean Value Calculations: Optimized calculation display for pie and donut charts

User Interface Refinements

  • Chart Title Editing: Spaces now display correctly in chart titles without URL encoding artifacts (%20)
  • Edit Permissions: Chart title editing now restricted to users with editor privileges for better content control
  • Custom Filter Editing: Enhanced ability to modify existing custom filters without recreating them
  • Modern Dialogs: Replaced legacy popup systems with native solutions for improved performance and consistency

🔐 Access & Security Updates

Guest User Support

  • Public Project Exports: Guest users can now export data from public projects, expanding accessibility for shared dashboards
  • Smart Notification Handling: System correctly identifies guest users and excludes them from internal notification workflows

User Management API

  • API-Based Deletion: User deletion now uses standardized API endpoints with proper safeguards against accidental self-deletion
  • Improved Backend Tables: Administrative tables now display all fields with horizontal scrolling for better data visibility

🔧 Technical Optimizations

Code Quality & Maintenance

  • Legacy Code Removal: Removed deprecated Google Analytics auto-importer to streamline codebase
  • Tree Labels Fix: Resolved JavaScript errors when rendering data tables with tree labels enabled
  • Codebook Script Precision: Fixed variable matching in codebook unions to prevent incorrect variable inclusion

📝 For Administrators

  • Guest exports are handled gracefully without generating unnecessary system notifications
  • User deletion operations now include confirmation steps and redirect properly after completion
  • All backend tables maintain full field visibility with scrollable interfaces when needed

This release continues our commitment to platform stability and usability improvements. These updates ensure DataLion operates more smoothly while providing better control over user permissions and data access. Thank you for your continued trust in DataLion.

DataLion Release 2025.1.180 – Enhanced User Management & Export Capabilities

admin

We’re pleased to announce DataLion 2025.1.180, which brings important user management features and strengthens export functionality across the platform.

👥 User Account Management

New Activation Controls

  • Account Activation/Deactivation: Administrators can now temporarily deactivate user accounts while preserving all settings and permissions for easy reactivation
  • Automated Notifications: Users receive email notifications when their account status changes
  • License Optimization: Deactivated accounts don’t count toward license limits, helping you manage resources efficiently
  • Safety Controls: Built-in protections ensure at least one administrator remains active

📊 Enhanced Statistical & Export Features

Expanded Testing Capabilities

  • t-Test (Repeated Measures): Now supports pairwise comparisons for more than two groups with matched cases
  • PPTX Export with Significance: Statistical significance indicators from bar and column charts now export to PowerPoint presentations
  • Complete Export Coverage: All significance information transfers seamlessly to both Excel and PowerPoint

Customization Options

  • Low Case Number Warnings: Customize warning messages for low sample sizes at the project level
  • Flexible Warning Text: Define your own messaging in Settings → Source and Case Numbers

🎨 Visual Improvements

Chart Modernization

  • Pie & Donut Charts: Upgraded to AmCharts4 framework for improved performance and visual quality
  • Better Rendering: Smoother animations and enhanced interactivity

🔧 Fixes & Optimizations

  • Export Capabilities: PDF and PNG exports working reliably across all instances
  • Codebook Settings: Settings column in online codebook view can be edited without character escaping issues
  • Chart Titles: Spaces in chart titles display correctly without URL encoding
  • Access Profiles: Buttons and controls now properly hide according to access profile settings

Improved Organization

  • Excel Codebook Export: Entries now sorted by question_id then unique_id for better readability
  • Grouped Questions: Related entries stay together for easier navigation

📝 Technical Notes

For administrators:

  • Deactivated users cannot log in and receive clear messaging about their account status
  • The „My Reports“ button can now be hidden via access profiles by disabling the „Reports“ element
  • Warning messages support both English and German with automatic language detection

This release focuses on giving administrators better control over user access while ensuring all export and visualization features work seamlessly. Thank you for your continued partnership as we enhance DataLion together.

DataLion Release 2025.1.179 – Advanced Statistical Tests & Performance Enhancements

admin

We’re excited to announce DataLion 2025.1.179, which introduces powerful new statistical testing capabilities and significant performance improvements to the platform.

📊 New Significance Metrics Suite

Enhanced Analysis Capabilities

  • t-Test (Independent Samples): Compare means between independent groups with pairwise comparisons, now available in tables, bar charts, and column charts
  • t-Test (Repeated Measures): Analyze dependent samples and compare means between variables from the same participants
  • Chi-Squared Tests in Charts: Both complement and pairwise comparison tests now display significance information directly in bar and column charts
  • Z-Test in Charts: Proportion comparisons can now be visualized with significance indicators in bar and column charts
  • Yates Correction: Added support for Yates continuity correction in Chi-squared tests for improved accuracy with small sample sizes

Excel Export Enhancements

  • Complete Significance Export: All significance information (asterisks, letters, p-values) from both tables and charts now exports to Excel
  • Preserved Formatting: Significance indicators and legends maintain their formatting in Excel exports

🚀 Performance & Functionality Improvements

Codebook Management

  • 5x Faster Upload: Codebook upload process optimized for significantly improved performance
  • Enhanced Codebook Generation Script Options: New exclude_variables, exclude_values, and question_label parameters for more flexible data combination
  • Multistack Ordering: Questions now sort by values in ascending order rather than alphabetically

Dashboard Features

  • Complete Report PDFs: PDF exports now consistently include all dashboards within a report, not just the current view
  • Default Dropdown by Text: Set default dropdown filters in the codebook settings using text values instead of unique IDs with default_dropdown_text
  • Formula Textboxes: Fixed saving of textboxes containing SQL formulas like {{=AVG(variable)}}

🔧 Bug Fixes & Reliability

Optimized Functionality

  • Target Groups: Creation and editing of target groups optimized
  • Dashboard Filters: Dropdown filter functionality optimized
  • User Registration: New tenant registrations optimized
  • Stacked Charts: Excel codebook uploads maintain proper chart structure

Technical Improvements

  • Label Updates: Optimized performance for faster processing
  • Unique IDs: New questions created in online codebook view receive proper unique identifiers

This release strengthens DataLion’s analytical capabilities while improving overall system performance and reliability. We appreciate your continued feedback as you explore these new features.

DataLion Release 2025.1.178 – User Management Optimized & Dashboard Improvements

admin

We’re releasing DataLion 2025.1.178, which fixes several user management issues and improves dashboard functionality.

👥 User Management Fixes

Admin Backend Working Again

  • User Creation: Fixed the error that sometimes prevented creating new users
  • User Search: Search functionality in the user list works properly now
  • Sorting & Navigation: You can sort user lists and navigate between pages without errors
  • Billing Calculations: User count tracking in Billing & Account now shows correct numbers for historical months

📊 Dashboard & Export Updates

PDF Export Improvements

  • Dynamic Dashboards: PDFs now include all charts from dynamically-loaded dashboards, not just the visible ones
  • Scroll-Based Loading: Dashboards set to „Load dynamically when scrolling into view“ export completely

Filter Functionality

  • Multiple Default Values: Dashboard dropdown filters support multiple defaults again, both through the UI and JSON editing
  • Static Global Filters: These are now recognized as changes immediately, update the URL automatically, and can be saved right away

🔗 Additional Fixes

Service Links

  • Links to dashboards maintain all parameters and settings instead of redirecting to the project start page

Stacked Charts

  • Decimal precision settings now apply correctly to mean values, following project or chart-specific settings

📝 Technical Details

For those working with dashboard filters:

  • Multiple filter defaults: "default":"2|3|4" (pipe separator for OR logic)
  • Benchmark filters: "default":"2,3,4" (comma-separated)

This release focuses on fixing broken functionality and improving reliability. Thanks for your patience while we addressed these issues.

DataLion Release 2025.1.177 – Enhanced Configuration Options and Export Performance

admin

We’re excited to announce the latest DataLion release, featuring critical fixes and improvements that strengthen report configuration capabilities and export functionality.

🎯 Configuration & Settings Improvements

Report-Level Configuration Control

  • PPTX Export Settings: Report-level PPTX configurations now properly override project-level settings, giving you granular control over individual report exports
  • JSON Validation Fix: The JSON validator now correctly recognizes valid reset button and datepicker configurations, eliminating false validation errors that prevented saving report settings

Enhanced Filter Management

  • Cross-Source Variable Filtering: Open text charts can now be filtered using variables from different joined data sources via dashboard filters
  • Custom Filter Reliability: Improved stability when editing existing custom filters (target groups) through the dashboard interface

🌍 Localization & User Experience

  • German Date Picker: Quick selection options in the date picker are now properly translated to German
  • Complete Translation Coverage: Chart type names in selection menus now display in the correct language

📊 Export Enhancements

Cleaner Excel Exports

  • Machine-Readable Excel Format: Removed empty rows that previously appeared after stacked column/bar charts in machine-readable Excel exports

Improved File Handling

  • Special Character Support: Forward slashes (/) in project, report, dashboard, or chart titles are now automatically escaped to ensure successful exports

🔧 Infrastructure & Reliability

Email Delivery Upgrade

  • Mailgun Integration: Switched email delivery to Mailgun (EU-hosted) for improved reliability and deliverability of system notifications

Project Management

  • Complete Project Copying: When copying projects, all reports, dashboards, charts, and textboxes are now properly duplicated to the new project

Backend Optimizations

  • User Access Framework: Optimized user roles and access profiles in preparation for license-based restrictions
  • Session Management: Improved login and session handling for better stability

This release continues our commitment to improving DataLion’s reliability and usability. We appreciate your feedback as you explore these enhancements.

DataLion Release 2025.1.176 – UI Refinements and Error Handling Improvements

admin

We’re excited to announce the latest DataLion release, featuring important improvements to enhance your data analysis experience and workflow efficiency.

✨ UI Enhancements

  • Advanced Date Selection: Upgraded date picker now allows year selection via dropdown for faster navigation between years
  • Improved Text Formatting: Row and cell borders/border styles are now properly visible in textboxes
  • Optimized Translation Handling: All system text and error messages are now localized

🪲 Bug Fixes

  • Filter Functionality: Dropdown filter type „filter“ in the report settings editor now works correctly, you no longer have to leave this empty to get a regular filter dropdown
  • Timeline Chart Accuracy: Fixed issue where using 2+ filters in timeline charts showed incorrect case numbers in the footer
  • Timeline Filter Stability: Timeline filters with a different base calculated by SQL formula and hidden graphs no longer throw errors

🤦‍♀️ Improved Error Handling

  • Optimized PPTX export error handling for more reliable document generation
  • Missing query variables in timelines now properly handled
  • Incorrect JSON dropdown definitions no longer cause broken report editors

This release continues our commitment to improving DataLion’s performance and usability. We appreciate your feedback as you explore these enhancements.

DataLion Release 2025.1.175 – Performance Optimizations and Export Enhancements

admin

We’re excited to announce the latest DataLion release, featuring important improvements to enhance your data analysis experience and workflow efficiency.

🛠️ Improvements & Fixes

Export Enhancements

  • Streamlined PDF Dashboard Export: PDF exports now exclude navigation elements, creating cleaner and more focused documents for sharing
  • Tables as Combined Charts: Fixed functionality for tables displayed as separate combined charts in a single widget

Performance Optimizations

  • Report & Tab Handling: Implemented backend improvements for more robust and performant report/tab management (no visible changes, but you may notice the difference in performance and stability)
  • Database Query Optimization: Enhanced data queries for faster database performance, reducing wait times for complex analyses

Technical Improvements

  • CSV Import Enhancement: Now automatically removes Windows line breaks on CSV import for more consistent data processing (before, when the optional „remove windows line break“ was unchecked, the last column of your data may have problems in queries)

This release continues our commitment to improving DataLion’s performance and usability. We appreciate your feedback as you explore these enhancements.

DataLion Release 2025.1.174 – Enhanced Project Collaboration and Improved Export Features

admin

We’re excited to announce the new DataLion release, packed with efficiency improvements and bug fixes to enhance your data analysis workflow.

🎯 New Features

Advanced Project Management

  • Cross-Project Report Copy: You can now copy reports between projects, making it easier to reuse your reports and dashboard across multiple analyses
  • Codebook Copy: Streamlined workflow with the ability to copy Codebooks between projects

🛠️ Improvements & Fixes

Enhanced Export Functionality

  • Data Source Downloads: Fixed issue with unfiltered data downloads
  • Excel Export With Rotated Axes: Empty rows hidden in charts charts with rotated axes are now also hidden in Excel exports, maintaining visual consistency
  • Advanced Statistics Excel Export: Now also works seamlessly without setting a regression type and using the default

User Interface Enhancements

  • My Reports Menu Optimization: Menu now displays up to 80 characters and opens to the left to prevent cut-off text at right screen border
  • Complete Codebook Visibility: Fixed display issue ensuring all codebook columns remain visible without right-side truncation
  • PowerPoint Integration: Improved default behavior when no slide is selected in report settings – now uses the first master slide with placeholders. If there is none, it is creating a new placeholder on the first slide

Technical Improvements

  • CSV Import: Now correctly handles wrongly encoded HTML special characters and properly escapes quotation marks on Exasol
  • Base Index Calculation: Fixed rounding error
  • Data Source Management: Resolved several backend issues for smoother operation

This release reflects our ongoing commitment to improving your data analysis experience with DataLion. As always, we welcome your feedback as you explore these new features.

DataLion Release 2025.1.173 – New Price Sensitivity Chart, Enhanced Tables, and Improved Maintenance Experience

admin

We’re excited to announce the new DataLion release, packed with features and improvements to help you create more insightful and effective data visualizations.

🎯 New Features

New Chart Type

  • Price Sensitivity Chart (Westendorp Method): We’ve added a powerful new visualization type that helps you understand optimal pricing points based on the Westendorp methodology. Perfect for product teams looking to make data-driven pricing decisions.
  • „Back to Start Page“ Button: When a project is under maintenance, users can now easily navigate back to the start page with a single click, improving the overall user experience during updates.

🛠️ Improvements & Fixes

Enhanced Table Functionality

  • Tables with merged questions and top boxes now display the question title for better context
  • Crosstab functionalities have been extended to work seamlessly with tables containing subheadings
  • Improved readability and usability across all table types

Technical Improvements

  • Statistical Accuracy: Grand totals in crosstabs for row and cell percentages now correctly show 100%
  • Filter Consistency: Tables with Top2 filters now display accurate values for the base column
  • Backend Management: It’s now possible to delete individual items in the project backend
  • Codebook Generator: The system now correctly identifies nominal variables, ensuring proper data classification

Version 2025.1.172 Released – Synthetic Data, AI Themes and New Maintenance Mode

Caro

New Features

  • DD-4612 Project-specific maintenance mode implemented (editors and/or viewers see a maintenance notification instead of accessing the project)
  • DD-4788 It is now possible to generate synthetic data with AI (in the project backend under codebook)
  • DD-4789 Themes and color schemes can be created with AI (in the project backend under content)
  • DD-4790 Color schemes can be defined on project level (in the project backend under content)

Bugfixes and Improvements

  • DD-4784 Sharing report links on app instance works reliably
  • DD-4787 Report editor: design improvement of checkbox and button placement
  • DD-4791 PDF exports work for all server types
  • DD-4793 Sorting in polarity charts now also works with hidden categories
  • DD-4794 Textbox content is not cached
  • DD-4795 Edit symbol in the navbar works reliably again