I am currently trying to display my survey results using waffle chart. My responses are in text format therefore i need to add a new coulmn that will calculate the values of each response, what is the formula for that? I have tried several and nothing works, i am able to calculate one value at the time, when adding new measure to the same column i get an error? Anyone know how to solve that issue ?
I would higly appreaciate as i am stuck with it 2nd day already:(