Total for table - suspect output

Q&A
1

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.

image

1 Like
2

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

3

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
4

Thanks @David_Wong . You are correct, it can be a work around solution.

Regards - Sanjeeb

1 Like
5

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
6

@Sanjeeb2022 @David_Wong thank your for your comments, all clear now.

1 Like