I have a table that consists of a column for Ages and actual ages for rows.
I created a calculated field that looks like this:
count(if([age]>=12 and [age]<=17) then 1 end)
will get me a count of 2.
Now, it seems that I cannot use this calculated field as a dimension to create a bubble chart for ages 12-17, 18-24, 25-34, etc.
How can I do this? Should I import a column into the data set that creates a column for Ages Segment and populate the rows based on the criteria, if so is this even possible? Is there an easier way?
There are a few things that are going on there. Can you please include a packaged workbook with your question?
You might find Shawn's trusty posting guide useful: Why Your Question Didn't Get Answered