Shared datasource across multiple pivot components
Can we have a shared datasource across multiple pivot components. Currently the datasource is loading for each component separately with the same set of data. We want to filter the data in a common dashboard with multiple pivot components and we expect the filter to take effect in each of the component used within the dashboard.
Thank you for the interest in our component. Each new pivot instance connects to the data source separately, yet it is possible to synchronize the instances. Please have a look at the example demonstrating how applying the filter in the first table takes effect to the second one: open JSFiddle. Let us know if you have further questions.
Thanks for your response. We have tried the global filter example that you had provided and it is working fine. I have another question with regards to downloading of csv and ocsv data and assigning the datasource to multiple pivot components.
We noticed that the datasource is loading every time when we load the pivot component for the csv and ocsv datasource. just wondering whether we can download the csv data and hold it in the local array like inline json data
Thank you for your question. As we understand it, you want to load the csv/ocsv data into the component and then extract it in JSON format. For now, such feature is not available. Flexmonster Pivot Component supports the JSON data but it can not be used as CSV to JSON converter. Please find some other tools to convert your CSV to inline JSON. More information about using JSON data source you can find in our documentation – http://www.flexmonster.com/doc/json-data-source/.
Please let us know if you have any additional questions here.