Analytical Table issue

[Former Member]

Hey Experts,

I want to use an AnalyticalTable in my SmartTable to represent the sum of an amount.

But the table shows always the same number and amount. See picture.

This is the view for the table:

The oData ist correct and the transaction RSRT shows all correctly.

I hope someone can help me.

Regards

[maggie_zhang5]

Hi Müller,

Have you solved this issue?

I have the some issue when set the tableType="AnalyticalTable" in a SmartTable. Actually, I have 3 entries in the DB with different values and I want to sum the value.

However, the analytical table on the UI will display 3 duplicated entries. Please see the attached images. Thanks~

[maggie_zhang5 · Accepted solution]

This seems to be a template issue. Now my analytical table works fine now.

For a analytical table, a key field named "ID" will be automatically generated, you can check this filed in the entity type. But if the template doesn't fill the data for this "ID" field , the it will consider all the data in analytical table is duplicated then always overwrite the previous rows with the last row data.

You can check the response of related batch request:

auto-fill-the-data-for-id-field.png