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,