Platform updates

Visiology 3.11

Release Date: February 4, 2025
Key Updates
  • New Object-Level Access Control
    Visiology 3.11 introduces expanded access control features. In addition to the existing RLS (Row-Level Security), the platform now supports OLS (Object-Level Security) — enabling permissions at the table and column level.
  • Incremental Data Loading
    A new option allows updating only the most recent data period, significantly reducing data loading times.
  • Integration with Smart Forms
    Starting from version 3.11, Smart Forms are installed and launched alongside other Visiology components. Users can now easily switch between the portal, Dashboard Designer, and Smart Forms.
DanKo Enhancements
10 New DAX Operators Added
  • CONCATENATEX: Evaluates an expression for each row in a table, concatenates the results with a specified delimiter, and returns the result as a single string.
  • 9 New Rounding Functions in DAX
    • ROUND: Rounds a number to the specified number of decimal places (defaults to whole number).
    • ROUNDUP: Always rounds away from zero.
    • ROUNDDOWN: Always rounds toward zero.
    • MROUND: Rounds up if the remainder is greater than or equal to half of the given value.
    • INT: Returns the integer portion of a number (rounds down).
    • FLOOR: Rounds down to the nearest multiple of a specified value.
    • CEILING: Rounds up to the nearest multiple of a specified value.
    • ISO.CEILING: Similar to CEILING, but follows ISO rounding rules.
    • TRUNC: Removes all decimal places.
Widget Improvements
  • Conditional Formatting
    Users can now apply conditional formatting to tables directly within the platform, automatically setting background and text colors based on configured parameters.
  • Cross-Instance Dashboard Transfer
    Dashboards can now be transferred between environments or updated while preserving settings such as access rights, scheduled reports, portal options, and links.
  • Granular Dashboard Access
    Permissions can now be granted for individual dashboards without exposing the entire workspace—minimizing risks of accidental edits or deletions.
  • Expanded Table Widget Analytics
    Users can click on a row to view related data in other widgets, enabling deeper insights without leaving the current dashboard.
  • Dashboard Embedding
    Dashboards can now be embedded into any external resource that supports <iframe>. Widgets can be embedded with either public access or secured access via Keycloak authentication.
  • Visualization Configuration
    You can now configure X, Y, and secondary Y axis labels in charts. Filter widgets can also be configured to selectively influence other widgets.
  • Widget Reuse
    Widgets can now be copied—along with their settings—from one dashboard to another (even across workspaces), or from one sheet to another within the same dashboard. Viewers can also save dashboards to their own workspace and customize them.
Administration
  • Improved Interface
    Users can now hide impact indicators on widgets, collapse all tables in the "Data" panel at once, and select multiple dashboards at the same time.
  • Connection Testing
    JDBC connections can now be tested before use.
  • Quick Access to Support
    A direct link to the technical support contact page has been added inside the Dashboard Designer.
  • Log Storage Management
    New options to configure log retention duration are available.
  • External Authentication Support
    Visiology 3.11 now supports external Keycloak with automatic service setup. HTTPS configuration and domain changes have also been simplified.
  • Simplified Deployment
    Platform deployment and update processes have been reduced to just two steps.

Visiology 2.40

Release Date: February 4, 2025
Key Fixes in Version 2.40
  • Script Improvements
    Fixed an issue with executing Python scripts when using relative date filters.
  • Smart Forms Fixes
    Resolved the "Failed to save to ViQube" error in Smart Forms.
  • Form Handling
    Fixed an issue with deleting forms that had applied display settings.
  • Element Deletion
    Improved error handling for certain cases when deleting elements.
  • Data Structure Management
    Fixed an error that occurred when saving the data structure.

Visiology 3.10

