get single data from datatable

Hi @xiaoqw.

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.

Regards.

--Sharon

Hi @TracyVolgola.

Apologies for the delay.

We're not clear on what you need to do.  In your original post you mentioned that you needed to "get sum value and do calculation(divide by 100000)."  Are you actually trying to get an aggregate of all values in a particular column of your datatable which you then need to divide?

Perhaps you can provide us an export of your datatable indicating the column on which you wish to perform the calculation and we can then provide the artifacts you would need to perform calculation and create your mashup.

Regards.

--Sharon