How to filter/combine data within ChartFX

[mjones]

 

In the past we have always manually loaded the data into theaxis and if the Y value was below a threshold we bypassed the record, now Ihave started just feeding datasets into the chart and was hoping there is asetting in ChartFX that will do the same thing.

 

For example if the SQL was;

Select Store, Sum(Sales) From SalesTable Group by Store;

 

It might return;

 

Store1,  100,000

Store2,  200,000

Store3,   6000

Store4, 4000

Store 5, 190,000

 

Which means total sales is 400,000

 

What I used to do manually was if a store had less than 5%of total sales it did not appear at all on the chart and the total of thosestores would appear as

[CarlosAC]

Hi mjones. To achieve what you want, you should summarize your data in your SQL transact before passing data to the chart object.