Release notes

SEDGE 8.0 Release notes

Version 8.5.0 - 3 Jan 2025

New Features & Enhancements

1. DashPro

   • Redesigned the projects landing page for improved usability and interface (SED-223).

     1. Added card views for different projects to facilitate selection.

     2. Provided an option to mark any of the listed projects as a favorite.

     3. Displayed recent, favorite, and all projects with three different grid views below the cards.

2. Security Fix

   • Updated the password encryption method for enhanced security (SED-1394).

   • Updated the software for select2 dropdown options to address vulnerabilities (SED-584).

3. Organized the code into smaller, function-based files for better maintainability and readability (SED-1159).

4. Optimized frontend processes in the OCR module to improve performance and speed (SED-214).

Bug Fixes

1. DashPro

   • Chart Functionalities

     1. Updated the default aggregation to ‘Count’ for all categorical columns and ‘Sum’ for all numerical columns in the Axis dropdown of all charts (SED-1410).

     2. Fixed dataset name showing as null when uploading a new dataset (SED-1391).

     3. Fixed to display “Top” by default in the “Show result - Limit” option (SED-1365).

     4. Updated the Tab and Global Filter options to checkboxes and ensured they are disabled upon clicking (SED-1341).

     5. Updated the functionality to prevent tabs from being deleted by default when all widgets in the tab are removed (SED-1340).

     6. Resolved to display deviation in the published dashboards (SED-1333).

     7. Updated to ensure only renamed factors are displayed in the filter options (SED-357).

     8. Resolved to add the selected columns to the formula list in the Card chart (SED-1311).

     9. Fixed the issue where columns could not be removed from Axis, Category, and Groups (SED-1310).

     10. Resolved the issue where the edited column header reverted to the old one, ensuring it resets only upon user selection (SED-1297).

     11. Updated the last N month calculation for Date filter queries (SED-896).

     12. Updated sorting function to allow same columns provided for X and Y axes in the Waterfall chart (SED-1163).

     13. Resolved duplicate validations appearing for Multiple Axis during column selection and application (SED-1342).

     14. Addressed the following issues in conditional formatting (SED-952, SED-1286):

         1. Resolved the issue to appropriately display the icons in the dropdown.

         2. Corrected the code to retain input values provided while editing a rule.

         3. Included Text data type support for Conditional Formatting

     15. Addressed the following issues in Sparkline (SED-153)

         1. Ensured the toggle is not disabled while editing the chart.

         2. Corrected the code to include 100 as the period value.

         3. Resolved issues with Separator and Roundoff.

     16. Bar and Column Charts:

         1. Corrected to display values in the Bar with Line chart when the same column is selected for the Y-Axis and Series, with different aggregations (SED-1406).

         2. Adjusted the display in grouped and sorted charts (SED-1399).

         3. Adjusted X-scroll to place the values and bullets appropriately in Bar with line/ scatter (SED-460).

         4. Updated the missing aggregate indication in the tooltip for the Y-Axis in the Stacked Column Chart (SED-1362).

         5. Disabled “Start axis at 0” for charts with negative values in Bar with line/ scatter (SED-1200).

         6. Resolved the issue to prevent labels from overlapping in grouped and sorted charts (SED-219).

         7. Enabled the start with axis 0 by default for the following charts (SED-1356, SED-1418):

            1. Bar

            2. Stacked Bar

            3. Grouped Bar

            4. Column

            5. Stacked Column

            6. Grouped Column

            7. Layered Column

            8. Bar with line/scatter

            9. Grouped & Sorted

            10. Combination Chart

            11. Dumbbell Chart

     17. Tabular Charts:

         1. Fixed the issue with incorrect aggregation and count display when the same field is added to the values and column labels of the Pivot Chart (SED-1402).

         2. Corrected the display of the grand total field to appear only once, in the pivot (SED-1366).

         3. Fixed conditional formatting and icon alignment issues in the Table Widget (SED-1301).

         4. Addressed sorting issues in AG grids across Table, Pivot, KPI Card, and SparkLine (SED-1330).

         5. Fixed the issue where all columns were plotted in the pivot after removing a row group (SED-1225).

         6. Corrected the Wrap Headers functionality and ensured that the column order and column size settings are retained in the Pivot Chart while navigating to another page (SED-1315).

         7. Resolved the issue where data was not displaying in Pivot when removing columns and then adding them again (SED-1128).

         8. Corrected the issue where Categories were replaced with Groups after performing a custom pivot (SED-1346).

         9. Prevented columns from being removed from the table when dragged towards the edge (SED-1282).

         10. Updated to quickly retrieve data for the Pivot table widgets in the Published Dashboard (SED-1239).

         11. Added Count, Distinct, First, and Last as possible aggregation options for non-numerical columns in the Pivot Chart. (SED-1465)

         12. Addressed the log errors in the Pivot Chart that occurred when multiple row groups were added and removed while keeping value groups intact. (SED-1127)

         13. Fixed the log error on row groups expansion with column totals and value-wise totals enabled. (SED-1464)

   • Chart Alignments and Formats

     1. Updated the X-label position by default to Center for every new chart (SED-1187).

     2. Resolved chart alignment issues when refreshing or navigating to another page (SED-1321).

     3. Adjusted the space to align charts appropriately (SED-662).

     4. Prevented overlapping and unintended chart deletions when global filters are applied (SED-183).

     5. Fixed the issue where charts in a tab were also deleted when another tab was published and then deleted from the Published dashboard and ‘My Chart’ (SED-1193).

     6. Ensured the Separator and rounding-off settings remain intact for numerical columns when applying conditional formatting in the table (SED-1283).

     7. Disabled BigNumber suffix and Separator while value format is selected as percentage (SED-157).

     8. Added tooltips for sort options in the chart widget (SED-1198).

     9. Updated to reset the trendline toggle for every new chart when it was enabled for the previous scatter plot (SED-1197).

     10. Updated the functionality to remove decimals while enabling the separator (SED-1161).

     11. Removed bold formatting from the “Sort By” and “Sort Type” text fields (SED-972).

     12. Corrected the “Start axis at 0” functionality in grouped and sorted charts (SED-967).

     13. Added validation checks for the period field in the Sparkline widget (SED-332).

     14. Displayed the enable value correctly when the legend is disabled and enabled again in Stacked Bar charts (SED-296).

     15. Updated code to synchronize axis values in Bar with Line and Combination Chart (SED-1292).

     16. Updated to export all the charts in the file to PDF (SED-1350).

     17. Fixed the issue where the Font Family and Font Size were not being applied to the chart title (SED-1338).

     18. Corrected the sorting functionality when performing binning on the same column (SED-1250).

   • Resolved log errors that occurred while rendering charts in dashboards. (SED-1421, SED-1092, SED-1090, SED-1240)

2. Statistics

   • Updated to display column names in the filter function (SED-1430).

   • Corrected the scrollbar and preview grid display for the new transformations applied. Also added a loader to view the statistics section upon clicking categorical or date columns (SED-1251).

   • Disabled the loader once the chart rendering in GraphStat is completed (SED-1249).

   • Corrected issues with top functions, including binning and substrings (SED-1218).

   • Enabled footer icons when navigating to the Statistics and DashPro pages (SED-1332).

   • Added a missing loader during transformation on the Statistics Page (SED-1386).

   • Updated code to fix the empty transformation and preview tab on the Statistics page (SED-1334).

   • Addressed the following issues while performing a filter on the Statistics page (SED-1168):

     1. Updated to stop the loader upon clicking the delete option.

     2. Included the equal option for the date column.

   • Updated the validation message display for ignored columns, ensuring it persists until the user interacts elsewhere. (SED-1444)

3. Addressed the following issues in CSV refresh (SED-1207, SED-1307, SED-1440):

   • Corrected the functionality to reflect new data and its information appropriately after a CSV refresh.

   • Resolved the issue to ensure columns with values after the update are not ignored, even if they had 100% missing values before the update.

   • Updated to display the appropriate status while refreshing the CSV file.

4. Projects Page

   • Corrected the CSV download functionality in the Projects page (SED-1433, SED-1345).

   • Highlighted the selected project name in the Projects page (SED-1417).

   • Updated the file-sharing API to successfully share projects (SED-1351).

   • Updated to refresh and display the new list when a file is deleted (SED-1349).

   • Corrected the list to show only recent projects under the ‘Recent’ tab instead of ‘Favorites’ or ‘All’ after marking a project as a favorite (SED-1354).

   • Updated to display only the related projects in the Time Series view (SED-1353).

5. Error Handling

   • Fixed the validation error when navigating to the published dashboard from the Home page (SED-1318).

   • Updated to stop the loader in case of failure and display validation errors on the profiling page (SED-1327).

   • Enabled the SQL Editor and Upload Icon to remain active even after encountering a validation error while uploading a zip file (SED-1326).

   • Corrected the log error that occurred while selecting the date column (SED-1422).

   • Resolved Container log errors while performing string functions - Replace Range, Delete Range, Insert, Pop, Cat->Num (SED-1431).

   • Corrected validation errors when converting a text column to a category (SED-1428).

   • Resolved the error that occurred in binning after providing the required number of intervals (SED-1364).

   • Resolved the value error that occurred while performing Pivot Analysis (SED-804).

