Aggregation total function not working

[jack_navitas]

Hello,

We've noticed when trying to assign aggregations on pivot tables with a function, it always uses a sum regardless of function we provide.

For example, here is some data with totals listed, where we have written the average function. It uses sum instead.

Please see attached MRT file for demonstration of the issue.

Could this be looked into please?

Many thanks

Jack

[Lech Kulikowski]

Hello,

Please try to use the following expression:
Avg(SSAggregationIssueDS.Audit_Score)

Thank you.

[jack_navitas]

Hello,

I can confirm this works in the Windows version of Dashboards, but on the JavaScript version it does not.

Can this be looked into please.

Many thanks.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue. Please provide more information, which JS designer are you mean - standalone, web version, etc?

Thank you.

[jack_navitas]

Hello, my apologies.

We are including the JavaScript version of the designer on version 2019.4.2 in a web app.

Many thanks

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.
Please send us a sample project which reproduces the issue for analysis.

Thank you.

[jack_navitas]

Hello,

There is an mrt on the OP which has this issue on the JS version of the component.

Regards,

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.

Thank you.