3 Replies Latest reply: Jun 6, 2014 7:58 AM by christian juillard RSS

    Scatter Chart - Display Bubble When Condition is Met

      I have defined a scatter chart as follows:

      • X: Longitude
      • Y: Lattitude
      • Z: Bubble Size

       

      Goal: To display bubbles only when the values in one column are NOT NULL or NOT empty (ie display values when a column has numeric value).

      My assumption - I have to edit Z: Bubble Size definition.
      Problem: It seems that whatever I enter into Bubble Size expression does not have effect on a chart - I even left the expression field empty, and still got the same visualisation as when I typed for example "1"

       

      Can anyone explain why is this happening, and help me to display bubbles only when the condition is met (values in one column are numeric values - they are not NULL and not empty strings).

       

      Thanks!