1 Reply Latest reply on Jul 19, 2013 12:44 PM by Mark Holtz

    Help, How to use a calculate field from measure into a dimension for a bubble chart

    steve.s

      I have a table that consists of a column for Ages and actual ages for rows.


      age

      19

      23

      66

      34

      22

      344

      13

      15

      etc.

       

      I created a calculated field that looks like this:

      =# Ages12-17

      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?

       

      Help!