6. Miscellaneous

   • Corrected to display the appropriate column names upon expanding the unique details tab in the Sampling page (SED-1427).

   • Resolved to reset the logged-in username when switching accounts (SED-1367).

   • Restricted the update of timestamps to the specific project being refreshed (SED-1416).

   • Added the missing “Load new version” popup in the development environment (SED-1404).

   • Updated to restrict the “Access Location” popup when signing out (SED-1347).

   • Corrected to not remove newly created columns after refreshing the data (SED-1220).

   • Fixed to generate queries in the SQL editor when clicking on the table for an uploaded CSV file (SED-1320).

   • Resolved the issue to display the updated file name in the footer (SED-1191).

   • Adjusted the display of the logout popup to prevent the occurrence of a scrollbar in SEDGE. (SED-1434)

   • Updated to display percentage values for data labels in the Sampling page, for any selected column. (SED-1438)

   • Corrected the refresh functionality of the Jira API connection when there is no primary key column selected. (SED-1323)

   • Updated the functionality to enable the refresh icon after completing the refresh process (SED-1246).

Version 8.4.2 (Hotfix) - 13 Dec 2024

Bug Fixes

1. DashPro

   • Corrected the display of icons for positive growth in KPI cards (SED-1298)

   • Updated functionality for separators and rounding off in the following charts: (SED-1384, SED-153)

     1. KPI Card

     2. Sparklines

2. Resolved log errors encountered when connecting to the Jira API (SED-1325)

Version 8.4.2 - 10 Dec 2024

New Features & Enhancements

1. DashPro

   • Implemented a combination chart integrating a line chart, scatter plot and symbols with dual axis capabilities (SED-170, SED-1153)

Bug Fixes

1. DashPro

   • Corrected the functionality of the “Apply” button after enabling the tab filter (SED-1361)

   • Updated to display the correct aggregation value for the Stats line in Stacked Column and Bar charts (SED-1184)

   • Updated to refresh charts based on the applied tab filter (SED-1302)

   • Updated to round off column totals in Pivot charts (SED-1352)

   • Addressed issues in Tabular Charts: (SED-1146, SED-1149)

     1. Table & Pivot: Enabled separators and rounding off of values while selecting columns

     2. Table: Fixed header color reset upon enabling “Wrap headers”.

     3. Table: Updated the default highlight color for both column and row totals.

     4. Table & Custom Pivot: Updated to highlight negative values appropriately.

     5. Pivot: Fixed the display of the grand total field when enabling column totals.

   • Updated to prevent displaying more than 5 decimals in row and column totals of Pivot charts (SED-1132)

2. Resolved CSV file refresh failure (SED-1206)

3. Corrected the CSV upload process and ensured proper query generation upon clicking the table name in MySQL Editor (SED-1177)

4. Updated the code to rename factors of categorical columns on the Statistics page (SED-1214)

5. Resolved log errors occurring when navigating to the Profiling page (SED-1293)

Version 8.4.1 - 12 Nov 2024

New features & Enhancements

1. DashPro

   • Enabled sort feature in Waterfall Chart (SED-954, SED-953)

   • Enhanced color themes for better contrast between adjacent colors (SED-912)

   • Improved enable value label display to prevent overlap after rotation (SED-288)

   • Displayed data source info in the Pipeline console (SED-53)

   • Upgraded deprecated Angular packages version for improved build stability (SED-1001)

2. OCR

   • Improved support for processing PDFs across multiple tabs simultaneously (SED-1009)

Bug fixes

1. DashPro

   • Prevented log error display when adding new transformed columns in charts (SED-1155)

   • Adjusted Widget accordion to fit available space (SED-1008)

   • Improved scroll functionality in Chart/Table formats (SED-901)

   • Bar-with-Line/Scatter charts: Fixed alignment and color code retention (SED-906)

   • Enabled special characters in Sparkline column headers (SED-905)

   • Displayed growth icons on the right side of text in Sparkline (SED-816)

   • Improved numerical alignment in AG-Grid Charts and highlighted negative values (SED-830)

   • Refined spacing in Pivot table during PDF export (SED-1130)

2. Statistics

   • Data type icons now display correctly in filter page (SED-1118)

   • Corrected errors in delete and flag date range selections (SED-994)

3. Data Upload

   • Prevented empty dataset processing in Profiling (SED-919)

   • Stored date columns correctly upon project data download as CSV (SED-918)

   • Enabled zip uploads with multiple CSVs (SED-1119)

   • Reflected dataset name changes in Dashpro, Pipeline, and Footer (SED-909)

   • Reset inputs for new JIRA API connections (SED-1095)

4. JIRA API Connection

   • Fixed errors while fetching data (SED-159)

     1. Displayed only selected fields.

     2. Provided detailed error message for failed connections due to invalid server URLs.

     3. Restricted duplicate connection names

Version 8.4.0 - 12 Nov 2024

New features & Enhancements

1. DashPro

   • Enabled trendline in Scatter Plot with degree and confidence interval options (SED-1070)

   • Added efficient data handling in Table and Pivot Widgets using AG Grid’s SSRM (SED-1096, SED-1041)

   • Grouping function for single categorical columns on Y-axis (SED-1015)

     1. Grouped Bar

     2. Grouped Column

     3. Line

     4. Area

   • Included blank factors in visualizations (SED-301, SED-140)

   • Optimized load time in Table/Pivot Widgets (SED-238)

   • Auto Scroll enabled in Gantt Chart by default (SED-1063)

   • Added sorting options in Grouped and Sorted Chart (SED-121, SED-119)

2. Application Security

   • Fixed Missing Subresource Integrity for External Resource (SED-585)

3. User Interface and Usability

   • SQL Editor: Improved grid display with filter and search options for Organization Hierarchy (SED-553)

   • Query History: Added wrap text option in query history (SED-610)

4. File Refresh

   • New refresh status card UI during file refresh (SED-1073)

5. Jira API Enhancements

   • Optimized Jira fetching API with JiraOne Library (SED-1011 & SED-718)

   • Restricted Jira API connections to a maximum of 10 (SED-558)

   • Improved UI for Project and Input Fields in API Connection (SED-695)

Bug fixes

1. DashPro

   • Displayed default values for Confidence and Degree in Scatter Plot (SED-1094)

   • Fixed visibility of columns with 100% missing values (SED-1061)

   • Adjusted legends in Zoomable Bubble chart for visibility (SED-948)

   • Date format updated in tabular charts to exclude milliseconds (SED-174)

   • Tooltip now displays refresh status correctly (SED-1104)

   • Enhanced validation messages across various chart types (SED-1034, SED-999, SED-1062)

   • Optimized retrieval time for saved charts (SED-145)

   • Addressed validation and error messagess

2. OCR

   • Stopped loader if non-image/PDF file is uploaded (SED-1010)

3. Statistics

   • Addressed validation and input errors across statistical operations (SED-994)

4. Data Upload & File Refresh

   • Corrected refresh icon behavior (SED-1038)

   • Updated tooltip to show refresh status (SED-1104)

   • Corrected validation for JIRA API connections (SED-1098, SED-1076)

   • Avoided duplicate connection names across multiple connections (SED-1123)

5. UI and General Enhancements

   • GDPR Compliance: Resolved UI error when performing ignore or pseudonymize actions (SED-776)

   • Account Expiration Page: Removed timestamp from Expiry Date column (SED-295)

Version 8.3.0 - 26 Sep 2024

New features & Enhancements

1. Streamlined data export in Project page (SED-754)

   • Enabled quick downloads directly to the disk without impacting browser performance

2. Enhanced UI for refresh functionality (SED-955)

   • Introduced a new UI screen for refresh operation without restricting user navigation

   • Added a new card to show the refresh status of files, indicating states such as waiting, in progress and completed

   • Included validation measures to restrict users from executing parallel operations

3. User-based access control

   • Implemented user-based access control for the DashPro, Preview & Statistics modules allowing access to be assigned based on their roles (SED-536)

4. Improved query display in SQL editor

   • Updated the queries in the command history to display the most recent entries at the top, allowing users to quickly refer their most recent action (SED-39)

5. Query editing in Pipeline

   • Introduced the ability to edit queries directly within the pipeline, to modify existing queries eliminating the need for recreating queries (SED-52)

6. Simplified target selection in Profiling

   • Added a feature that allows for default target selection, making it easier to initiate tasks without manual input (SED-560)

7. Wrap text feature

   • Introduced text wrapping capability in the pipeline (Project page) and expression history sections (Statistics), for easier viewing of longer entries without horizontal scrollbars (SED-278)

8. Improvised data protection

   • Added an option to ignore or pseudonymize data upon right-clicking on specific variable (SED-220)

9. DashPro

   • Introduced conditional formatting in the table widget to improve data visualization (SED-704)

   • Enables users to dynamically format cells based on colours and formatting options includes color-coding, threshold based formatting & customizable rules

   • Added legend position in zoomable bubble (SED-535)

Bug fixes

1. User quick actions

   • Enabled ‘Reset’ option for filtered fields in User Group (SED-616)

   • Resolved data display issue between companies in User Group (SED-963)

   • Eliminated redundant fields in User Overview upon refreshing (SED-894)

2. Profiling & Statistical bug fixes

   • Fixed issues related to renaming files with similar names (SED-120)

   • Corrected issue on displaying the filename in the footer (SED-973) , (SED-908) , (SED-130)

   • Corrected issue with ‘Change number of bins’ in Graphstat (SED-401)

   • Resolved displaying of session expired pop-up appeared during ongoing action (SED-531)

3. DashPro bug fixes

   • Fixes on published dashboard (SED-981)

   • Resolved issue on edit query functionalities (SED-979)

   • Fixed problem with the display of selected columns on performing Table (SED-532)

   • Resolved chart retrieval issues for the following chart types (SED-968) , (SED-926)

     1. Pivot

     2. Gantt

     3. Timeline

