2 Replies Latest reply on Jan 27, 2016 7:09 AM by Steven Laphorn

    Help with using calculated field with parameter as filter

    Steven Laphorn

      Hi, I'm having a lot of issues trying to use a calculated field as a filter.


      I've attached the raw data.


      What I want to do is as follows:


      Calc 1:                Create a calculated field for:     sum(addtocarts) / sum(clicks)        formatted as %

      Parameter 1:      Create a parameter with a slider using Calc 1.  This should have a min of 0 and a max of the max of Calc1, and a step change of .1%

      Calc 2:                (Calc1 < Parameter 1)


      Calc 2: place in Filter shelf, filter on True


      The viz will be a scatter plot of Calc1 and Clicks.  And as the parameter slider is adjusted I want the colour to change on the viz marks.  So, as you change the parameter slider I can see what marks fall into that.


      I'm getting errors when putting Calc2 into the filter shelf.  I understand that there are limitations on what you can put in the filter shelf, so I've tried some alternatives outlined here:


      Adding Calculated Field to Filter Shelf | Tableau Software


      But none of these give me the end result I'm looking for.  I'm sure this is possible!


      Any help much appreciated