Adding Calculated Fields Together based on Column Name

Can Quicksight create a calculated field that can sum any other calculated field that contains the word “SME Hours” in it?

For example, if I have three columns:
Col 1: SME Hours - AFE
Col 2: SME Hours - OB
Col 3: SME Hours - IB

Can I create a calculated field that would essentially add those three columns automatically since they have the words “SME Hours” in the header name without needing to manually add the three together?

Something like sum(contains(HEADER, ‘SME Hours’))

1 Like

Hi @Clayton_Barton - I believe you are looking for a solution where you want to check with column name not the value and then create a calculated field? Is my understanding correct. If yes, I do not think it is possible in QS as the condition should be apply to the column values. By saying that why you are doing the same, did you data set have dynamic column names? Please give more details around it.

Hi @Koushik_Muthanna - Please provide your expert advise on this.

Regards - Sanjeeb

1 Like

Hi @Clayton_Barton

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.

1 Like

Hello @Clayton_Barton - As per my knowledge, this is not possible at this moment in QuickSight. However, I was just wondering if you can explore the possibility of changing the representation of the data by doing a pivot and see if that helps. Because until and unless you bring the column headers or column names into column values, you will not be able to put any condition to it any other subsequent calculations based on that “text”. Hope this helps!