Release Date: November 5, 2024
Key Updates
  • New Portal
    Visiology 3.10 introduces a new Portal designed to organize and present dashboards for convenient viewing. It is accessible to both registered users and viewers with whom you want to share specific reports or visualizations.
  • Mobile App
    A new Visiology mobile app has been released to help you monitor key metrics on the go. It allows you to view dashboards created in Visiology 3 on any iOS device (Android support is planned).
  • Self-Service ETL
    The new Self-Service ETL module enables users to independently transform and prepare data before uploading it to the platform. It supports transformations such as adding/removing columns, replacing values, appending queries, formatting, removing duplicates, filtering, and performing SQL-based transformations.
  • Dataset Replication
    To improve fault tolerance and performance, version 3.10 introduces dataset replication management for ClickHouse databases. The platform allows you to explicitly assign datasets to specific servers or define the number of replicas for each dataset.
  • Performance Enhancements
    Thanks to further platform optimizations:
    • Data loading speed has increased by up to 3.5×
    • Query performance during analysis is up to 13× faster
    • Performance has also improved significantly when using complex DAX measures, intricate data models, and pivot tables
DanKo Enhancements
  • Support for 20+ New DAX Operators, including:
    • Text-returning measures
    • Aggregate functions: MIN, MAX, MINX, MAXX used with DATEDIFF
    • IF operator now available for both row-level and aggregate-level calculations
    • TODAY() to return the current date
    • WEEKNUM to get the week number from a date
    • SWITCH to simplify nested conditional logic
    • Text functions: CONCATENATE, LEFT, LEN, LOWER, RIGHT, UPPER
    • Math/trig functions: ACOSH, ACOT, COSH, and more
    • Statistical functions: PERCENTILE.INC, PERCENTILEX.INC
    • Logical/bitwise operations: BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT
    • ISBLANK to check for empty cells
  • More Flexible RLS
    Improved Row-Level Security now supports the use of OR functions in access control logic.
Widget Enhancements
  • New Widgets Available Out of the Box
    • Tree Chart
    • Gauge (Sensor)
  • Automatic Updates
    Data in widgets (both new and existing) now auto-refreshes as fields are added.
  • Filters for Custom Widgets
    For those using custom widgets, API libraries now support the setExcludeFilterSelectedValues method, allowing exclusion filters within widgets.
  • DAX Debug Output
    Widget data requests now return not only the DataFrame but also DAX expressions used—making it easier to understand how data is generated.
Administration
  • Distribution Catalog
    A new page has been added for administrators to manage and download platform distributions.
  • Simplified Migration
    Improved configuration options are now available for migrating full environments from one instance to another.

VISIOLOGY 2.39

Release Date: November 5, 2024
Exporting Large Data Volumes
  • The export timeout and screenshot preparation time have been increased, allowing users to generate accurate data snapshots even when the export process takes longer than usual.

VISIOLOGY 3.9

Release Date: August 27, 2024
Key Updates
  • Regulatory Reporting
    You can now configure a report structure once using a template and receive it automatically by email on a defined schedule. This feature is available to users with the roles of Administrator, Author, or Contributor. All access controls—both at the dataset level and row level (RLS)—are respected when delivering regulatory reports.
  • Smart Forms in Visiology 3
    The Smart Forms module is now fully compatible with Visiology 3 and can be installed independently, without requiring Visiology 2. This makes deployment easier and more resource-efficient.
  • Platform Deployment in Kubernetes (K8s)
    Visiology can now be deployed in Kubernetes, enabling automated deployment, scaling, and management. Users can customize how services are deployed, balance loads based on defined criteria, and enhance fault tolerance. There's no single point of failure (SPOF), and each platform component can run in multiple instances if needed.
DAX Enhancements
  • Period Comparison
    DATEADD: Enables comparison of metrics across custom periods with offsets (year, quarter, month, week, day).
    SAMEPERIODLASTYEAR: Supports year-over-year comparisons with cumulative totals.
  • Reference Dimensions in Measures (RELATED)
    Now supports filtering using values from related tables.
  • Statistical Functions
    Expanded support for standard deviation calculations with STDEV.P, STDEV.S, STDEVX.P, and STDEVX.S.
  • Mathematical Functions
    Improved support for logarithmic functions: LN, LOG, LOG10, and added MOD to return the remainder of division with the sign of the divisor.
