Jump to content

Trying to use OVER function to count across all rows

Brian Bennett

Recommended Posts

I want to use the over function to count the unique number of weeks in the filtered data set in a cross table.


Uniquecount(Week([DATE]) over All(Axis.Rows) ) is what I think I should use but it isn't working.

This is what Uniquecount(Week([DATE])) is returning-

Name Weeks

Dave 12

John 11

Steve 13


I want the following-

Name Weeks

Dave 13

John 13

Steve 13


Now, I am using this in a calculation on top of that, but this is where I am stuck. I am going to use this to count a number of events per week and I want to count all weeks in the data set, not just those that the individual happended to record an event.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...