4. Maintained the sorting order during the chart-building process (SED-617)

5. Improved validation protocols in charts (SED-839)

6. Data refresh (DB & CSV) bug fixes (SED-965)

7. Visual improvements

   • Flicker free input handling in DashPro charts (SED-917)

   • Improved tab rendering upon navigation (SED-213)

   • Text wrapping in pipeline & expression history views (SED-762)

   • Restored delete button visibility in Project page and DB connection (SED-834)

   • Resolved missing of grid lines for fresh uploads (SED-18)

   • Corrected visibility of details icon in GDPR (SED-990)

Version 8.2.0 - 27 Aug 2024

New features & Enhancements

1. DashPro

   • Implemented sorting feature for grouped and sorted data (SED-121)

   • Added enable value position in grouped and sorted views (SED-84)

2. UI updates

   • Included version number display across all UI screens (SED-92)

3. API integration

   • Developed API connection for establishing connections with various APIs (SED-82)

4. Database connection

   • Updated ‘existing connection’ as the default display if a connection is already established (SED-42)

5. File management

   • Enabled the ability to rename project files (SED-41)

6. Performance improvement

   • Enhanced server efficiency by eliminating redundant API calls on the Profiling page, reducing unnecessary server load (SED-212)

Bug fixes

1. SQL editor bug fixes

   • Resolved issues causing invalid syntax or input errors when executing queries (SED-102)

2. Statistical bug fixes

   • Fixed broken icon display issue within Transformation function (SED-196)

   • Fixed statistics page hanging on “loading” during navigation (SED-37)

3. Data refresh (DB & CSV) bug fixes

   • Data refresh Fixes on refresh status for refreshed and non-refreshed files (SED-266)

4. DashPro bug fixes

   • Resolved issues to display appropriate results on filtering the data (SED-211), (SED-29)

   • Eliminated irrelevant validation errors triggered by actions in the Table widget (SED-204)

   • Fixes on sorting feature (SED-181)

   • Added appropriate validation checks in the Dumbbell plot for instances of identical inputs (SED-172)

   • Added timestamp display feature in Gantt chart (SED-34)

   • Corrected filter icon disappearance in DashPro Table and Pivot upon resetting global filter (SED-32)

   • Resolved styling inconsistencies during page transitions (SED-5)

   • Fixes on cross scripting (SED-182), (SED-217)

Version 8.1.0 - 26 July 2024

Performance Improvement

1. Improved DashPro Performance: DashPro now leverages Polars for data handling, resulting in significantly faster data processing compared to Pandas.

Bug fixes

1. JIRA API Connection - Resolved the issue with factor retrieval in the “Key” variable.

2. Application - Fixed issues with the User quick action.

3. DashPro bug fixes

   • Added appropriate validation for identical column selection in Candlestick chart

   • Fixed sorting options for building charts

   • Resolved chart building errors for the following chart types

     1. Stacked Bar

     2. Grouped Bar

     3. Line

     4. Circos

     5. Network

     6. Map with Bubble

Version 8.0.2 - 18 July 2024

Improvements & fixes

1. Enhanced stability by resolving multiple underlying issues.

2. Improved user interface through several bug corrections.

Version 8.0.1 - 10 July 2024

Improvements & Enhancements

1. jQuery

   • Previous version: 3.1.1

   • Updated version: 3.7

   • Benefits: This upgrade introduces performance enhancements, increased compatibility with modern web practices, ensuring a smoother and safer user experience.

2. Bootstrap

   • Previous version: 3.3.7

   • Updated version: 5.3.3

   • Benefits: Transitioning to Bootstrap 5.3.3 brings numerous new features, such as more modular approach, enhanced grid system, updated form controls, and removal of jQuery dependencies, which altogether offer a more streamlined and modern UI framework.

3. Gridstack

   • Previous version: 0.6.3

   • Updated version: 9.1.1

   • Benefits: Upgrading to gridstack.js 9.1.1 provides better performance, new features for dynamic grid management, and an overall improved user experience when dealing with grid layouts.

Note

Due to breaking changes in pixel units in the gridstack upgrade from version 0.6.3 to 9.1.1, users may need to manually adjust the dimensions and positions of existing widgets for proper alignment.

Bug fixes

1. Application bug fixes

   • JIRA API connection

     1. Connection management: Enabled saving of the connection with a specified connection name

     2. JIRA connection validation: Implemented appropriate validation messages to be displayed when the connection to JIRA fails

     3. Highlight ‘Select all’ option: Adjusted the behavior to highlight the ‘Select All’ option based on the project or field selection

     4. Clear connection details: Enabled the reset button to clear all connection information, facilitating a complete refresh of connection details

     5. Improved Column Resizing: Corrected the issue with column expansion upon selection, enhancing data display and interaction

   • Corrected errors when retrieving username & resetting passwords

   • Resolved the issue preventing updates to user information fields, including Status, Plan, Company Name, Expiry Date, Is Admin User, Is Superuser, and User Group

   • Updated the quick actions interface to display appropriate count of selected checkboxes

   • Fixes on file collaboration

2. Profiling bug fixes

   • Added Sorting functionality in feature tab

3. Statistical bug fixes

   • Improved the date format display in Graphstat when selecting date variable to visualise the results

   • Refined the spinner functionality to deactivate upon the completion of chart loading in Graphstat

   • Resolved the issue of non-functional search in the data table by initialising GridReady component in advanced statistics

   • Implemented a check to halt function execution when no column is selected

   • Corrected the alignment of column headers in the Preview feature when accessed from graphstat/transformation

4. DashPro bug fixes

   • Percentage visibility: Rectified the absence of percentage values in stacked bar and stacked column charts with the “Enable Value as a Bar %”

   • Deviation display - Addressed the problem of “undefined” appearing in the Deviation field when using separators

Version 8.0.0 - 19 Jun 2024

New features & Enhancements

1. Technology Stack Upgrades

   • Backend Upgrades

     1. Python 3.12: Upgraded to the latest version to enhance performance, security, and compatibility with new libraries

     2. MySQL 8: Transitioned to version 8 for improved database performance, better indexing, and advanced features such as JSON support

     3. Apache Spark 3.5.1: Updated to ensure better data processing speed and efficiency in big data operations

     4. Hadoop File System 3.4.0: Implemented the latest version for improved scalability and reliability in handling large datasets

     5. Package Updates: All backend packages are updated to their latest compatible versions to ensure better performance, security, and functionality

   • Frontend Upgrades

     1. Angular 12: Upgraded to leverage the latest features, performance enhancements, and improved development experience

     2. Package Updates: All frontend packages are updated to their latest compatible versions to ensure better performance, security, and functionality

These upgrades collectively enhance the overall performance, security, and maintainability of our SEDGE application, providing a more robust and efficient user experience

2. Accessibility

   • Implemented data source integration into JIRA to optimize workflows, enhance issue tracking capabilities, and promote collaboration across teams

3. DashPro

   • Enhanced the Grouped and sorted chart by improving category-based grouping (Multiple grouping) for the selected variables

   • Improved the percentage display in Stacked Bar & Column charts to accurately represent values up to 100%

   • Provided an option for aligning individual columns (Right, Left, and Center) in AG-Grid charts

Bug fixes

1. Profiling bug fixes

   • Streamlined database connection setup by eliminating undesired API calls

2. DashPro bug fixes

   • Fixes on Sorting functionality in Bar & column charts

   • Rectified issues with tooltip display in Candlestick

   • Updated the validation message in the ‘Card’ chart when no data is available

   • Adjusted positioning to accurately reflect data in Summary chart

   • Improvements in functionalities

     1. Deviation in Multiple axis

     2. Round off

     3. Separator

   • Fixes on filter panel visibility upon tab deletion

SEDGE 7.0 Release notes

Version 7.8.1 - 03 Apr 2024

New features & Enhancements

1. DashPro

   • Enhanced the ability to visualize deviations for each factor within a specified group directly within the User Interface (UI).

   • Improved numeric summation with ‘sum’ as the default aggregation for numerical variables

   • Introduced unique aggregation functionality to each column type: Categorical, Date, and Numerical

Bug fixes

1. Statistical bug fixes

   • Top function - Resolved issues with Binning function

2. DashPro bug fixes

   • Improved alignment for AG grid charts

     1. Pivot

     2. KPI

     3. Custom Pivot

     4. Sparkline

     5. Summary

   • Implemented fixes for rounding off and separator function in Custom Pivot & Table

   • Corrected issues with 100% scale feature in chart formatting options during chart edits

   • Resolved issue with Stats line for Charts with Multiple selection fields

   • Rectified the absence of customizable elements (Axes, Axis Title, Chart Title, and Chart Format) during filtering actions

   • Chart retrievals in My charts & Published Dashboard

3. Optical Character Recognition (OCR)

   • Resolved execution errors during file processing

Version 7.8.0 - 13 Mar 2024

New features & Enhancements

