Reports
Bring data together, analyse it and present it as a report.
ExperimentBalane Office is an experiment: we’re testing how far an office suite can be built with today’s tools. You’re very welcome to try it – but it is not finished software. About the experiment
Reports brings data from several sources together, calculates measures and shows the result as an interactive report – as a frozen snapshot or refreshable.
What the app does today
Data
- CSV, XLSX, SQLite and Balane datasets
- Query steps: filter, group, pivot, unpivot, split columns
- Merge and append tables
- Data view with row search and column profile
Model and measures
- Relationships between tables, model view
- Measures with filter context (BERECHNEN, OHNEFILTER – like CALCULATE and ALL) and time comparisons
- Automatic date hierarchy
Visuals and interaction
- Card, table, matrix, columns, line, combo, waterfall and more
- Cross-filtering with multi-select, drill-down and drill-through
- Slicers, bookmarks, buttons and page navigator
- Conditional formatting, trend and reference lines, report theme
Output
- PDF, printing, PNG per visual, presentation mode
- Freeze snapshots and compare versions
On iPhone and iPad
- A phone layout of its own per report page
- Read with swipes between pages, slicers in a sheet
- Tap to see values and filter, any visual full screen
Checked with automated screenshots at iPhone and iPad sizes, not yet on real devices.
File formats
- CSV
- XLSX
- SQLite
- PNG
- .breport
How it connects
- Links datasets from Sheets and Forms and refreshes them when you choose.
- Publishes query results for Documents and Slides.
- The same in every app: command search with ⌘K, German and English, automatic saving on your device.
Status
Version 0.2.0
- macOSComing soon
- WindowsComing soon
- iOSComing soon
- AndroidComing soon
- WebOpen
Not finished software: expect bugs and changes to the file format. Please don’t keep important data only in the apps, and back up regularly.
