I want to draw a scatter chart with calculations involvinf if statements ,the problem is when i am using if statement the i am not getting any data to display although when i am using a simple expression invoving sum or avr i am able to view the data ,so my question is that can't we use if statements in scatter chart.
Thank you Gysbert fot the tip next time i will try to explain my issue as clear as possible,i was trying different different option in scatter cahrt and now i am able to get the desired scatter chart..but the problem is when i am trying to make it as a trellis chart as well in this am not able to get the chart,plz check if
