Christopher Anderson Posted April 1, 2020 Share Posted April 1, 2020 I have created a calculated column that counts the number of dates within specific ID numbers. I need to split that out even further to count per month/year within that calculated column value. Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 2, 2020 Share Posted April 2, 2020 Not quite clear with your use case. If you can elaborate it with examples, I can take a look. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted April 21, 2020 Share Posted April 21, 2020 You can create calculated columns for month and year from date column. Then when counting dates using Over function include month, year columns along with specific IDs so you will get count per month. To get count per year, just include specific Id and year columns in over function while counting dates. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now