Qrvey Version 5.10

Release Date: 2021-05-05

New Features and Enhancements

Click here to access demo videos of some released features.

Data Preparation

• DR-2490 - Access To All Flattened Record Columns: We enhanced the flat data transformation so you now have access to all columns of a flattened record when loading data.
• DR-2482 - Flattening Multiple Arrays on the Same Record: You can now flatten multiple arrays on the same record when using the flat data transformation.
• DR-2484 - Improved Data Type Identification: The algorithms to identify the data type of columns in CSV and JSON files have been improved to make the dataset creation process faster and easier.
• Watch video QV-12663 - New Menu for Data Source Pills: You can now add, switch, and edit a Data Source’s connection from the Data Source Pill located in the Dataset Page.
• Watch video QV-12904 - New SQL Connection Screens: You can now select the Database when configuring a connection, making it easier to create tables or SQL queries.

Data Analysis & Automation

• AN-9955 - Display All Values on Filters: Previously, only 1000 values per column were displayed when creating a filter. Now, You can see and select all existing values of a column.
• Watch video AN-12682 - Relative Dates - Calendar and Date Ranges Support: You can now create a relative date filter as a calendar base or rolling base. A calendar-based approach is when the date ranges are calculated, taking into account the start and end date of a calendar's period. The rolling base is expressed relative to the anchor date and automatically shifts forward day by day without considering calendar periods.
• Watch video AN-12683 - Relative Dates - Exclusive Date Ranges Support: You can now choose between inclusive or exclusive ranges when creating filters.
• AN-12527 - Edit or Remove Filters From the Chart Panel: Filters that apply to charts panels can now be edited or removed directly from the floating popup panel that shows them on the panel.
• Watch video AN-11056 - Trend Charts - Sparkline: You can now create Line and Bar charts inside table cells to see trends in your data without leaving the table visualization.
• AN-12654 - Table Columns Reordering: You can now organize the table’s columns by dragging and dropping them directly from the column header.
• AN-9833 - Conditional Formatting in Crosstab: You can now use conditional formatting in crosstab to highlight cells that meet predefined conditions.
• AN-12656 - Change Font Color in Crosstab: You can now change the colors of crosstab headers and fonts directly from the chart builder in the “Style” section of the configuration panel.
• AN-9962 - Chart Axis Range Configuration: You can now set a fixed min and max value for the value axis range of any X/Y chart.
• AN-9837 - Logarithmic Scale Type: You can now choose a logarithmic scale for the value axis of X/Y charts.
• AN-9932 - Bar Width and Spacing: The visualization of charts containing bars has been improved by the implementation of automatic adjustments in proportion to the available space in the chart, also you can manually adjust the bar width percentage to customize the size of the bars.
• AN-9944 - Fit Chart to Panel: You can now choose the "fit to size" option to automatically fit a visualization to the size of its panel.
• Watch video AT-7946 - Automatic Column Links: Columns can be pre-configured in the Dataset Design step to link to a specific URL. This establishes an automatic Go To URL link whenever the column is used in any analytic visual. The URL can later be edited both from Page Actions and Dataset Design.
• AT-8425 - Data Page Shortcut: You can now access Dataset Design directly from the Page, Report, and Chart Builder by clicking on shortcut icons of the builders’ data panel.
• Watch video AT-7680 - Get Widget Configuration: We have added a feature to obtain the widget configuration code for Page Builder, Report Builder, and Page View widgets from the respective widget UIs inside Qrvey Composer.

General Tweaks & Bug Fixes

• ADMIN-4554, ADMIN-4555 - Value List filters and chart themes are now supported in Content Deployment.

• QV-13329 - View Data For PostgreSQL VIews: When a user created a connection with PostgreSQL selecting a “View“ from a custom schema, the “View Data” option showed an error, and the data did not appear. This has been fixed.

• QV-12968 - Joined Datasets Cannot Be Loaded Using Special Character "-": When a user was creating a Dataset with multiple data sources, but one of the datasourceId value contained the "-" character (example: "datasourceId": "rKnu3U-w6"), the load or reload processes generated an error. This has been fixed.

• QV-12905 - Datasets - Apply and Discard Buttons Disabled: When a user set a "Security Column" in an Active Dataset and went to the Dashboard without applying changes, when the user returned to the Dataset the "Apply" or "Discard" buttons were disabled, and the security column was not saved. This has been fixed.