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.