Hey Community,
To begin with I am new to Quicksight and I have a dataset which I am not able to determine (the correct syntax and hence the calculation). Based on the figure below I am trying to calculate the
- Sum of all the a’s / sum of all the b’s * 100 to get the percentage value.
This is what I am putting in the calculated field: sum({metric_name}=['a'])/sum({metric_name}=['b']) / 100
But there is always an error showing up
Problem: I am unable to use the value ‘a’ in the calculated field.
Note: Is it possible to do it or we need to have separate columns for a,b,c, individually?
Can someone please help me out here.