asked 7 days ago
In our use case the data that we need to display is a classic multi dimensional data set. Your pivot table control is a perfect match to our needs. We use an Angular frontend SPA.
Our average user capabilities are not very hight in understanding and managing multi dimensional data sets. Therefore we would like to help them by providing certain views of the data with limited manipulation options.
This means we have to show certain buttons that would configure the pivot table into another arrangement. This way we could create a step by step flow for the user to guide them through to understand the data set and make certain decisions along the way.
In terms of functionality:
Please let us know whether it is possible to use your product in such a way.
Thank you in advance
⋅ 6 days ago
Hello, Daniel!
Thank you for reaching out to us and sharing the details about your use case. We are happy to hear our component matches your needs.
Please find our comments on the requested functionality below:
1) We would like to hide the toolbar completely
Kindly note that the Toolbar is hidden by default. You can enable it if needed or add/remove/rearrange tabs.
More info about managing the Toolbar: https://www.flexmonster.com/doc/customizing-toolbar/.
You can also hide the Field List button from the grid: https://jsfiddle.net/flexmonster/xzohfgqz/.
2) We should be able to "re-slice" the pivot by the frontend API on button click - backend roundtrip is acceptable
It is possible to change the slice using your own UI controls along with our setReport() or runQuery() API calls, depending on the properties that need to be changed. We also recommend checking whether the reportcomplete event happened before further changing the report or its parts.
You can look through the full list of available API calls by the link: https://www.flexmonster.com/api/methods/.
3) Limit the drag-and-drop feature to certain columns and levels of hierarchy so the users cannot too much rearrange the view
Please note that the drag-and-drop feature can be switched off completely if needed. You can also make the gird fully read-only or restrict some of the actions, e.g., filtering, sorting or dragging: https://jsfiddle.net/flexmonster/w2e6srz9/.
4) Limit the summarization and calculation to certain columns and rows
Could you please provide us with more details about this functionality?
5) Edit the numbers in certain cells or put our own input control for editing
The editing feature is available for the flat grid: https://jsfiddle.net/flexmonster/0j0e7exa/.
Regarding our pivot grid layouts, we don't have and don't recommend editing cells that contain aggregated values, as this contradicts the pivoting logic.
6) Single or multiple selection on specified columns or rows
Kindly ask for more details about the use case here as well.
Our team recommends watching our video walkthrough on all main functionality in Flexmonster: https://youtu.be/-OgcJwnR7Mw?si=Ntib0MBr3VKldf8i.
Here is also our Angular integration guide for convenience: https://www.flexmonster.com/doc/integration-with-angular/.
Looking forward to hearing from you.
Please don't hesitate to ask if there are any further questions.
Kind regards,
Solomiia