Usability Improvements
  • Nested Measures
    You can now use one measure inside another, promoting reusable logic and cleaner, more readable code.
  • Drill Down Behavior
    When using Drill Down, filters from the influencing widget are preserved at lower levels, rather than being reset.
  • Simplified Logical Operators
    Support added for && (instead of AND) and || (instead of OR), making it easier to write DAX expressions.
  • Filter Widget Validation
    The Filter widget now supports only one column. A warning is displayed if a second column is added.
  • Date Part Extraction in Iterators
    New functions to extract Year, Quarter, Month, Week Number, and Day from a date value—available for use in filtering within iterators.
Excel Extension
  • Connector to Visiology Datasets
    You can now access and work with Visiology datasets directly from Microsoft Excel.

VISIOLOGY 2.38

Release Date: August 27, 2024
Faster Authorization
  • Authorization via Active Directory has been significantly accelerated. This improvement is especially relevant for projects involving large user bases (tens of thousands of users).

VISIOLOGY 3.8

Release Date: June 18, 2024
Key Updates
  • Dashboard Export
    Exports now take into account user-selected filters and data access permissions (RLS). Dashboards can also be exported via visApi. Supported formats: PDF, PNG, PPTX.
  • Dashboard Distribution
    Dashboards can now be automatically distributed to stakeholders. There is also a "Send Now" option for manual dispatch.
  • Top-N Values in Widgets
    You can now display the top-N best or worst values based on a selected dimension.
  • Data Loading from Network Storage
    Support added for loading data from network storage, enabling centralized data file management.
Table-Specific Update Scheduling
  • Within a single dataset, tables can now be scheduled for automatic updates at different intervals.
DAX Enhancements
  • Date Arithmetic (DATEDIFF)
    Calculates the difference between two dates in units such as days, weeks, months, or years.
  • AND / OR Filtering
    Support added for both AND and OR filtering logic. OR logic is now available in filters.
  • Statistical Functions (MEDIAN, MEDIANX)
    Median calculations now offer better accuracy in the presence of outliers compared to averages.
  • Mathematical Functions
    New functions: ABS, SIN, COS, TAN, COT, ASIN, ACOS.
Usability Improvements
  • Sheet Reordering
    Users can now rearrange sheets in any desired order.
  • Data Model Guidance
    When creating relationships that don’t fit star or snowflake schemas, the system now warns the user.
  • Widget Configuration Warnings
    A warning appears when trying to add a measure to the X-axis field, if not allowed.
  • DAX Function Case Sensitivity
    DAX functions can now be written in lowercase or uppercase.
  • Clearer Data Type Labels
    When uploading Excel or CSV files, data type names are now displayed in Russian.
  • Improved Measure Editor Window
    The new layout allows you to work in the editor without losing sight of the dashboard or dataset.
Custom Widget Enhancements
  • Custom Icons
    You can now assign unique icons to custom widgets, making them easier to locate.
  • Export/Import Custom Widgets
    Custom widgets can now be exported and shared with colleagues.
Restrictions Removed
  • Filtering Fixed Decimal Numbers Using IN
    Supported in the filter panel, filter widgets, and measures.
  • Date Filtering with MIN / MAX
    Use MIN and MAX to filter date values according to specific conditions.
  • Displaying Data from Unrelated Tables
    Widgets can now show data from multiple tables even without a linking measure between columns.
  • Special Characters in Measure Names
    Support added for using special characters in the names of DAX measures.

VISIOLOGY 2.37

18.06.2024
Mobile application
  • Removal of democrains in a mobile application. Now you can delete demostenses that are unnecessary from the iOS and Android application and leave only those necessary for work.
Convenience
  • A warning about the availability of configured access rights when changing the structure. Now, when the structure is changed, if there is a settings of access rights to the data, a warning is displayed to the user, and he can see which rights are associated with this bootloader.

VISIOLOGY 3.7

09.04.2024
Key changes
  • Access management on the level of data lines (RLS). There was an opportunity to ensure control of access to data at the level of separate lines within the framework of one data set.
  • Publication of dashboard on external resources. There was an opportunity to provide access to dashboard without authorization.
  • License management. The platform administrator can now view the license parameters, a list of activated and inactive users, as well as activate and deactivate users.
