Sum Column Values in Table Row

Question & Answer
,
1

Hi,

I’m trying to create a health score for each of client our company has. I have a table visual that looks something like this:

Client | Overdue Points | Review Points | NPS Points | Login Points
ABC, Inc | 25 | 20 | 20 | 25
ACME, Inc | 10 | 25 | 15 | 20

Each of these point columns are calculated fields (some with pretty complex formulas). Does Quicksight offer a way to easily sum multiple columns in a table into another column? I’d like to add a Total column that added each point value column up for each client.

I thought this would be the easy part after finally creating all the formulas for each column, but when I tried to create another calculated field that simply added each calculated field together I received the error message: Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.

Any advice would be greatly appreciated.

Thank you,
Matt

2

Hi,

You can try it with write all the formula once in a column where you want to sum up.
This may help you.

Regards,
Naveed Ali

3

Hi @mashley806,
It’s been awhile since we last heard from you. Do you have any additional questions regarding your initial topic or did Naveed’s response help with a solution?

If we do not hear back within the next 3 business days, I’ll go ahead and mark the solution.

Thank you!

4

Hi @mashley806,
Since we haven’t heard back from you yet, I will go ahead and mark this as solved. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information.

Thank you!