I have condition like- if (result =2 ,'<40 marks')
if (result=3,'>50 marks')
if(result=4,'>60 marks') i have given this in the calculated dimension in the pivot chart. I want to eliminate that many if I want to do that using the set analysis or some functions.Please help me out.
I need to calculate the percentage also like count of <40 marks/Count of total marks like that and need to calculate the average too.Please let me know as soon as possible.
if Result is a field in your data model then in your script you can use the same "if else statement" to create a new field and use that field in your chart or you may check class function that takes an "input number" and "interval number" and then displays the result as a Range with upper limit and lower limit between which the input number falls in. like this. 10<=x<20
if [result] is a field name, then I suggest to calculate that dimension in script (using nested If or Pick/Match functions). That would eliminate need for calculated dimension and also enable you to easily calculate share %: