Hi,
i’m wondering if Total for the “Average” field which utilizes avg function could be sum instead of average? I’d like to see the sum (16.04 + 8.97 + 19.71 + 10.75) instead of generated value. Is that doable in QS? Thanks in advance.
1 Like
Hi @Rad - Thanks for posting this question. I believe at present it will give the average in total and you can not edit it. Let’s hear from other community members.
Hi @David_Wong @EnriqueS @Biswajit_1993 - Any advise on this.
Regards - Sanjeeb
The aggregation used for the total is the same as the aggregation used in the individual rows. You can still create a calculated field for the sum but you’ll have to show it in a separate visual, e.g. in a KPI.
2 Likes
Thanks @David_Wong . You are correct, it can be a work around solution.
Regards - Sanjeeb
1 Like
Actually I think may be able to do something like this:
sum(avg({measure}, [{category}])
Calculate your average this way and put it in your visual.
1 Like
@Sanjeeb2022 @David_Wong thank your for your comments, all clear now.
1 Like