2 Replies Latest reply on Jul 14, 2016 10:56 AM by Patrick A Van Der Hyde

    Aggregating based on calculated field

    Aviv Ratzon

      Hi,

       

      I have a data set with coordinates. When I extract the data I want it to aggregated based on rounding up the coordinates, so that two rows of data like this:

       

      Longitude    Latitude

      34.5297493 31.5491038

      34.5236874 31.5412547

       

      Will be joined into this:

      34.52 31.54

       

      I have calculated fields witih the desired rounding but tableau doesn't seem to use them in the aggregation... is there a way to do this?

       

      thanks,

      aviv