How to Count appearance of containers per company?

[janderhungrige]

Hi,
I want to count the numbers of containers per company. Each data point has a container id, company id, and much more.

If I use

stats count("coreData.containerNumber") BY "coreData.companyID"

 , it somewhat works, but I don't get any returns.

also

stats dc("coreData.containerNumber") as count by "coreData.companyID" 

does not return results.

Is the code correct?

[ITWhisperer]

Try with single quotes around the field names rather than double quotes - alternatively, rename the fields with non-alphanumerics into names with only letters and numbers or underscores.