Loading and working with data
  • Downloading various dates. The platform supports the loading of various dates. All loaded dates are now automatically converted into a single format, which allows you to easily establish connections between tables and avoid errors.
  • Renaming the table when loading the CSV file. When loading the CSV file, you can now rename the table.
  • Support for comments on SQL request (JDBC). Now, when downloading data using JDBC, you can add a comment in the SQL request. Support for comments is implemented taking into account the dialects of the most popular bases.
  • Data loading. It became possible to cancel data loading in cases where loading takes a lot of time.
  • Connection deletion. The removal of the data source can now be made directly from the list of added sources.
  • View data types after loading the table. When viewing the data of a loaded table, you can now find out which type of data is used in each column.
Data export
  • Export of widgets with renamed columns, lines and measures. The columns, lines and measures that were renamed on the platform now retain their new names in the Excel file exported, which avoids their renaming.
Expanded opportunities
  • New variables for formatting the table. Added new variables for formatting data in the cells of the widget table.
Ease of use
  • Search for users and groups of users when adjusting access. The search for users and groups when setting up access to working areas and sets of data is now carried out when the symbols in the search bar are completed. The system displays the names of groups, names and surnames of users, email addresses, etc., in which the introduced characters are found.
  • Renaming tables and columns. Now you can rename the loaded tables and columns.
  • The search line in the filter by default. In the widget filter, by default, a search line for text data is now displayed.
  • The division of the categories of numbers in the tables. In the visual settings of the widget, the table appeared a switch of the separator in the categories, which allows you to separate the categories of numbers in the cells of the table.
  • Informing about the absence of rights to data in the widget. Now, if you do not have rights to access to data used in the widget, you will see a notification about this instead of visualization of data.
  • Link to the documentation. On the platform, a help button is now available, which opens the reference system, which facilitates the search for answers to the questions that arise.
  • The list of supported characters in the names of columns and tables has been expanded. When renaming columns and tables, special systems can now be used.
  • A more convenient location of the ties view button. Communication button is now located in the top panel of the platform, which facilitates access to it.
  • View long names of columns. Now, when the mouse cursor is hung on the name of the column, a pop -up hint appears with its full name. This is convenient in situations where, for example, in the data model there are tables with long names that do not fit within the borders of the panel, and at the same time differ only in the ending.
Administration
  • Setting up timeouts. The platform administrator can now change the standard values ​​of time-bootage or data visualization, if the values ​​used by default are insufficient to ensure the expected operation of the platform.
  • New version of Keycloak. The platform now uses Keycloak version 23.0.6.

VISIOLOGY 2.36

09.04.2024
Key changes
  • Increased safety and stability of the platform:

    • Improved logistics.
    • Improved data access control.

VISIOLOGY 3.6

30.01.2024
Dashboard setting up
  • Data filtering on a widget. Now the user can configure the filtration he needs entirely for the entire widget.
  • Division of measurement data. Allows you to get the same visual representation, but with details in the form of breakdown by the measurement of interest.
  • Including/excluding the filter. Now you can quickly switch between the modes, analyzing the data both taking into account the selected values ​​of the reference and without.
  • Renaming fields in widgets. Now you can set the necessary names of the fields in widgets without the need for renaming in the model, without the need to use formatting.
Data load
  • Renaming tables and fields when downloading files. Now, if the name of the column or table is not suitable for you, you can rename it and upload data with target names.
  • Update Excel files. Now you can reboot the Excel files for a previously loaded table, if, for example, it is necessary to add/delete the column, or update the data.
Settings of the model
  • Hiding the fields of the model. Now you can hide unnecessary columns to simplify the subsequent configuration of visualizations.
Administration
  • Access to the version of the version and build components of the platform. There was an opportunity at any time to find out the number of the version and build number of each component of the platform, entering the next line in the Internet browser.
  • Changing Realms names in Keycloak. There was an opportunity to change the names of the regions (Realms) in Keycloak, which allows you to replace the name to arbitrary. This possibility can be useful for integration with third -party systems.
  • Increased safety when working with containers. The launch of applications in containers now occurs on behalf of the user who does not have the rights of the administrator, which reduces the risk of potential threats.
