asked on May 6, 2024
Hi team,
We have existing pivot report for few columns and rows. What I wanted was that when user expands certain column then we get data for that specific row/column combination at that time.
For e.g. if user expands year 2024 and country US and State NJ then we get more details for cities columns for that combination on expansion. This way we don't have to get full data set during initial page load.
If you have some docs or even better a live example of this scenario it would be great.
⋅ May 7, 2024
Hi Niraj,
Thank you for reaching out to us.
Kindly note that Flexmonster provides data sources that do not require getting the whole dataset on the initial page load.
If you want to work with a large data set, we recommend using Flexmonster Data Server - a special server-side tool implementing the custom data source API. It is responsible for fetching data from a data source, processing, and aggregating it. Then, the data is passed to Flexmonster Pivot in a ready-to-show format. For instance, the Data Server will only pass the data that is needed for the specific expanded column. It significantly reduces data loading time.
Flexmonster Data Server supports the following data sources:
The detailed guide you can find in our documentation: https://www.flexmonster.com/doc/getting-started-with-data-server/
Alternatively, you can implement the Flexmonster custom data source API – our custom communication protocol that allows you to transfer already aggregated data from a server to Flexmonster Pivot. Like Flexmonster Data Server, data is passed to Pivot in a ready-to-show format.
We recommend checking our guide on choosing the best data source for your use case: https://www.flexmonster.com/blog/how-to-choose-the-best-data-source-to-use-with-flexmonster/
Also, could you please provide us with details on your data source? It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ May 21, 2024
Hello,
Hope you are doing well.
We were wondering if you had a chance to check the suggested approaches. Please let us know if it works for you.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ May 28, 2024
Hello Niraj,
Hope you are doing great!
Just checking in to ask if you had a chance to check Flexmonster Data Server and the custom data source API. Please let us know if any questions arise.
Looking forward to hearing your feedback.
Kind regards,
Nadia
