Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.

Dynamically pull data for expanded column

Answered
Niraj Jasani 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.

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 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:

  • CSV and JSON files
  • MySQL databases
  • Microsoft SQL Server databases
  • PostgreSQL databases
  • Oracle databases
  • Microsoft Azure SQL databases

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

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 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

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 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

Please login or Register to Submit Answer