vachon Posted July 28, 2014 Share Posted July 28, 2014 I'm trying to get a caluclated measure to bucket ages (e.g. 13-17, 18-24, etc). I get the buckets to work as they return true or false when drilling into the crosstab, yet the values seem far off and the values across buckets are identical. I'm guessing its not counting the number of boolean "true", but all booleans regardless of their value. Anyone gotten this to work? Link to comment Share on other sites More sharing options...
elizam Posted July 28, 2014 Share Posted July 28, 2014 Can you post the calculation you are using? Link to comment Share on other sites More sharing options...
vachon Posted July 29, 2014 Author Share Posted July 29, 2014 I have tried many many options (including putting it in a derived table, but then I cant have a join), this is the current one:(Year(Today(0)) - "yob" >= 13) AND (Year(Today(0)) - "yob" <= 17)Important to note, our data team actually has YOB as a int, not as a datetime or timestamp Link to comment Share on other sites More sharing options...
vachon Posted July 29, 2014 Author Share Posted July 29, 2014 I got futher. I calulated age and then compared that using an If. Then I used a CountIf summary. I will report back if this worked 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