Releases: frappe/insights
v3.2.1
Full Changelog: v3.2.0...v3.2.1
v3.2.0
Features
- Configure number of split values in axis charts
- Copy-paste workbooks, queries, and charts; support duplicating workbooks
- Add "Force Execute" button to query builder to fetch data from db
- Add drill-down support for
pivot_wideroperation
Fixes
- Fixed issue with downloading results on shared dashboards
- [v2] Allow changing aggregation type for total in table charts
- Removed implicit total calculation in funnel charts
- Fixed query title display in union operations
- Uploaded files are now private by default
- Fixed first csv upload issue
- Notify if data source is not selected in SQL editor
- Fixed sample workbook import issue for new sites
- Prevent filters from resetting when chart type changes
Betweenfilter now correctly includes the end date
Full Changelog: v3.1.3...v3.2.0
v3.1.3
Full Changelog: v3.1.2...v3.1.3
v3.1.2
Full Changelog: v3.1.1...v3.1.2
v3.1.1
Full Changelog: v3.1.0...v3.1.1
v3.1.0
Datatable for queries
Created a new QueryDataTable wrapper component to integrate DataTable with useQuery. This standardized UI-based query operations like renaming columns, quick filtering, sorting, loading counts, downloading results, and drill-downs.
Drill-down explorations
For drill-down exploration, query.drill_down(col, row) now creates a new query returning the drill-down results, which is interfaced with QueryDataTable and QueryOperations components, making it a simple and intuitive way to explore data.
Now, you can double-click on a cell to drill down, then group and aggregate using quick actions or perform other operations from the familiar operations sidebar.
drill-down-exploration.mp4
Sharing dashboard with specific users
Previously, you could share a dashboard by enabling public access or by sharing the workbook. There was no way to just share a dashboard with other users without sharing access to the workbook. You can now do so.
Setup data alerts
You can now setup alerts that triggers when data changes.
Minor Features
- Users can now specify schema names to fetch tables, supporting comma-separated values for multiple schemas. (84fc21d1)
- If a table cell starts with
http://orhttps://, it will be rendered as a clickable link. (a55dc9f5) - Users can now configure the number of column values displayed in pivot tables (6e852736)
- In table charts, number columns can now be selected as rows, not just string columns (7d906ba1)
- Set custom y-min and y-max for charts (19b4c4cf)
- Change data_type of a dimension via gear icon (d2fcce63)
- Added fiscal_year_start helper function (7e235bf6)
- Track dashboard views with view logs (df7d33d5)
- Option to overlap bars in charts (3a802968)
- Show read-only indicator in shared workbooks (db325f87)
- Added time_diff helper function for time calculations (539e0807)
Fixes
- Single-line expressions no longer require server scripts to be enabled (91513bec)
- Number charts now show
0instead of empty cards when no rows are returned (3cb61b9d) - Fixed drill downs not working when columns were renamed (8c20800f)
- Fixed drill downs in row charts (d027c0bd)
- Corrected logic for recent view logs (a0ac183b)
- Drill down queries now reset when closing the dialog (2ed2cd36)
- Redirect users to the setup wizard if setup is incomplete (b8dd626e)
- Enable server scripts after Docker setup (ad7bed38)
- Hide users without access in share dropdown (9b9867dc)
- Fix percent_change calculation when the previous value is 0 (0e593966)
- Dashboard filter label updates correctly after save (45329006)
- Correct percentage delta for -ve to +ve transitions (ff39b254)
- Allow changing sort order in queries (fb6977af)
- Fix download issues for query results (1e73e186)
- Ensure compatibility with Frappe v14 (2933008e)
- Fix column selector showing next step columns (fab6ce54)
- Fix 404 error on opening v3 routes (ec3a140c)
v3.0.26
Full Changelog: v3.0.25...v3.0.26
v3.0.25
Full Changelog: v3.0.24...v3.0.25
v3.0.24
Full Changelog: v3.0.23...v3.0.24