Page 1 of 1
Aggregation total function not working
Posted: Mon Nov 25, 2019 11:14 am
by 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
Re: Aggregation total function not working
Posted: Thu Nov 28, 2019 10:29 pm
by Lech Kulikowski
Hello,
Please try to use the following expression:
Avg(SSAggregationIssueDS.Audit_Score)
Thank you.
Re: Aggregation total function not working
Posted: Wed Dec 04, 2019 10:30 am
by 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.
Re: Aggregation total function not working
Posted: Sun Dec 08, 2019 10:22 pm
by 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.
Re: Aggregation total function not working
Posted: Mon Dec 09, 2019 4:42 pm
by 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
Re: Aggregation total function not working
Posted: Thu Dec 12, 2019 8:46 pm
by Lech Kulikowski
Hello,
We couldn't reproduce the issue.
Please send us a sample project which reproduces the issue for analysis.
Thank you.
Re: Aggregation total function not working
Posted: Tue Dec 17, 2019 1:59 pm
by jack_navitas
Hello,
There is an mrt on the OP which has this issue on the JS version of the component.
Regards,
Re: Aggregation total function not working
Posted: Thu Dec 19, 2019 9:11 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue.
Thank you.