Hi, I am working on a task: calculating the percentage of employees working in food industry for each country. I tried to develop the code but its not working. please correct my where its mistake. | stats sum("Number of employees") as Total_Emp by Country | where Industry="Food*" | stats sum("Number of employees") as Food_Emp by Country | eval Percent = round((Food_Emp/Total_Emp)*100,2)."%" ... View more