1. DashPro

   • Introducing two new chart types with the standard customization options

     1. Donut

     2. Semi-circle

   • Implemented Tab-wise filter functionality

     1. Ability to filter data within specific tabs in the dashboard

     2. Developed color coded system to differentiate between the active and non-active filters

        • Local Filter (Green): Applied filters that affect only the current widget

        • Global Filter (Red): Filters that impact the entire dashboard

        • Tab-Wise Filter (Blue): Applied filters that affect the charts within specific tab

   • Enhanced an option to select the percentage of ‘Enable values’ for various chart types

     1. Bar & Column charts

     2. Line

     3. Area

     4. Multiple axis

     5. Grouped & sorted

     6. Bar with Line

     7. Layered column

   • Enhanced filtering methods for categorical variable

     1. To filter based on values (By values)

     2. To combine multiple conditions using logical operators such as AND & OR (Condition)

   • Introduced the ability to calculate the total of stack values in Stacked Bar & column charts

   • Added customization options for stack total

     1. Round off

     2. Seperator

     3. BigNumber Suffix

     4. Value Rotation

   • Enhancements in chart building functionality

     1. Default display of ‘Quick Sort’ when accessing sorting functionality on building charts

     2. Implemented an automatic inclusion of grouping variables when utilizing quick sort

   • Implemented ‘Ignore zeros’ feature in Pie, Donut, and Semi-circle widget

   • Implemented a dynamic adjustment feature to adapt the X-axis scale & span of pyramids in Population pyramid

2. Accessibility

   • Simplified user selection with the ‘Select All Users’ checkbox within ‘User matrix’

     1. To visualize total number of users across different user groups within the ‘User Matrix’

     2. To instantly select users across different user groups

     3. To update the dynamic user count display based on the checkbox selection

Bug fixes

1. Profiling bug fixes

   • Improved file upload process with the existing projects

   • Resolved issues on session expiration

2. Statistical bug fixes

   • Formula builder - Resolved issues with transformation functions

3. DashPro bug fixes

   • Resolved issues with filtering functionality (Local, global & tab-wise)

   • Chart retrievals in My charts & Published Dashboard

   • Corrected chart alignment in the dashboard during saving & deletion process

   • Rectified issues with value truncation and overlapping across various chart types, including:

     1. Bullet

     2. Line

     3. Area

     4. Multiple axis

     5. Pie

     6. Donut

     7. Semi-circle

   • Improvements in ‘Deviation’ feature

     1. Maintained precise indication of value in Line, Area & Multiple axis

     2. Highlighted the neutral color for 0% deviation

        • Green - Growth or increase

        • Red - Decrement or decrease

        • Yellow - Baseline or reference point (0%)

   • Fixes on the label formatting functionality in Text widget

   • Improvements in functionalities & customization options

     1. Round off

     2. Highlight negatives

     3. Enable value

     4. Stack total

     5. User-defined chart themes

Version 7.7.1 - 25 Jan 2024

New features & Enhancements

1. DashPro

   • Enhanced positioning of fields using advanced alignment options in the Summary chart. The choices include:

     1. Top: Left, Centre, Right

     2. Centre: Left, Centre, Right

     3. Bottom: Left, Centre, Right

   • Added color customization feature in Stats line

   • Enhanced Multiple Axis chart with ‘Deviation’ and ‘Bignumber Suffix’ options

   • Enhanced the allowance of 70 characters for chart titles based on the specified font size range

   • Introducing a time-saving feature by hitting the ‘Enter’ key

     1. To set goals & prefixes instantly within the ‘Card’

     2. Added the ability to submit inputs in color fields for various chart formatting options

2. Accessibility

   • Improved file handling during file uploads and when renaming existing files

   • Optimised the display of registered details for ‘Invited Users’ during the activation process

   • Improved the efficiency of user session deactivation

3. SQL editor

   • Enhanced auto-select query with no-lock for MSSQL databases

Bug fixes

1. Profiling bug fixes

   • Resolved issues on file deletion & file-sharing methods

   • Corrected issues with Natural language to SQL feature

2. Statistical bug fixes

   • Improved binning performance for auto & user defined types

3. DashPro bug fixes

   • Resolved issues with the display of values in tooltips for Grouped bar and Grouped column charts

   • Handled zero “0” values in Line/Area charts with the “ignore zero” option

   • Consistency & alignment

     1. Maintained consistent header height for KPI card

     2. Alignment of column headers with “Wrap headers” in the Sparkline chart

   • Resolved issue with grid view for saved charts

   • Fixes on the rendering of inputs during chart edits

   • Restricted the use of date variable within the group field for KPI card

   • Permitted access to categorical & numerical datatypes in the KPI card and Custom pivot.

   • Rectified issues in applying global filters for date variables in AG grid charts (Table and Pivot)

   • Improved the performance of sorting order with the ‘Show as positive’ option for the below chart types

     1. Bar

     2. Column

     3. Stacked Bar

     4. Stacked Column

     5. Bar With Line

     6. Line & Area

   • Improvements in functionalities:

     1. Round off

     2. Separator

     3. Start axis at 0

     4. X & Y scroll

     5. Legend order alignment

   • Fixes on chart retrievals & published dashboard

Version 7.7.0 - 14 Dec 2023

New features & Enhancements

1. Accessibility & sharing feature

   • Introduced ‘Add user’ feature for super users

     1. Simplified onboarding process for user activation

     2. Notifying messages equipped with the required information for users to activate accounts

     3. Developed ‘Invited Users Overview’ to enhance visibility and efficient tracking of user details

   • Provided permission to authorized superusers with elevated privileges to access and edit user groups

   • Enhanced safety protocols

     1. Improved password complexity requirements on the sign-up page to secure user accounts

     2. User alerts & warnings for unsuccessful login attempts, to stay informed about unauthorized access

     3. Implemented automatic account deactivation for users inactive over the last 90 days

     4. Updated user session deactivation after a period of 20 minutes (equivalent to 1200 seconds) of inactivity

   • Improved flexibility and control over file-sharing experiences. The methods include

     1. Single file to single user

     2. Single file to multiple users

     3. Multiple files to single user

     4. Multiple files to multiple users

   • Included authorization tokens for all APIs to secure authentication process for the below modules

     1. Data Analytics

     2. Time series

     3. Optical Character Recognition (OCR)

2. Implemented pagination feature for the data table in Statistics

   • Furnishes intuitive controls for smooth navigation through extensive datasets

   • Ability to move between pages using the newly integrated pagination controls

3. DashPro

   • Introducing three new chart types with the standard customization options

     1. Network chart

     2. Waterfall chart

     3. Sparkline chart

   • Introduced User-defined chart theme

     1. To customize visual elements of the chart to showcase unique styles and preferences

     2. Added new chart themes to the chart formatting options

   • Enhanced AG grid charts functionality

     1. Capability to edit and customize column names directly within the AG-Grid charts - Table, KPI, and Custom Pivot

     2. Ability to highlight specific rows by hovering within AG-Grid charts

     3. To select and copy entire rows within AG-Grid charts for improved user interaction

     4. Addition of column totals in Pivot to aggregate and summarize data across categories

     5. Incorporated “Distinct” aggregation function to identify the total count of unique values within the Pivot

     6. Introduced text wrapping in AG Grid chart headers - Table, Pivot, KPI, and Custom Pivot

   • Added unique aggregation for categorical variables, to visualize unique counts in a Card chart

   • Implementation of ‘Deviation’ in the Line & Area

     1. Included ‘Deviation’ for the past two weeks or Month to highlight the difference in data points

     2. Enhanced chart formatting options - Big number suffix, Separator & round-off

   • Added an option to set the limit on the number of records for Bar with Line/Scatter

   • Ability to create Pie chart solely based on X-axis data

   • Incorporated a zoom range feature with selectable options (1 month, 3 months, 6 months, year-to-date, 1 year, and all) for Area chart when choosing a date variable

   • Enhanced advanced sorting options (Quick & Field sort) for Area & Line charts

   • Additions in the Dumbbell plot

     1. Incorporated the feature to create Dumbbell plots in both horizontal and vertical orientations

     2. Ability to designate two numeric variables for generating Dumbbell plots

   • Enhanced color codes for Word Cloud & Waterfall chart

   • Integrated the capability to enable rotation for chart values

   • Included the option to limit records at the bottom or top within charts

Bug fixes

1. Profiling bug fixes

   • Modified editable feature in ‘User Quick Actions’

   • Resolved priority issues on sharing & collaboration

     1. Corrected column(s) collapsing in DashPro charts (Pivot) upon sharing projects

     2. Checkbox selection on sharing, collaborating & deleting the project(s)

     3. Updated user-shared information with the below details

        • Created by (Primary user)

        • Shared to (Secondary user)

        • Received by (Secondary user)

   • Maintained the relevant saved model on project expansion

   • Included a pattern to handle the millisecond in the date variable

   • Eliminated undesired API calls

2. Statistical bug fixes

   • Fixes on Top functions - Grouped Statistics & type conversion (Num-cat/Cat-num)

   • Corrected the generation of new column(s) while performing the top function in statistical operations

   • Alignment of the column(s) under menu section in Statistical Test