Improvements UX
  • The update of the bootrs is now initiated from the drop -down menu of the loaded table, which simplifies access to the parameters of the bootrs if necessary to update them.
  • Copying the current version of the platform. Now you can copy the number of the current version of the platform by clicking on the information button in the lower left corner of the screen.

VISIOLOGY 2.35

30.01.2024
Key changes
  • Memory consumption management. Now you can configure the memory limit, and at the risk of exceeding the limit, the system will not fulfill the request. This will allow you to configure the resource policy for various queries on Viqube, which will significantly increase failure tolerance.
  • Restoration of Snapshot Viqube versions 2.20-2.30. Now you can restore even the unimportant Snapshot Viqube yourself. This is especially true for users who work with versions 2.20-2.30.

VISIOLOGY 3.5

07.11.2023
Key changes
  • Import of dashboard from version 2.x. It became possible to import dashboards from Visiology 2 in Visiology 3. This will greatly simplify the migration of projects from version 2.xx to 3.xx, as well as reduce the cost of the transition from version 2.xx by 3.xx.
  • Download data from Excel files. Added support for downloading data from Excel files, which expands the list of supported data sources.
  • Joint work. The possibilities of joint use of general data sets, dashboards are expanded by adding new opportunities: creating dashboard based on external data sets, transferring dashboard to another working area.
DAX
  • Calculations taking into account the coefficients (constants). Now you can calculate the numerical measure, taking into account a certain coefficient. The ability to take into account various coefficients allows you to get more accurate results for data analysis.
  • Calculation of measures under the condition with verification at the line level (IF). It became possible to check the implementation of a specific condition for each data line using the IF function. The use of IF expression allows you to perform a deeper data analysis, as Measures created using this function take into account various scenarios based on certain conditions.
  • Calculation of the number of unique values (DISTINCTCOUNT). Support for DISTINCTCOUNT, which is used to calculate unique data set, has been implemented. This function can be used, for example, to calculate the average check.
  • Calculation of the number of unique values ​​excluding empty cells (DISTINCTCOUNTNOBLANK). The DISTINCTCOUNTNOBLANK function is supported, which passes empty cells and takes into account only unique non-empty values.
  • Filtering of values ​​with exception (NOT IN). Now the filtering of the values ​​with the exclusion using NOT IN. This function can be used to exclude certain values ​​from the results of requests, filtering data and creating complex calculations based on the presence or absence of certain values.
Loading
  • Loading not all fields from the CSV file. When downloading data from a CSV file, you can choose columns that you want to download. This will not overload the table with unnecessary data and avoid the need to edit the uploaded file.
  • File update. Now you can reboot the data from the CSV file for a previously loaded table, if, for example, there is a need to add/delete the column, or update the data.
  • The updated interface for downloading data from CSV files. We improved the data download interface by making it more convenient.
Export and simplicity of customization
  • Export data of the widget in the Excel file (pivot table). It became possible to export data from consolidated tables, which expands the list of widgets from which you can export data to Excel.
  • Visual settings in UI for user widgets. After creating a user widget, you can now configure its properties in the platform interface. This possibility allows you to configure user widgets without JavaScript knowledge.
Convenience
  • The ability to hide the side panels. Now you can hide the side panels, which frees additional space and does work with dashboard more convenient.
  • Changing the type of widget when setting data. Now you can change the type of widget in the process of setting data, which allows you to understand which widget is best suited for visualizing custom data.
Administration
  • Platform monitoring. The global platform administrator can now monitor the system, which will help to identify the need to balance loads to prevent failures in the system. The received metrics provide detailed information about the current state of the platform, the load level and the use of resources. By default, dashboards of monitoring metric of containers and host are provided.

VISIOLOGY 2.34

07.11.2023
Smart Forms
  • The integration of Smart Forms with Visiology 3. The ability to import data from Smart Forms in Visiology 3 has been added, which will visualize the data collected by your employees on the version of version 3.x. You can import all the data with one click at a time, or transfer individual groups of indicators and measurements. Data can be transferred to different data sets.
