Dynamic Column to change measure

posted on April 6th, 2022

Answered

sudhasmsa asked on April 6, 2022

Hello,
Our team has been using flexmonster for awhile and it does a great job thank you for that.
I have the following data structure
----------------------------------------
Name | Math | Physics | Chemistry
-----------------------------------------
Abc | 20 | 24 | 25
Xyz | 21 | 25 | 26
------------------------------------------

Would like to create a pivot with Dynamic column called Subject, which contains Math, Physics, Chemistry. Something like https://jsfiddle.net/s5h3yr7q/1/ (*Note changed data structure to give an example). We could format our data just like in the fiddle before feeding to flexmonster but we are trying to avoid that as we have large data set.
Could you please let me know if there is any option in flexmonster to achieve this?

Thank you

3 answers

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ April 7, 2022

Hello, Sudhasmsa,

Thank you for reaching out to us.

We are glad to hear that you enjoy using Flexmonster!

Achieving a dynamic column with the described data structure is only possible through preprocessing the data set, just as you did in your JSFiddle.

Aside from that, since you have mentioned you have a large data set, Flexmonster provides two options for handling and analyzing the big data sets:

Flexmonster Data Server:
Flexmonster Data Server 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. The Data Server significantly reduces data loading time and enables analyzing large datasets.
For Flexmonster Data Server, it is possible to set a data refresh time interval via the DataRefreshTime option. This way, Flexmonster Data Server will refresh the data with the specified rate. For example, you could configure it to refresh the data every several minutes. Please see our configuration guide for more details.
Custom Data Source API:
Another option is to implement the custom data source API, a protocol developed by our team that the Flexmonster Data Server is built on.
The custom data source API protocol provides a single set of requests and responses for connecting Flexmonster to any data source. This provides full control over how the data is processed, and you could create any desired data processing layer and manage how the data is refreshed.

Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public

sudhasmsa ⋅ April 8, 2022

Thank you Nadia for the quick response.

We are preprocessing the data to get around the issue.

Thank you.

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ April 11, 2022

Hello, Sudhasmsa,

Thank you for your feedback.

As always, you are welcome to write to us in case further questions arise.

Kind regards,
Nadia

Dynamic Column to change measure

3 answers

Please login or Register to Submit Answer