Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Is there a way to check if data is empty?

Answered
Randolph Kepplinger asked on March 18, 2020

Hello,
i would like to check if returned data is empty, i.e. we get the csv headers but no entries.
can i access the data in report and do something like getRowSize() / getNumberOfRows() and if this is 0 act on it?
Now i do have an empty chart, but i would like to tell the user “no data”.
 
Also accessng the data from the API would be very useful…so is there a way to do something like getValue(row,column)?
 
kind regards
 
Randolph
 

5 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 18, 2020

Hello, Randolph,
 
Thank you for contacting us.
 
We would like to kindly draw your attention to the showEmptyData: false property of the options object. It allows displaying the alert instead of an empty chart/grid in case only headers are defined in the specified CSV file.
Please find out more about options object and its properties (including the showEmptyData one) in our documentation.
 
Talking about getting the values, our team would like to kindly inform you that Flexmonster is designed to visualize data; therefore, it does not provide an appropriate API allowing get data and manipulate it.
 
We hope it helps.
 
Please contact us in case any additional questions occur on this point.
 
Kind regards,
Illia

Public
Randolph Kepplinger March 18, 2020

Hello Illia,
 
showEmptyData: false
is set – but no error is triggered.
 
kind regards
 
Randolph

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 19, 2020

Hello, Randolph,
 
Thank you for your feedback.
 
We would like to kindly inform you that the issue is not reproducible on our side.
 
We recommend checking out an example we have prepared for you. It uses the following CSV file with only headers specified.
If it does not help, we suggest providing us with a sample project where the issue can be reproduced so we could investigate it on our side.
 
We are looking forward to hearing from you.
 
Best regards,
Illia

Public
Randolph Kepplinger March 19, 2020

Hello Illia,
 
thanks for your fiddle.
 
Please have a look at the following one
 
https://jsfiddle.net/uzcqywnj/
 
here you can see how to reproduce this.
 
kind regards
 
Randolph

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 20, 2020

Hello,
 
Thank you for providing us with an example.
 
We would like to kindly explain that the showEmptyData property should be used instead of showEmptyValues in order to achieve the desired functionality.
Also, it should be specified as a property of the options object instead of grid or chart.
We have changed an example you have provided us with so it works as expected.
 
We hope it helps.
 
Please contact us in case additional questions occur.
 
Kind regards,
Illia

Please login or Register to Submit Answer