Download Free Trial

Draw multiple line charts

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: but I couldn’t find out how to do it.



1 answer

Dmytro Zvazhii Flexmonster 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 – For your case, you need to write your custom prepareDataFunction()  according to Google Line Chart specifications – 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()  – and 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.

Please login or Register to Submit Answer