3. DashPro bug fixes

   • Critical bug fixes

     1. Chart retrieval in My charts & Published Dashboard

     2. Full-factor rendering in the tooltip

     3. Partitioned the lines of text individually within the tooltip for factors with multiline content (Local/global filter)

     4. Resolved issues on User-defined chart themes

     5. Rectified saving issues involving NaN values in Grouped Bar, Grouped Column, and Area charts

     6. Implemented checks for handling ‘Empty data frames’ in Sunburst visualization

     7. Tackled issues affecting the display of stats line in Radar line and Multiple-axis charts

     8. Fixed toggle enablement for ‘Row and Column totals’ based on selected inputs in ‘Table’ widget

     9. Corrected the problem of retaining the chosen limit (Show result) in saved charts - Bar-with-line, Area & Line

   • Fixes in sorting functionality

     1. Formatted the column name and its unique value in the dropdown (Sort by)

     2. Selection of aggregation in the ‘Sort by’ dropdown (Field sort)

     3. Activated Y-axis and series options to improve the sorting experience (Quick sort) in Population pyramid

     4. Maintained the sorting order during the chart-building process

   • Modified the chart to reflect the selected chart theme, in line with the changes in the color palette

   • Maintained the deviation of the Line chart in the specified order

   • Issues in formatting - Highlight negatives, Rounding off, Enable value, Show as positive, Separator, Bignumber suffix & Rotation

   • Addressed various miscellaneous issues and made several improvements to enhance the performance of the below charts

     1. Table & Pivot

     2. Bar, Stacked Bar & Stacked column

     3. Bar with Line

     4. Line & Area

     5. Box plot

     6. Circos

     7. KPI card

     8. Summary

     9. Text

     10. Word cloud

   • Visual improvements

     1. Spacing and positioning of elements

     2. Adjusted the alignment of fields & sections

     3. Improved chart dimensions for the saved charts within the dashboard

4. Data refresh (DB) bug fixes

5. Predictive Analytics bug fixes

Version 7.6.2 - 18 Aug 2023

New features & Enhancements

1. Statistics (Top functions)

   • Enhanced multiple input boxes for user-defined column selection in Split function (String)

   • Notified the users that define the designated sample data limit of 5K for One Sample Test (One-Tailed & Two-Tailed).

2. SQL editor

   • Added a beta feature: “Natural language text to SQL query” generator in the Database connection page. This enables the generation of SQL queries from natural language text.

3. DashPro

   • Enhanced data arrangement controls through advanced sorting options for various chart types

     1. Source data in unaltered state (Original data source)

     2. Quick sort (Ascending or Descending)

     3. Field sort (Ascending or Descending)

   • Added an option to customize the font size of legend within the charts

   • Introduced the ability to visualize the Pie chart that highlights the existence of zero (0) values within the specified inputs

   • Included the field name into the tooltip to quickly identify the specific data points. The charts include,

     1. Bar/Stacked bar/Grouped bar

     2. Column/Stacked column/Grouped column

     3. Line

     4. Area

     5. Grouped & sorted

     6. Multiple axis

     7. Radar line

     8. Bar with Line

     9. Layered column

     10. Bullet

   • Enhanced column(s) and row(s) width ratios in AG grid charts for better readability

   • Improvement in the “Select All” Option with Round Off and Separator based on column preferences.

4. Optical Character Recognition (OCR)

   • Incorporated the “Clear Cells” option to the context menu within the tabular format

   • Enhanced a refined user interface (UI) for accessing password-protected files

   • Optimized the processing of image files while choosing bounding boxes for text extraction.

Bug fixes

1. Statistical bug fixes

   • Resolved the alignment issue when selecting inputs in pivot analysis

   • Fixes on Top menu functions

     1. Binning

     2. Data transform

     3. Text processing

   • Resolved issues on saving the statistical tests

2. DashPro bug fixes

   • Fixed the process of saving the below charts on both actions and edits

     1. Summary

     2. Card

     3. KPI card

     4. Custom pivot

   • Improvements in functionalities & customizable options

     1. Stats line & its position

     2. Round off

     3. Highlight negatives (Ag grid)

     4. Pin row total & pin column total (Ag grid)

   • Fixes on chart retrievals

   • Included the data in a ‘Table View’ format for both the ‘Y Axis’ and ‘Series’ components in ‘Bar with Line’

   • Included ‘Target’ values within the table view of the ‘Bullet chart’

3. Optical Character Recognition (OCR) bug fixes

   • Fixes on exporting the processed data

   • Functional improvements

     1. Rotating feature for Pdf uploads

     2. Find & replace

Version 7.6.1 - 25 July 2023

New features & Enhancements

1. DashPro

   • Added an option to display the structured & organized tabular data (Table view) with the corresponding values. The widgets include,

     1. Treemap

     2. Heat map legend

     3. Grouped & sorted

     4. Bullet chart

   • Enhanced visual color continuity based on categories in the Sunburst chart.

   • Flexibility and control over data visualization in Ag grid

     1. Turned off row and column totals for the non-numerical variable(s) in Table & Pivot.

   • Addition of data zooming with customised timeframe within the range

     1. Option to zoom in and zoom out of the Line chart based on predefined durations: 1 month, 3 months, 6 months, Year-To-date

     2. The “Zoom In” and “Zoom Out” buttons will adjust the visible range on the x-axis accordingly.

2. Statistics

   • Improved N grams efficiency in graph stat

   • Notified messages for invalid column(s) performance in Split function.

Bug fixes

1. Profiling bug fixes

2. Statistical bug fixes

   • Positioned the delete icon in Advanced statistics for refined appearance

3. DashPro bug fixes

   • Organised the ignored columns and their associated data types in chart features

   • Space elimination in Text and AG grid charts for better readability

   • Improvements in the “Select All” toggle functionality in Table widget when applying filter (Local)

   • Added tooltips to ensure specific data points in Bar & Column charts.

4. Optical Character Recognition (OCR) bug fixes

   • Eliminated the processing of blank images or pdf files to minimise time processing and resource utilisation

   • Improved accuracy for processing the saved templates

   • Fixes on labeling the bounding boxes.

Version 7.6.0 - 14 July 2023

New features & Enhancements

1. DashPro

   • Introducing the following new charts with the standard customisation options

     1. Sunburst chart

     2. Circos chart

   • Introduced a feature to visualize the cumulative values for AG grid charts

     1. Summation of rows and columns for Table & Pivot

     2. Highlight the summed up row or column with a custom color

   • Enhanced the default blank page layout on the dashboard

     1. Included ‘Add widget’ for easy navigation for building charts

     2. A new tab is created by default when users adding a new widget

   • Improved flexibility in Bar-with-Line chart:

     1. Use identical column for both Y-Axis and Series input

     2. Apply different aggregation methods to each of the input column

2. Optical Character Recognition (OCR)

   • Correct document orientation with rotation feature

     1. Accurate alignment detection

     2. Automatic rotation adjustments (Auto rotate) performed through backend image processing

     3. Improved user experience

3. Enhanced temporary memory clearing mechanism for faster file loading

   • Automatically purge temporary files that haven’t been accessed or modified within a specified timeframe of 72 hours

Bug fixes

1. Profiling bug fixes

   • Eliminated undesired API calls

2. Statistical bug fixes

   • Fixes for ignoring and pseudonymization feature

   • Improved auto-generation of column names to avoid ambiguity with existing column names during transformation functions

3. DashPro bug fixes

   • Accurate representation of “Null” as “Blanks” in charts:

     1. Custom pivot

     2. Timeline

     3. Box plot

     4. KPI card

   • Resolved issues with retrieving charts in Published Dashboard

   • Fixes for local and global filters

   • Improvements in functionalities:

     1. Separator

     2. Bignumber suffix

     3. Enable value

     4. Round off

   • Enhanced transparency of factors in Sunburst chart

4. Optical Character Recognition (OCR) bug fixes

   • Modified table structure based on content through resizing

Version 7.5.1 - 20 June 2023

New features & Enhancements

1. Data refresh functionality (CSV file refresh)

   • Ability to update/refresh external file uploads in a manner similar to those uploaded through the databases.

   • Option to upload a revised CSV file containing updated records.

   • Allow users to keep their data up-to-date by easily updating or modifying the information stored in the CSV file.

2. DashPro

   • Implementation of global filter in published charts.

Bug fixes

1. Statistical bug fixes

2. DashPro bug fixes

   • Fixes on Published Dashboard.

   • Modified the font size in the aggregation dropdown for Ag grid charts.

   • Expanded the height of the values section within the Pivot.

   • Resolved issues with ag-grid charts retrieval.

3. Optical Character Recognition (OCR) bug fixes

Version 7.5.0 - 09 June 2023

New features & Enhancements

1. Optical Character Recognition (OCR)

   • Introducing a new tabular feature to enhance usability and enable effective data manipulation.

     1. Default options (cut, copy) and customizable options (paste, find & replace) for data display preferences.

     2. Quick editing process through inline editing.

     3. Freeze or unfreeze specific cells within the OCR output table.

     4. Insert or remove rows and columns within the OCR output table.

   • Added the capability to reset the edited output, for both table and text output.

2. DashPro

   • Disabled the option to configure the axis to start at 0 (Start axis at 0) for charts with positive and negative values.

   • Added an option to customize the font color for the header in Ag-Grid charts.

   • Modified the factors to be left-aligned for optimal space utilization.

   • Ability to select the position of the value label (beyond) in Bar/Column/Bar-with-Line charts.

   • Improved the process of saving charts by enhancing functionality during actions and edits.

   • Altered the positioning of the X-axis label in Gantt charts to display at the top.

   • Added a toggle to select-all columns in the Table widget.

   • Included Y-rotation for Multiple-axis chart.

   • Added “Show as positive” option in Bar-with-Line chart.

   • Included an option to filter values by week (relative).

3. New Notifier (Application)

   • Introducing a new notifier component to enhance the user experience (UX).

   • This ensures timely delivery of informational messages, success notifications, warnings, or error alerts.

   • The notifier consistently disappears based on a set timer automatically, providing a seamless and efficient user interaction.

4. Statistics

   • Added search bar for Grouped statistics to quickly filter the desired column(s).

Bug fixes

1. Profiling bug fixes

   • Prevented additional rows from being added during sampling operations.

   • Removed undesired API calls.

2. Statistical bug fixes

3. Data refresh (DB) bug fixes

