https://community.databricks.com/t5/data-engineering/how-to-count-delaycategories/m-p/22012#M15031 <P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1174i92FBA3786475E005/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>I would like to know how many count of each categories in each year, When I run count, it doesn't work.</P> Thu, 17 Nov 2022 00:23:16 GMT dara 2022-11-17T00:23:16Z https://community.databricks.com/t5/data-engineering/how-to-count-delaycategories/m-p/22012#M15031 <P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/1174i92FBA3786475E005/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>I would like to know how many count of each categories in each year, When I run count, it doesn't work.</P> Thu, 17 Nov 2022 00:23:16 GMT https://community.databricks.com/t5/data-engineering/how-to-count-delaycategories/m-p/22012#M15031 dara 2022-11-17T00:23:16Z https://community.databricks.com/t5/data-engineering/how-to-count-delaycategories/m-p/22013#M15032 <P>Hi, @Dara Tourt​&nbsp;, When you say it does not work, what is the error? You can run count aggregate function. </P><P><A href="https://docs.databricks.com/sql/language-manual/functions/count.html" alt="https://docs.databricks.com/sql/language-manual/functions/count.html" target="_blank">https://docs.databricks.com/sql/language-manual/functions/count.html</A></P><P>Please let us know if this helps. </P><P></P> Fri, 18 Nov 2022 07:29:28 GMT https://community.databricks.com/t5/data-engineering/how-to-count-delaycategories/m-p/22013#M15032 Debayan 2022-11-18T07:29:28Z