Missing data Multi-series Chart

[luiindezon]

Hi,

I am building my first FusionChart via a fabrik plugin. It is great that there is a trial version.

I noticed when using a multi-series chart only data is shown if there is data for all elements. In my example I have 4 people with records set per year. One of the guys (Jan), did not set a time in 2017, but as you can see in the second picture, he did set a time in 2016, 2018 and 2019. However these times are not visible in the first picture, when other people did set a time in 2017. He is only visible in the legend.

Is there anything I can do about this?

Thanks, Frits

[Akash Biswas]

Hi Frits,

 

As we can see that you are using a mscolumn2d chart type, and in one of its series(Jan) the data is null, hence the plots does not appear on the chart according to the first image. Sample for reference : http://jsfiddle.net/dr5aoxv3/

For the second image provided it seems you have provided the dataSource with only one series data, that is for the visible legend Jan.

Could you please modify the provided fiddle with your dataSource and provide us the sample to explain your scenario and your query.

 

Thanks,

Akash.

[luiindezon]

Hi Akash,

Thank you for your reply. I put the second image just to show that Jan has data, but these are not coming up in the first image. Anyway in your sample I see that it should work also with null values.

My source is a mysql query, somehow translated by the visualization plugin of fabrik to XML or Json. This is done by the software, so it is probably more a fabrik issue than a FusionChart issue.

Thanks, Frits

Edited November 8, 2019 by luiindezon

[Akash Biswas]

Thanks for the acknowledgment

[luiindezon]

No worries. Thank you. For now I filled the nulls in my query with a 0 or an other threshold. If your interested, I did manage to have a filter with dropdown on top of the chart, which works pretty well for the user.

https://www.citybiketrip.com/index.php/graph/graph-5k

Edited November 8, 2019 by luiindezon
typo