ViQube
  • ViQube backup without data. There was an opportunity to copy only metadata when creating a backup of the ViQube database. This allows you to save space on the disk during backup, if the data is not needed and they can be restored from the sources.
  • Complete and partial copying of individual tables. You can create a full or partial copy of individual tables using the API-request.
  • Checking the saved backup. Now you can activate the check of the backup after its conservation. If the audit is included, the system will send a message to the event log in case of unsuccessful validation.
  • Dashboards are now available for work even during parallel loading and backup.

VISIOLOGY 3.4

29.08.2023
Key changes
  • Support for many working areas. On the Visiology platform, you can now create any number of working areas, which allows you to group dashboard on topics, organize the work of different departments in independent working areas, distinguish access to certain data, etc. Access to the working areas and their settings is regulated by the rights of roles of the platform users. You will find more detailed information in the Department of Administration of Workers' Regions.
  • Access to dashboarding when updating data. You can now view or edit dashboard during the data update procedure. This is especially true if the data update takes a lot of time.
  • Refusal of Desktop Designer. The setting of topics of Dashboard is transferred to Visiology Designer. Starting from version 3.4, dashboards are fully configured only in Visiology Designer. Desktop Designer no longer included in the supply. For detailed information about the settings, see the sections visual settings of widgets and the setting of topics.
  • Increased querial processing speeds. Increased speed processing by distribution of data on several nodes (horizontal scaling) has been increased.
Data analysis
  • The possibilities of searching in the Filter widget are expanded. The search line in the widget. The filter now supports special systems, which allows you to search for an incomplete phrase, as well as look for the presence of characters in the text, for example, a question mark (~?) Or a star (~**): Search is carried out according to all data in ViQube. For more detailed information, see the filter section Filter.
  • Export data from the widget in Excel. It became possible to export data from widgets , which allows you to save the obtained data in Excel format for those users who do not have access to the platform.
Data load
  • The ability to edit the SQL request for bootloaders. Now you can add and delete the tables of the table in the text of the SQL questioning of the bootloader, which allows you to not upload the entire table anew if necessary, for example, updating the column set, as well as add the required columns, and do not "break" existing dashboards. the Roaders editing section on the Data Download page using JDBC.
  • Setting up data load using a string of connection. When setting up data loading, you can now set an arbitrary JDBC connection, which allows you to expand the list of supported sources.
Convenience and setting speed
  • The ability to choose an existing source when adding a new bootloader. Now there is no need to indicate the connection parameters every time when adding tables from the same source - it is enough to connect once to the source, and then choose this connection to download new tables, which significantly reduces the time to set up the tables loaded into the model.
  • Assistance in recruitment DAX formula. When writing a DAX formula, the system now tells the names of functions, tables, columns and measures that can be used in this formula, and also displays an explanatory text for each function. This significantly accelerates the spelling of the formulas and reduces errors.
  • Warning about disguised changes. Now when moving to another page, the system warns the user about data loss if Dashboard has not been saved.
  • List of all connections between tables. Added a viewing window of the table of the tables, which allows you to quickly find the necessary connection between the tables in the presence of a large number of connections.
  • New themes of widgets. There are now two pre-installed topics on the platform: Systemic, which is used by default, and Visiology energy. These topics can be used as a basis for creating your own topics.
Administration
  • Logging events. Now the platform is logging in events, which allows you to find and investigate the causes of various incidents caused by various user actions.
  • Creation of backups of data. The platform administrator can now create a backup copy of the data and, if necessary restore it, which will avoid loss of data and user developments.
JavaScript API
Other improvements
  • The location of the input field of the names of the widget for quick access was changed.
  • The design of added widgets is updated.

VISIOLOGY 2.33

29.08.2023
Smart Forms
  • Setting up access rights to attributes of the indicators group. This functional possibility allows you to limit the input and/or reading of attributes of the indicators group . For example, you can limit reading and editing one column in the form of data input for a certain role, which will help prevent unauthorized access to important information and ensure data integrity.
