asked on February 26, 2018
Hi,
I'm using Flexmonster with Pentaho Mondrian. I have a product hierarchy, a time hierarchy and multiple measures.
I would like to draw a line chart ( using google charts) where :
1-xAxis will be Time
2- yAxis will be a pre-selected measure values
and each line will represent a product (pre-selected level)
I tried modifying this example: https://jsfiddle.net/flexmonster/8378ax2z/ but I couldn't find out how to do it.
Thanks,
Regards,
Selim
⋅ February 26, 2018
Hello Selym,
Thank you for your question. At the moment, we do not have an example which matches your requirements. However, the necessary behavior can be implemented with the existing set of tools. Please have a look at our Google Charts integration tutorial - https://www.flexmonster.com/doc/integration-with-google-charts/. For your case, you need to write your custom prepareDataFunction() according to Google Line Chart specifications - https://developers.google.com/chart/interactive/docs/gallery/linechart. The prepareDataFunction() gets the raw data from the pivot which allows adjusting the data to any chart's specifications. Here is the example of how to use prepareDataFunction() - https://jsfiddle.net/flexmonster/rzrbpyc2/ and https://jsfiddle.net/flexmonster/aqe5qne8/. Please note that when you use the OLAP cube as a data source the pivot component can return only the data which is displayed on the grid at the moment. Therefore you need to apply the appropriate slice to have all the necessary data displayed on the grid.
Please let us know if the information above was helpful for you.
Regards,
Dmytro
