1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. use of calculate as formula engine

use of calculate as formula engine

i am evaluating use of calculate formula engine for my product and before that i need clearification on following points :

  1. Is it part of standard license?
  2. Is it supported on .Net core ?
  3. How could i parse or evaluate katex/ asciimath string using calculate? 
  4. how could i perform operation on data series like . X=[1,2,3,4,5...] & Y=[2,2,2,2,2....] then if i have formula stored A= X+Y then it shall be evaluated and give result is A=[3,4,5,6,7...] ? Here X and Y will be dynamically pulled by my .net service
  5. How could i perform operation like = SUM( A[]) where A = [1,2,3,4,5....] ?
  6. what are the performance ? like if i need to perform operation on large data says my sesnsor pushing data minutewise for a ye

9 Replies
DG Durga Gopalakrishnan Syncfusion Team October 6, 2021 01:36 PM UTC

Hi Jitendra, 

Greetings from Syncfusion. 

Please check with the below suggestions. 

# 1 : Is it part of standard license? 

We have forwarded this query to sales team. They will contact you at the earliest. 

# 2 : Is it supported on .Net core ? 

Yes, Essential JS 2 UI controls are supported in .NET Core. 


# 3, 4, 5 : performing operation with formulas 

We have used all calculations in source level for rendering chart. Please specify us whether you need to process with the provided values and assign it to chart series data source.  

# 6 : i need to perform operation on large data says my sensor pushing data minute wise for a year 

We have prepared live update sample using datetime axis. Please check with below link. 


Kindly revert us if you have any concerns. 

Regards, 
Durga G 


RM Ryan Madison Syncfusion Team October 6, 2021 01:45 PM UTC

The standard license is required


JC Jitendra Chaudhari replied to Ryan Madison October 6, 2021 01:49 PM UTC

Thanks @Durga and @Ryan

yes actual goal is to bind it to charts like you have in bold report but we can also just generate data and store in our database for other use


JC Jitendra Chaudhari October 6, 2021 06:17 PM UTC

Can we perform calculation with matrices/vectors/array/json arrays ?( may be without named ranges ) and what is the size limit ? 



DG Durga Gopalakrishnan Syncfusion Team October 7, 2021 04:11 PM UTC

Hi Jitendra, 

You can assign the datasource for chart series as array of objects or JSON values. This values will be processed in source level to render series with mapped x and y values. Chart includes more data rendering optimizations to achieve best performance with large data. We have an online demo with 100K points. 


Please let us know if you have any concerns. 

Regards, 
Durga G 


JC Jitendra Chaudhari October 8, 2021 06:45 AM UTC

I guess you havent really understood problem and it is getting dragged somewhere else. 


My questions specific to calculation engine which i want to use as standalone component which will do some data computations as per input data.


DG Durga Gopalakrishnan Syncfusion Team October 11, 2021 11:38 AM UTC

Hi Jitendra, 

Sorry for the inconvenience caused. We hope that your requirement can be achieved by using pivot chart and calculated field features in the pivot table component. Please refer the following pivot chart demo sample.  
  

Kindly refer to the following document to know more details about the pivot chart and calculated field feature.  
  


If this doesn’t meet your exact requirement then kindly share us more details about the same with screenshots/video (if possible) which would be helpful for us to proceed further. 

Regards, 
Durga G

JC Jitendra Chaudhari October 11, 2021 11:56 AM UTC

could we also export the chart shown : https://ej2.syncfusion.com/aspnetcore/PivotTable/PivotChart#/bootstrap5 to pdf ? with all drilled down data ?

If yes could you point towards sample?



DG Durga Gopalakrishnan Syncfusion Team October 12, 2021 02:41 PM UTC

Hi Jitendra,  
 
We have analyzed your query. Based on that, we have prepared sample to export pivot chart as PDF. Please check with below snippets and sample. 
 
Query  
Comments  
Export to PDF  
Kindly refer the following code example to export pivot chart as PDF.  

Code Example:  
<script>  
    document.getElementById("export-btn").addEventListener('click', function () {  
        var pivotObj = document.getElementById('PivotView').ej2_instances[0];  
        pivotObj.chartExport("PDF", "result");  
    });  
</script>  

Also please refer the following document to know more details about pivot chart exporting.  
  
Expand All  
Kindly set the “expandAll” property to “true” to expand all the members. Please refer the following code example.  

Code Example:  
<ejs-pivotview id="PivotView" height="400" showFieldList="true" allowCalculatedField="true">  
    <e-datasourcesettings dataSource="@ViewBag.DataSource" expandAll="true">  
    </e-datasourcesettings>  
</ejs-pivotview>  

Also please refer the following document to know more details about drill down option.  
  
  
  
Please let us know if you have any concerns.  
 
Regards,  
Durga G 


Loader.
Up arrow icon