1 Reply Latest reply: Jun 15, 2016 4:12 PM by Sunny Talwar RSS

    How to Exclude Null Value in Chart



      How can I do if I want to exclude the null value in specific data field, such as "NAME"?


      I tried two ways:

      1. Choose the "Suppress When value is Null" in Chart Properties for the specific dimension. I am not sure if this is the right way to go.


      2. Add this line in Script : Where not isnull(NAME) . This one is not working...


      Another question is, if I want to exclude null in data fields "NAME", "Time" and "Number". Shall I do "NAME" first, then "Time" thenn "Number". Will the order of (a data field be excluded null values) impact overall values? 


      Thanks for your help in advance,