4. DashPro bug fixes

   • Resolved issues with chart retrieval.

   • Fixed issues with Bignumber suffix, Round off, Enable value, and Separator in chart formatting.

   • Corrected chart formatting inconsistencies.

   • Fixed issues with renaming tabs on published dashboard.

   • Aligned the length of Y-axis values when changing Y-rotation according to the rotation angle.

   • Enabled the display of selected columns in the group in the chosen order.

   • Restricted the maximum period or timeframe in the KPI card.

   • Reset the grid of formulas and labels in Card when editing a chart to make new adjustments to the formula in a clean slate.

   • Maintaining the appropriate position of copied charts on dashboards.

5. OCR bug fixes

   • Fixed issues with resetting bounding boxes.

   • Provided updated and revised records in downloaded CSV or Excel file formats.

   • Improved labeling of bounding boxes.

   • Instant updates in Line chart for modified records.

   • Disabled undesired functions (chart icon & remove all) during OCR processing.

   • Restricted processing of bounding boxes when saving the template.

Version 7.4.0 - 21 Apr 2023

New features & Enhancements

1. Optical Character Recognition (OCR)

   • Introduced a feature to draw a Line chart for a quick quality check (QC) - Tabular format

     1. To determine whether the extracted output column contains numerical values

     2. Users may identify a break on the line chart for non-numerical data and can trace back to edit using its index

   • Included a feature to drag & expand the output box for tabular format as in text format

2. Statistics

   • Implementation of Split function for multiple columns in Statistics (String)

   • Auto-suggestion while text processing on the selection of stopwords

3. DashPro

   • Implemented a new design & features to Card widget

     1. Users can choose an option to input a Goal or Target number

     2. The Growth percentage (Red/Green) is calculated and displayed based on the input above

     3. Option to input a prefix to the aggregated number. Example, $234, Rs.234 etc.

   • Upgraded the ag-grid to the latest version (only for DashPro)

     1. This maintains the state of the columns’ width and the sort while retrieving

     2. Auto-sizing of the cell height based on the font size

     3. More visually appealing

   • Added color picker for the dots in Scatter widget

   • Option to choose the position of Stats line - Above/Behind

   • Enhanced the legend color on attempting to change the chart theme in Zoomable Bubble

   • Added an option to enable the value in Gantt chart

   • Provided the option to choose ‘Full Weekday’ & ‘Full Month’ for date variable while grouping

   • Option to set the numerical axis to start from 0 or auto-scale

     1. Bar

     2. Stacked Bar

     3. Grouped Bar

     4. Column

     5. Stacked column

     6. Grouped column

     7. Line

     8. Area

     9. Gantt

     10. Scatter

     11. Dumbbell plot

     12. Grouped and sorted

     13. Multiple axis

     14. Zoomable bubble

     15. Population pyramid

     16. Bar with line

     17. Layered column

     18. Bullet

     19. Candlestick

   • Option to enable separator for values in charts. The charts are,

     1. Bar

     2. Stacked Bar

     3. Grouped Bar

     4. Column

     5. Stacked column

     6. Grouped column

     7. Pie

     8. Line

     9. Area

     10. Heat map legend

     11. Grouped and sorted

     12. Multiple axis

     13. Population pyramid

     14. Bar with line /scatter

     15. Layered column

     16. Bullet

Bug fixes

1. Statistical bug fixes

   • Issues in Split function

   • Fixes on the selection of factors in the data table

2. DashPro bug fixes

   • Fixes in KPI card

   • Construction of the graphs on providing Stats line in Bar with Line

   • Fixes on Bignumber suffix and Round off

3. Data refresh(DB) bug fixes

4. Predictive Analytics bug fixes

5. Optical Character Recognition (OCR) bug fixes

   • Fixes on labeling the bounding boxes

   • An issue with naming and modifying the bounding boxes for saved templates

   • Fixed the navigation to the corresponding page while redrawing the selected bounding box

Version 7.3.0 - 31 Mar 2023

New features

1. User roles & permissions

   • Enhanced the code to have multiple admin users for the application

   • Added another user role “superuser” with the permissions of accessing the User’s quick actions, including the admin role permissions

2. DashPro

   • On the Zoomable bubble chart legend, the ability to click the element you want to filter (hide) from the chart area

   • Provided an option to sort data in Bar-with-Line to customize the chart

   • Indication of 100% missing values in the widget creation interface

   • Ability to select separate aggregation for each individual column for the multiple selection charts

     1. Grouped Bar

     2. Grouped column

     3. Line

     4. Area

     5. Multiple Axis

     6. Radar line

     7. Bar with Line

     8. Layered column

     9. Bullet

     10. KPI card

     11. Custom Pivot

   • Implementation of “Show as positives” for the below charts

     1. Stacked Bar

     2. Grouped Bar

     3. Stacked column

     4. Grouped column

3. Optical Character Recognition (OCR)

   • User Interface (UI) improvements

   • Added ‘OCR Pro’ method to extract data with better accuracy (Premium credit based)

   • Improved features - Zooming, Panning, and resizing the PDF/Image files

   • Option to choose the content type for the selected box (Tabular or Text)

   • Provided the scroll bar to view the entire data in the output boxes

4. Maintaining the user-preferred sort method on the Projects page

Bug fixes

1. Profiling bug fixes

   • Data Analytics - Allowing only unignored columns to perform Sampling

   • Time series - Display the chosen date (target) variable in the plotted graph

2. Statistical bug fixes

   • Fixes on Split function and Text->Cat conversion

3. DashPro bug fixes

   • Fixes on Enable value and Round-off

   • Aligned the scale of Y axis in Bar-with-Line

   • Display of the factors count for the categorical columns on selection for the below charts

     1. Grouped Bar

     2. Grouped Column

     3. Line

     4. Box plot

     5. Area

     6. Multiple Axis

     7. Radar Line

4. Optical Character Recognition (OCR) bug fixes

   • Optimized the loading time for PNG/JPEG files

   • Provided restriction for unsupported file formats

5. Predictive Analytics bug fixes

   • Added validation while saving the hyperparameter to ensure the user’s selection

Version 7.2.0 - 07 Mar 2023

New features

1. Projects page - Provided sorting options for the files with in each project

   • Dataset Name

   • Size

   • Created Date

   • Updated Date

2. DashPro

   • Added an option to align X-axis values (left, center & right) for the below charts

     1. Column

     2. Stacked column

     3. Grouped column

     4. Box plot

     5. Bar with Line

     6. Layered column

   • Provided Stats line for the widgets having multiple axes

     1. Bar With Line/Scatter

     2. Multiple line

   • Card - Ability to cut, copy & paste the text under labels.

   • Option to add thousands separator(‘,’) to the numerical values in grid

     1. Table

     2. Pivot

     3. KPI

     4. Custom Pivot

   • Ability to Ignore Zeros for the below widgets

     1. Line

     2. Multiple Axes

     3. Area

   • Choice of filling Box-plot with color using color picker to make it more visually appealing.

   • Box plot

     1. Ability to sort through X-axis values.

     2. Date column can be used for the X-axis.

   • Export dashboard to PDF (beta).

3. Optical Character Recognition (OCR)

   • Optimized way of loading the pages of PDF - Sequential method.

   • Enhanced UI when re-drawing the bounding boxes.

   • Direct navigation to the final page of export for the saved templates.

Notable Enhancements

1. Statistics

   • Ability to include negative values in Custom binning.

   • Modified the separator to comma(,).

2. DashPro

   • Publish Dashboard - Restricted the following access to non-admin users

     1. Interchange tabs

     2. Filter widgets

     3. Reposition widgets

3. Predictive Analytics - Disabled the prediction tab once the chosen model is deleted to prevent errors.

Bug fixes

1. Profiling bug fixes

   • Sampling & GDPR issues.

2. Statistical bug fixes

   • Removed the undesired API calls.

   • Issues in top functions - Repeat, Exclude string.

   • Alignment issues.

3. DashPro bug fixes

   • Chart retrieval issues.

   • Tab navigation issues.

   • Red flag indicator issues for the Published Dashboard.

   • Issues in formatting - Highlight negatives, Rounding off & Enable value.

   • Fixes on selection of factors using search field (Local & global filter).

4. Data refresh(DB) bug fixes.

5. Predictive Analytics bug fixes.

6. Optical Character Recognition (OCR) bug fixes

   • Fixes on saving templates.

   • Issue on processing and exporting the saved template.

7. Text Analytics bug fixes.

Version 7.1.1 - 03 Feb 2023

Notable Enhancements

1. Optical Character Recognition (OCR)

   • Supports multi-page PDFs and image files.

2. DashPro - Chart format features & options categorized

   • Axes

   • Axis Title (X Title, Y Title, Font Family, Title Font Size, X-axis Label font size, Y axis Label font size, X-rotation, Y-Rotation, Synchronize axis)

   • Chart Title

   • Chart Format

     1. Chart Styling (Chart Theme, Line Style, Line Stroke, Line Bullet, Stroke Width, Bullet type, Stroke Width, X-scroll, Y-scroll, Enable Grid, Color Range)

     2. Data labels (Enable Value, Value Font size, Font Family, Position, Roundoff value, Separator, Big Number Suffix, Color, Bold, Italic, Show as positives)

     3. Legend (Legend & Legend Position)

     4. Map features (Zoom, Mini Chart, Globe, Rotate)

     5. Others (Stats Line, Cursor, Export)

3. DashPro - Rounding off the Stats line value for the below charts

   • Bar

   • Column

   • Stacked Bar

   • Stacked column

   • Line

   • Area

   • Grouped Bar

   • Grouped column

