Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I ran problem where I succeed in implementing Class function into my ratings charts but the highest rating I have in the data set is 10.
The syntax i used is as below
=replace(class(Ratings,2),'<= x <', '-')
How do i edit this pie chart to ends at 8-10 instead ? Since the ratings in the data set is fixed at 10 as the highest
Try putting a condition like:
=replace(class(if(Ratings<=10,Ratings),2),'<= x <', '-')
Does not work unfortunately
I think there is just the else-branch from the if-loop missing, just try it with:
=replace(class(if(Ratings<=10,Ratings, 10),2),'<= x <', '-')
- Marcus
Still doesn't work.. here, u could try it. I uploaded the qvf
Try this...
=replace(class(if(Ratings=10,9.9,Ratings),2),'<= x <', '-')
=replace(class(if(Ratings=10,9.9,Ratings),2),'<= x <', '-')