Aggregation total function not working
-
- Posts: 11
- Joined: Tue Oct 15, 2019 4:06 pm
Aggregation total function not working
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
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
- Attachments
-
- dashboard-bad-aggregation-average.mrt
- (80.45 KiB) Downloaded 236 times
-
- aggregation-average-issue.png (125.58 KiB) Viewed 3867 times
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: Aggregation total function not working
Hello,
Please try to use the following expression:
Avg(SSAggregationIssueDS.Audit_Score)
Thank you.
Please try to use the following expression:
Avg(SSAggregationIssueDS.Audit_Score)
Thank you.
- Attachments
-
- Annotation 2019-11-28 232840.png (37.73 KiB) Viewed 3817 times
-
- Posts: 11
- Joined: Tue Oct 15, 2019 4:06 pm
Re: Aggregation total function not working
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.
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.
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: Aggregation total function not working
Hello,
We couldn't reproduce the issue. Please provide more information, which JS designer are you mean - standalone, web version, etc?
Thank you.
We couldn't reproduce the issue. Please provide more information, which JS designer are you mean - standalone, web version, etc?
Thank you.
-
- Posts: 11
- Joined: Tue Oct 15, 2019 4:06 pm
Re: Aggregation total function not working
Hello, my apologies.
We are including the JavaScript version of the designer on version 2019.4.2 in a web app.
Many thanks
We are including the JavaScript version of the designer on version 2019.4.2 in a web app.
Many thanks
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: Aggregation total function not working
Hello,
We couldn't reproduce the issue.
Please send us a sample project which reproduces the issue for analysis.
Thank you.
We couldn't reproduce the issue.
Please send us a sample project which reproduces the issue for analysis.
Thank you.
-
- Posts: 11
- Joined: Tue Oct 15, 2019 4:06 pm
Re: Aggregation total function not working
Hello,
There is an mrt on the OP which has this issue on the JS version of the component.
Regards,
There is an mrt on the OP which has this issue on the JS version of the component.
Regards,
-
- Posts: 6302
- Joined: Tue Mar 20, 2018 5:34 am
Re: Aggregation total function not working
Hello,
We couldn't reproduce the issue.
Thank you.
We couldn't reproduce the issue.
Thank you.
- Attachments
-
- Annotation 2019-12-19 101058.png (96.85 KiB) Viewed 3538 times