7.13.0
- Juan Tomás Alonso Nieto (Deactivated)
New features
Devo has added a new tool called Stat count that allows users to compute statistics on the values of the columns in their query results. Read the article
We’ve added a new date picker to both Finders and Free text query, allowing you to select the time range for a query before running it. Learn more here
The Operations over column form has been updated with a new feature that allows you to add nested operations in the same step. Nested operations are available when you create a new column, or aggregate or filter your data. Learn more here
We’ve added two new query operations: weekofyear, weekofmonth, and midnight.
Improvements
In the Free text query, we’ve made some changes to its look and feel, with better positioning of buttons and a new query font.
In Data search we’ve made some aesthetic changes, notably removing the green horizontal scroll bar that was previously at the top of the page. We’ve also changed the font, as well as displaying null values in italics. Numbers are now aligned to the right.
In Data search, when using the Group form, you can now distinguish between time-based and non-time-based groupings.
In the JSON extractor we’ve made some improvements to the column names: the names of the extracted columns are no longer "usrcolX" but the whole path key of the source JSON field. You can also modify the name of the column.
From this release on, the Real division (rdiv, /) and Division (div, \) functions have been updated and they will be used in the same way in both the Data search area and the APIs.
The function Period (period) can be now applied with 3 arguments.
In Data search you can now perform the following aggregation operations over the eventdate column: First (first), Last (last), First not null (nnfirst), Last not null (nnlast), Minimum (min) and Maximum (max).
We’ve removed the Table wrapping option from the menu in Data search as well as the header options.
Union tables in the Finder are now sorted alphabetically.
A warning signal is now displayed alongside a notification whenever you are sorting downloaded data which isn’t 100% in the browser yet. This is because the results are potentially incorrect.
Better feedback in Deviation/Gradient alerts whenever you don’t select a column.
Menu toggling options in Data search now remain open even after selection.
The Panels section has been removed from the left panel.
Bug fixes
In Data search, code fixes have been implemented to remove inconsistencies relating to searches associated with non-existent users and domains.
The navigation pane (left menu) wouldn’t expand when the horizontal scroll bar was not on the left.