cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

How to count DelayCategories?

dara
New Contributor

โ€Ž11-16-2022 04:23 PM

imageI would like to know how many count of each categories in each year, When I run count, it doesn't work.

Preview file
180 KB
0 Kudos
1 REPLY 1

Debayan
Esteemed Contributor III
Esteemed Contributor III

โ€Ž11-17-2022 11:29 PM

Hi, @Dara Tourtโ€‹ , When you say it does not work, what is the error? You can run count aggregate function.

https://docs.databricks.com/sql/language-manual/functions/count.html

Please let us know if this helps.

Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.