How to execute a client site query on Chart?

I want to generate an interactive chart, which will dynamical change base on a mutilselector of category

@code{

     public class Sales{

          public string StoreID;

          public double FoodSales;

          public double DrinkSales;

          public double OtherSales;

          public DateTime Month;

     }

}

The mutliselector will provide a list of StoreID, and the page will render a stacked area chart based on the store list.

The thing is, if I use a local datasource, the query works fine,

<ChartSeries DataSource=@salesList Query=@QueryData Name="Food" XName="Month" YName="Food" Type="ChartSeriesType.StackingArea">

@code{

    public string QueryData = "new ej.data.Query().where('StoreID','equal','0001')";

}

but if I use a client side datamanager, it won't work.

<EjsDataManager Url="http://localhost:3000/saleList" Adaptor="Adaptors.WebApiAdaptor" Offline="true" ></EjsDataManager>

<ChartSeries Query=@QueryData Name="Food" XName="Month" YName="Food" Type="ChartSeriesType.StackingArea">

My understanding is that the chart can only take the response with format of { "result":[{}{}...{}],"count":6} and bind it, which might prevent it from execute a client side query, while the grid can take response of [{}{}{}...{}] format and do some local fitlering.

My question is, is there a way to work around or would it be a new feature you guys might consider?

 

• Try to reproduce the reported scenario in the above sample

• Share the details if you have done any other customization in your sample.

•  Please share the nugget package version used in your sample.

• Share your dataSource file

   

• Try to reproduce the reported scenario in the above sample

• Share the details if you have done any other customization in your sample.