Now users don't need to figure out where and how to join a table, users can just keep on adding new tables and the join condition will be automatically selected. In case the join condition cannot be guessed, users can click on the table and set the condition
Users can also choose not to add tables manually and just select the columns from other related tables. Insights will automatically guess the joins based on the newly added column
Auto Chart Type
As users go on creating the query, the basic possible visualization will be guessed based on the type of columns in the query results.
Users can also choose a specific type of chart and Insights will guess the data options for the chart. Users can modify any option from the visualize tab as always.
Result Transforms
Previously the transforms were hidden under the 3-dot menu. It has been placed below the summarize section as it is applied after the results are fetched from the data source.
Removed Features / Interfaces
The new visual query builder replaces the previous two query builders added this year. However, it maintains backward compatibility by handling the conversion of the old queries to new ones.
The notebook interface no longer supports the Visual Query Builder as it has been removed. Users can only write SQL queries in the notebook editor.
Table Relationship Editor
Visual Query Builder
Automatic and Better Join UX
Now users don't need to figure out where and how to join a table, users can just keep on adding new tables and the join condition will be automatically selected. In case the join condition cannot be guessed, users can click on the table and set the condition
Users can also choose not to add tables manually and just select the columns from other related tables. Insights will automatically guess the joins based on the newly added column
Auto Chart Type
As users go on creating the query, the basic possible visualization will be guessed based on the type of columns in the query results.
Users can also choose a specific type of chart and Insights will guess the data options for the chart. Users can modify any option from the visualize tab as always.
Result Transforms
Previously the transforms were hidden under the 3-dot menu. It has been placed below the summarize section as it is applied after the results are fetched from the data source.
Removed Features / Interfaces
The new visual query builder replaces the previous two query builders added this year. However, it maintains backward compatibility by handling the conversion of the old queries to new ones.
The notebook interface no longer supports the Visual Query Builder as it has been removed. Users can only write SQL queries in the notebook editor.
Documentation: https://github.com/frappe/insights_docs/pull/1