0 Replies Latest reply: Oct 24, 2017 9:48 AM by Dmitry C RSS

    Counting text fields and displaying it on a chart

    Dmitry C

      Hi.

       

      I need to compare amount of customers with and without an email. In our database email parameter can be email address, or empty. The result should be displayed on a bar chart. Data that seems to me useful:

      1) order date

      2) email address

       

      for now I'm stuck on this: count(if(customerEmail<>0,1,0)) but this not working. The data on the chart is incorrect.