How to get single data from datatable. In my scenario, I need to get sum value and do calculation(divide by 100000). After that, I will put this data into gauge chart.Could Someone help me to fix this problem?
At a high level, you would need to create a service to read rows from the data table and return the value you're interested in. Then within that same service you would need to perform your calculation to get the result, which would then be bound to your gauge widget. Note, there are a number of Get* services that exist within the datatable entity that can be used to return specific rows.
If you run into issues, you can check the Script Log for errors. If you need further assistance, please provide your entities so we can check it.