Optimization
  • The data import procedure is optimized. Data imports are faster even in the presence of a large number of elements.
  • The procedure for removing the lines is accelerated when using the API ViQube. It is relevant in the implementation of custom logic of adding and deleting on large volumes of data.
  • Separate caching of requests in GP as part of a request to several GP. Allows you to re-dispute the same data in the cache more often.
  • The list of parameters of logical events is significantly expanded. Now at monitoring of events for example, such additional information is fixed as:
    • IP user address, which allows you to determine exactly who and from which computer has produced this or that action;
    • The name of the variable object, which allows you to track the history of changes in the selected object.

VISIOLOGY 3.3

20.06.2023
Key changes
  • Authorization through external authorization and authentication systems. It became possible to integrate with external authorization and authentication systems, which allows you to automate the process of creating user accounts and the appointment of access rights. After synchronization with these systems, users will be able to enter Visiology using a password and login that they use in the external authorization system.
  • Schedule data update. Automatic data update on a given schedule has been implemented, which allows you to obtain relevant data without the need to regularly update it manually. This is especially convenient for those who often have to update data to maintain dashboard in the current state. With an unsuccessful update of data, the system will inform the user.
  • Support for several data sets. Now users with appropriate roles can work with several data sets. This possibility is necessary when, for example, the presence of several data models with different structures is required. The use of several data sets simplifies work with it - in each set there are only the necessary data, and their updating or removal does not affect other objects.
  • Visual settings in Visiology Designer. To configure dashboard and widgets, now there is no need to install an application desktop version-almost all visual settings were transferred to Visiology Designer. DESKTOP Designer is now necessary only to create and use topics of dashboard. There are also new settings in the visual properties of widgets, which expands the possibilities when creating stylish dashboard.
Work with data
  • View data before loading. There was an opportunity to view the loaded data when loading the table. This allows the user to make sure that he loads the required data.
  • View data after loading. The user can now view the loaded tables in order to understand what kind of data he works with and what changes need to be made to obtain the right results when setting up widgets.
  • Sorting tables. The tables in the field panels are now sorted by alphabet, which simplifies navigation according to the list of tables.
  • Editing sources and bootloaders. Analysts got the opportunity to edit the database connection settings using JDBC. Editing bootloaders avoids the need to create a connection again if, for example, the user password has changed, or you need to change the request. In addition to booters, you can also update sources, which allows, for example, to replace the database for several boots at once.
Work with dashboard
  • Help in creating measures. The system now checks the introduced DAX formulas for syntactic errors. Incorrectly written functions are emphasized by a wavy red line, and when the mouse cursor is brought to such a function, an explanatory text appears. This allows you to easily detect and correct errors.
  • Turning on and off the aggregation by numerical values. Now, for numerical measurement values, you can turn off the aggregation and get the necessary performance. This is necessary, for example, when adding dates.
  • A sign of a breakdown of measure in visualization. If the measure of the measure contains an error, on the contrary, the measure is now displayed in the exclamation mark both in the field panel and in the visualization panel, which allows you to easily find a “broken” measure.

VISIOLOGY 2.32

20.06.2023
Smart Forms
  • Castomization of data collection forms. There is an opportunity to change standard styles of data collection forms. This functionality allows you to create individual styles that will correspond, for example, to your brand, and will also ensure the convenience of perception of information and make the forms more presentable.
ViQube
  • It is optimized by the construction of meta-design during data export, which is especially relevant with a large number of bootrs, groups of indicators, measurements and dependencies between them.
  • Timesout to get a response from ViQube in SSBI. The possibility of setting up a timeout to obtain a response from ViQube in SSBI has been added, which is relevant when working with "heavy" requests.

VISIOLOGY 3.2

11.04.2023
Key changes
  • Role of access model. A role-playing access model for data and components of the platform has been implemented, which allows you to organize a joint work of more users. For more detailed information, see the assignment of access rights (role).
  • User widgets. Now you can create additional means of visualization of data - starting with version 3.2, the platform supports the creation of user widgets .
  • The "Constellation" data model. There was an opportunity to use several tables of facts when building a data model, which makes the constellation scheme in addition to the “Zvezda” scheme. When using this scheme, you can combine data obtained from different sources.
  • Download CSV files. There was an opportunity to download data using CSV files , which expands the list of data sources used.
Settings of the model
  • The backlight of the selected element. The elements selected in the data model are now highlighted in the field, which simplifies their search among other elements of tables.