4. Statistics - String function (Extract & ExtractNum) - Precise extraction of numeric values.

Bug fixes

1. Statistical bug fixes

2. DashPro bug fixes

3. Data refresh (DB) bug fixes

4. Pipeline bug fixes

5. Predictive Analytics bug fixes

6. OCR bug fixes

Version 7.1.0 - 16 Jan 2023

New features

1. Optical Character Recognition (OCR)

   • Enhanced UI design.

   • Multiple tabs for the OCR.

   • Save the templates and apply them to a new PDF/image file.

   • Export the OCR data to a database (Currently supports MySQL).

   • Supports single page PDFs & Image files.

   • Multi-page PDFs will be supported in future releases.

2. Data Analytics

   • SQL editor - Options to auto-fill the select query upon right-clicking the table name

     1. Select * from <table_name>

     2. Select <field names> from <table_name>

   • Sort by feature to sort the projects on the Projects page.

     1. Sort by - Name, Created date, and Updated date

   • Datatype conversion feature in Statistics - Categorical to Numerical (Cat->Num)

3. DashPro

   • Filter (Global & Local)

     1. Visual indication of the count of filters applied.

     2. Option to pin/unpin the Global filter on the Dashboard.

     3. Included ‘between’ condition for Numerical and Date type columns.

   • New Widget - WordCloud

     1. Create a WordCloud chart using a Text or Categorical column.

     2. Options to choose N-grams and the number of top frequent words for plotting.

   • Ability to alter the gap between the axes labels for the below charts

     1. Bar with Line

     2. Line

     3. Area

     4. Column

     5. Multiple column

     6. Dumbbell

     7. Stacked column

Notable Enhancements

1. Statistical test - Histogram density plot - Added a message for the user, if the values of the chosen column are alike.

2. Projects page

   • Added a separate vertical for ‘Accuracy’ in the saved ML models grid.

   • Display the count of checkboxes selected for the projects and files

3. DashPro

   • Bar with Line widget - Option to display enable value for either Bar (or) Line (or) both.

   • Added an option to pick out a shade for the Bullet chart (Scatter).

   • Enabled mouse-click events to edit tab names.

4. Ability to change the order of the aggregation conditions in the ‘Card’ widget.

5. Stabilized the alignment of the application’s left menu bar, footer, and top icons on navigating through different pages.

Bug fixes

1. Profiling and Sampling bug fixes.

2. Statistical bug fixes

   • String (Top function) - Restriction of negative values in the Sub-string function.

3. DashPro bug fixes

   • Fixes in filters on applying conditions (Local & Global) and in Published Dashboard.

   • Ability to view all the applied formulae in ‘card’ using the scroll.

   • Fixes on sorting icons over the Dashboard.

   • More robust indication for Local filter.

4. Data refresh (DB) bug fixes.

5. Pipeline bug fixes.

6. Collaboration bug fixes.

7. Predictive Analytics bug fixes.

8. Optical Character Recognition (OCR) bug fixes.

Version 7.0.1 - 08 Dec 2022

New developments

1. DashPro

   • Added enable value in the multiple axis charts.

   • Added an option to ‘Synchronize axis’ in Bar with Line widget.

   • New icon for Filter over the dashboard charts and the enhanced color indication to distinguish clearly the applied filters (Global & Local).

2. Added a switch to show or hide the empty bins on target distribution graph - Profiling page, Statistics page (Graphstat) & ML page.

Bug fixes

1. DashPro bug fixes

   • Fixes in Table widget on navigation to it after performing other widget(s) like KPI card.

   • Restricted the saving of the Pivot with no input.

   • Removed sorting options in ‘Table view’ for the saved widgets (My charts).

   • Retrieving the order of the records in ‘Table view ‘ as in ‘Graph view’ (My charts).

   • Calculating average (Stats line) for more than one column for Grouped Bar.

   • Enhanced display of the enable value on the Stacked Bar for negative bars.

   • Fixes in the filter query construction.

2. Collaboration fixes

3. SQL editor fixes

   • Tooltip for table names in DB source workspace.

Version 7.0.0 - 30 Nov 2022

New developments

1. DashPro - New clean UI for the Local filter and Global filter.

2. Statistical test - Implemented Two-Tailed Test in One-Sample T-Test.

3. Statistical test - Implemented Paired T-Test.

4. Data refresh (DB) - Newly added columns, if there are any, in the already loaded DB table are now pulled during the refresh (select * from)

5. Predictive Analytics - Added Expert Configuration in Custom ML.

Notable Enhancements

1. Data explorer - Enhancement in saving the project name using Enter button.

2. Date Difference (Transformations) - More precise calculation based on the unit (hour, minute, second).

3. Data refresh(DB)

   • Display of the latest updated date after file refresh on the Project page (Data explorer).

   • Enhancement to remain on the same page on refreshing.

4. DashPro

   • Color indication of local and global filters whether or not applied.

   • Enhanced view of the X-axis labels.

   • Enhanced the positioning of the values (enabled) for all the Bar & Column charts.

   • Added new icons for Global Filter, Table widget, Heatmap widget, Treemap widget and Text widget.

   • Sorting done on the dashboard widgets is now intact and retrieved.

   • Removed the dot plot for Grouped and Sorted.

   • Maintaining the order of Tabs on the Published Dashboard.

5. DashPro Filters

   • Ability to include/exclude filter missing values (Blanks).

   • Option to exclude the selected factors in Categorical fields.

Bug fixes

1. SQL editor bug fixes.

2. Statistical bug fixes

   • Query execution in Transformation.

   • Square root (Data transform) in Top functions - Generation of NaN value in the newly created column.

   • Restriction of sampling/filtering in Statistical tests if it is not taken into consideration.

   • Fixes in string functions for multiple columns input.

   • Fixes in Interval binning (Data transform).

2. Pipeline bug fixes.

3. DashPro bug fixes

   • Chart retrieval in Published Dashboard.

   • Fixes on showing up of data on copying the saved widgets.

   • To show the chosen column(s) in Pivot headers on editing the saved widget.

4. Data refresh (DB) bug fixes.

5. Prediction (Custom ML) bug fixes.

SEDGE 6.0 Release notes

Version 6.9.1 - 26 Oct 2022

Bug fixes

1. Pipeline bug fixes.

2. DashPro bug fixes

   • Chart retrieval in Published Dashboard.

   • Grid format in Summary

   • Fixes on position retaining and sorting functionality in the global filter

3. Prediction bug fixes

   • Restricted navigation to CustomML or AutoML page when one of the modules is in running state.

   • Consistent grey out of the Save model button once the model gets saved.

   • Turn up the formerly saved algorithm on direct navigation to Saved model.

4. Statistical bug fixes

   • Added X-axis label in Target distribution graph.

Version 6.9.0 - 14 Oct 2022

Notable enhancements

1. Enhancement of legend position for the below-mentioned charts in DashPro

   • Stacked bar

   • Grouped bar

   • Stacked column

   • Grouped column

   • Population pyramid

2. Added Sampling actions in pipeline activities.

3. Retaining of tab order in DashPro.

4. Added stats line for below-mentioned charts in DashPro

   • Bar

   • Stacked bar

   • Column

   • Grouped column

5. Added an option to “Delete only files” and “Delete complete User” in Users list.

6. Enhancement in KPI card period selection based on the Calendar unit - Year, Quarter, Month & Week.

7. Map with bubble - Added support for the Country codes in the selected Country column.

8. Custom ML - Added an option to ‘Predict & Download’ in Prediction page.

9. Delete date range in Statistics - Added an option to keep or delete the selected period.

Bug fixes

1. DashPro bug fixes.

2. File collaboration bug fixes.

3. Statistical bug fixes.

4. Custom ML prediction bug fixes.

5. Pipeline bug fixes.

Version 6.8.1 - 23 Sep 2022

Notable enhancement

Direct navigation to Published Dashboard from the Homepage.

Bug fixes

1. DashPro bug fixes.

2. Statistical bug fixes.

Version 6.8.0 - 14 Sep 2022

New features

1. Implementation of Date related top menu functions.

2. Publishing dashboard.

3. MongoDB support in the Database connection.

Notable enhancements

1. Addition of Holder(Owner) information on sharing of the file.

2. Addition of preserve state for KPI card and custom pivot in DashPro.

3. Implementation of local filter for below charts

   • Table

   • Pivot

   • Card

   • KPI card

   • Custom pivot

4. Functionality to fill missing row in a column by calculating the average of previous & next non-null value.

5. Implementation of multiple lines for Radar line.

Bug fixes

1. DashPro bug fixes.

2. Prediction bug fixes.

3. Statistical bug fixes.

Version 6.7.0 - 1 Aug 2022

Notable enhancements

1. Enhancement for the below charts

   • Table

   • Pivot

   • Summary

2. Enhancement in abortion of a model in Prediction.

3. Faster processing of chart retrieval in DashPro.

4. Implementation of relabeling a project using pseudo project name.

Version 6.5.0 - 27 May 2022

New features

1. Automated Machine Learning (Auto ML).

2. Implementation of machine learning prediction share.

Other notable enhancements

1. The following new charts are added in DashPro

   • Timeline chart

   • KPI card

   • Data card

2. DashPro optimisation.

Bug fixes

1. DashPro bug fixes.

2. Statistical bug fixes.

Version 6.3.0 - 31 Mar 2022

New features

1. The following new charts are added in DashPro

   • Bullet chart

   • Layered column chart

   • Map with bubble

   • Box plot

