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

    How to Exclude Null Value in Chart

    YUN BAI

      Hello,

       

      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,

      Becky