Dashboard setting up
  • Setting influence on separate widgets. It became possible to disable the influence of the chosen widget on any widgets within the framework of one sheet. This functionality allows you to configure the necessary logic of influence.
  • Changing the type of aggregation. There was an opportunity to configure the necessary type of aggregation for indicators on any visualization without the need to create additional measures.
  • Widget text and text with values. Now you can add an arbitrary text to Dashboard. Also, in addition to the text, it is possible to display the values ​​of the configured lines and columns of the data model.
Elimination of restrictions
  • A number of restrictions are removed, for example, implemented:
    • Sort settings of the table of the table according to another column in the user interface
    • Supporting breakdown not only by string values, but also by integers
    • Password encryption for extension of third -party sources

Visiology 2.31

11.04.2023
Smart Forms
  • Exclusion of automatically adding access rights to the created elements. There was an opportunity to cancel the rights to the created elements of the directory for any role. This allows you to close access to the created elements to users who did not create them.
Reporting reports
  • Sending without authorization. Now it is possible to send dashboard and regulatory reports if the mailing service is configured without authorization. This is relevant, for example, if your organization uses a corporate mail client and authentication is not required. For information on how to configure such a newsletter, go to the postal server.
ViQube
  • Accelerated loading Snapshot. Snapshot loading is significantly accelerated, which provides a faster loading of Snapshot both with primary loading and subsequent ones. As a result, this gives a faster launch of the ViQube database and the entire platform as a whole.
API
  • ViQube data editing via API. A new method has been added to the API ViQube, which allows you to update the line in the table. You will find more detailed information in the data update section in ViQube tables.

Visiology 3.1

31.01.2023
Key changes
  • Support for the calendar and work with dates.
Data load
  • Now there is no need to convert data such as “Numeric” and “Boolean” when loading.
  • Cyrillic and special symbols in table names are allowed.
Settings of the model
  • Now, when deleting a table from the model, the user will be warned and be able to abandon the irreplaceable changes in the model.
  • Now the user is warned of non -working relations of the model, which greatly simplifies the setting of the model.
  • The newly created measure is now highlighted in the field panels, which allows you to quickly find it among other measures, and the formula entering line already contains the name of the measure to understand what measure is edited at the moment.
Dashboard setting up
  • To increase the convenience of setting up dashboard, supporting hot keys when working with widgets has been added.
  • Now you can quickly find tables and fields, the data of which are used in the widget: When choosing a widget in Visiology Designer, the tables and fields, the data of which are used for visualization, are highlighted.
  • You can now sort the data displayed in widgets, by descending or increasing.
  • Automatic alignment is maintained depending on the type of data in the widget-table.
Work in the platform
  • Updated the authorization window at Visiology.

Visiology 2.30

31.01.2023
Key changes
  • New capabilities Smart Forms:
    • There was an opportunity to upload text data from Excel.
    • Now you can configure the system in such a way that it warns the entry operator about unfilled form cells.
    • Access to Excel files loaded using Viloader is now limited.
SQL Backend
  • It became possible to use the MS SQL DBMS when using the ViQube (SQL Backend) mode.
Administration
  • The list of logical information has been expanded.
  • Logging format for Admin and ViQube-Master has been changed.

Visiology 3.0

08.11.2022
The structure of Visiology 3.0
  • Delivery with 2.29
  • Visiology Designer(web) & Desktop Designer
Key advantages Visiology 3.0
  • Visual data model with a table approach (Tabular Object Model). The setting of the model has become much easier due to its visual representation and the ability to configure using Drag'n'Drop.
  • DAX support. Less code, an analyst can independently conduct a deep analysis (a large step towards Self-Service).
  • High-speed internal database based on Clickhouse. Comfortable work of users on billion 'lines without labor costs to build and optimize a high-speed external storage.
Key advantages Visiology 3.0
  • Local authorization and authentication.
  • Data load.
  • Visual settings of the data model.
  • Dashboard setting up.
  • Setting up measures and capabilities of DAX.
  • Publishing Dashboard.
  • Visual Dashboard Settings in Desktop Designer.