Kindly Refer DashPro

2. Interpreting a predictive Model using SHAP values.

Kindly Refer Predictive Analytics

3. Calculating statistical features for columns based on a grouping.

Kindly Refer Statistics-Data

4. Added numerical format conversion based on country and transpose function in Statistics.

Kindly Refer Statistics-Numerical operations

Other notable enhancements

1. Histogram with density plot for one sample t-test and Shapiro wilk in Statistical test.

Kindly Refer Statistics Tests

2. Comparison of distributions between few variables.

Kindly Refer Graphical Analysis

Bug fixes

1. Visualisation bug fixes

2. Statistical bug fixes.

Version 6.1.0 - 26 Feb 2022

New features:

1. The following new charts are added in DashPro

   • Zoomable bubble

   • Heat map legend

   • Treemap

   • Population pyramid

   • Candlestick chart

Kindly Refer DashPro

2. Implementation of scatter chart in Statistics.

Kindly Refer Scatter plot in Graphstat

3. Added Splitting and numerical extract operation functionalities.

Kindly Refer Statistics-string

4. Yeo-Johnson power transformation.

Kindly Refer Statistics-Maths

5. Few statistical tests are added - One sample T Test , Shapiro-Wilk , Chi-Square Test.

Kindly Refer Statistical Tests

6. Performance improvement.

Other notable enhancements:

Enhancement in Cluster analysis including optimal cluster calculation.

Kindly Refer Cluster analysis

Bug fixes:

1. Data visualisation bug fixes.

2. Statistical bug fixes.

SEDGE 5.0 Release notes

Version 5.5.0 - 21 Jan 2022

New features:

1. Color continuation in Visualisation [Variable’s factors will be having the color consistency across all charts in Dash Pro and the data visualization part].

Kindly Refer Color continuation

Other notable enhancements:

1. Enhancement in methods of imputation.

Kindly Refer Methods of imputation

2. Enhancement in file collaboration.

Kindly Refer File collaboration

3. Kwiatkowski–Phillips–Schmidt–Shin (KPSS) tests in Time series.

Kindly Refer KPSS test

4. Enhancement in One Hot Encoding.

Kindly Refer One Hot Encoding

Bug fixes:

1. Dash Pro charts.

2. Data wrangling functions.

3. Data ingestion via database.

Version 5.4.0 - 16 Nov 2021

New features:

1. File collaboration [User can share a project file, which is analysed, to other user]

Kindly Refer File collaboration

2. Hyperparameter suggestion in Time series.

Kindly Refer Hyperparameter suggesstion

Other notable enhancements:

1. Decision Tree analysis.

Kindly Refer Data Analytics

2. DashPro charts.

Kindly Refer Dash Pro

Bug fixes:

1. DashPro bug fixes.

2. Database big fixes.

Version 5.2.0 - 23 Sep 2021

New features:

1. Delta function.

Kindly Refer Delta function

2. Added 6 charts in DashPro.

Kindly Refer DashPro

3. Model comparison in Data Analytics.

Kindly Refer Model comparison

4. Actual vs Predicted target visualisation.

Kindly Refer Data analytics

5. Database file refresh.

Kindly Refer Control panel

6. My activities.

Kindly Refer Control panel

Other notable enhancements:

1. Added 3 more sampling methods.

2. User characterised shading in charts.

3. Added 5 more data imputation methods.

Bug fixes:

1. Statistical bug fixes.

2. Visualisation bug fixes.

Version 5.1.0 - 20 July 2021

New features:

1. Time series forecasting

   • Time based slicing.

   • Resampling.

   • Seasonal decomposition.

   • Stationarity checks.

   • ACF & PACF analysis.

   • Univariate/multivariate models.

   • Model comparisons and many more features.

Kindly Refer Time series forecasting

2. OCR [Optical Character Recognition]

• Image OCR.

• PDF OCR.

• Google OCR.

Kindly Refer Optical Character Recognition

3. Expertise to build stored procedures in MYSQL Database.

Kindly Refer Data Analytics

Other notable enhancements:

1. DashPro Enhancements.

2. Newly added data wrangling functions.

3. More date extraction features.

4. Algorithms tuned for better accuracy.

5. Performance improvements.

Bug fixes:

1. Database issues.

2. Cluster analysis.

3. Data visualisation fixes.

Miscellaneous:

1. More secured data and authentication encryptions.

2. Validation messages in more comprehensive and to the problem.

SEDGE 4.0 Release notes

Version 4.2.0 - 5 July 2021

Enhancements in DashPro:

Kindly Refer DashPro for below enhancements.

1. Font Family and Font Size for Labels.

2. Chart values position changes according to requirement.

3. Charts colour palettes/Themes.

4. Few existing features tuning.

5. Few enhancement & bug fixes.

Other notable enhancements:

1. Tuned Support Vector Machines.

Kindly Refer Algorithms

Bug fixes:

1. Few bug fixes for specific scenarios.

Version 4.1.0 - 16 Apr 2021

New features:

1. Added new functions in transformations.

Kindly Refer Transformations

2. New algorithm – Multi-Layer Perceptron and Light GBM.

Kindly Refer Algorithms

3. SEDGE in Japanese.

Kindly Refer Basics

Other notable enhancements:

1. Support Vector Machine is tuned based on dataset characteristics.

Kindly Refer Algorithms

2. User can report a bug or raise a request through the application.

Kindly Refer Basics

3. User can contact SEDGE team through “Need consulting ? “ option.

Kindly Refer Basics

4. User can also share their finding , post scientific challenges of SEDGE and many more through “Forum”.

Kindly Refer Basics

5. DashPro enhancements.

Kindly Refer DashPro

6. N-Grams in Text processing.

Kindly Refer Statistics - Text

Bug fixes:

1. Transformation validations

2. DashPro bug fixes

3. Model save fixes

4. SMOTE fix

SEDGE 3.0 Release notes

Version 3.0.2 - 26 Feb 2021

New features:

1. DashPro – BI module to develop and custom our own charts

Kindly Refer DashPro

2. COVID Calculator - A mathematical model to predict how long will it be before we reach herd immunity https://analysis.sedge.ai/covid-vaccine-calculator

Kindly Refer COVID Calculator

3. LIME – Local interpretations

Kindly Refer Prediction

4. Optimized visualization using Hi-Charts

Kindly Refer Visualization

5. Decision tree analysis – Visualization

Kindly Refer Visualization

Other notable enhancements:

1. Sign up and Login

Kindly Refer Application access

2. Jupyter notebook – Enhanced to minimal user intervention

Kindly Refer Jupyter notebook

3. Extracting more day and time related parameters from a date column.

Kindly Refer Statistics - Date

4. Tuned variable of importance based on sampling

Kindly Refer Variable of importance

Bug fixes:

1. Sampling fixes

2. Sign up/Login fixes

3. Optimization

4. Python disconnection issue for huge volumes model training

5. Machine learning fixes

Deprecated:

1. Text analytics

2. Face recognition

3. OCR

4. Object detection

Version 3.0.1 - 26 Nov 2020

New features:

1. New UI - Material design , AG-Grid and Hi-Charts

Kindly Refer Visualization

2. Support different delimiter files

Kindly Refer File upload

3. Added PostgreSQL , MariaDB

Kindly Refer DB connection

4. Multiple file uploads

Kindly Refer File upload

5. Data preview – Auto cleaning and display

Kindly Refer Data preview

6. Data sampling methods

Kindly Refer Data profiling

7. Information about the dataset for easy cleaning

Kindly Refer Data Analytics

8. GDPR

Kindly Refer GDPR

9. 40+ data wrangling functions

Kindly Refer Statistics top functions

10. 30+ transformation functions

Kindly Refer Transformations

11. Variable of importance and evaluation metrics including Gain, Lift and K-S charts

Kindly Refer Data Analytics

12. AUC-ROC

Kindly Refer AUC-ROC

13. Visualizing predicted output

Kindly Refer Prediction

14. Trained model sharing to users who can access from any other environment

Kindly Refer Prediction

Other notable enhancements:

1. Data table with details of a selected feature’s class

2. Bivariate analysis of any selected column against the target by a simple toggle

3. Advanced statistics such as Kurtosis , Skewness and others

4. Depiction of outliers using box plot

5. Important features and their contribution against the target

6. Class imbalance suggestions

7. Multi class predictions up to 20 classes

8. Helps for each module

Deprecated:

1. Nonlinear correlation techniques – MAC, MIC,DCOR

2. RAM and Hard disk utilization

SEDGE 2.0 Release notes

Version 2.0.0 - 18 Mar 2020

New features:

1. File upload and DB connections

Kindly Refer Data sources

2. Data load from HDFS

Kindly Refer File upload

3. Distribution against target

Kindly Refer Profile dataset

4. Advanced statistics

Kindly Refer Statistics - Advanced

5. Cluster analysis

Kindly Refer Cluster analysis

6. Deviation analysis

Kindly Refer Deviation analysis

7. Outlier analysis

Kindly Refer Outlier analysis

8. 9 Algorithms added

Kindly Refer Algorithms

9. Evaluation metrics such as accuracy, Precision, Recall, Log-loss, Confusion matrix

Kindly Refer Variable of importance

10. Text analytics , OCR , Image and Video analytics

Kindly Refer Functionality

Other notable enhancements:

1. One hot encoding

Kindly Refer One hot encoding

2. Correlation and network chart

Kindly Refer Correlation chart

3. Change password

Kindly Refer Application access

4. Renaming factor

Kindly Refer Renaming factor