3 Replies Latest reply on Jul 22, 2014 5:39 AM by Tom W

    Filter Date based on Measure

    astha dubey
    astha dubey Jul 20, 2014 10:39 AM

      Hi,

      I have a date dimension and I want to make available only dates which satisfies a criteria based on measure (calculated field).

       

      For eg suppose I have dates for a year but in filter I want to get those dates which satisfies measure > 5

       

      How to achieve it in Tableau ?

      Kindly help

       

      Astha

      • 114 Views
      • Tags:
        • 2. Re: Filter Date based on Measure
          astha dubey
          astha dubey Jul 22, 2014 4:49 AM (in response to Tom W)

          Thanks Tom W, but i was looking for something else. I am looking for a customized filter which acts like by all in other dimension  in Cloud BI. Basically i am looking for something similar to the TOTAL function but the TOTAL function should be applicable only on selective dimensions.Below is a scenario which would explain it in detail

          Scenario:

          Dimensions:Media Channel,Media Type,Campaign, Ad Type,Date

          Measure: Spend

          Calculated field: Total Spend(using the TOTAL function: IFNULL(TOTAL(SUM(Spend)),0 ))

          But i want to display only those dates(dimension) which have Total Spend(calculated measure)>0 values for a particular dimension.say,Media Type.

          • 3. Re: Filter Date based on Measure
            Tom W
            Tom W Ambassador Jul 22, 2014 5:39 AM (in response to astha dubey)

            It's not entirely clear based on your scenario but this might help. Why not drag the Total Spend onto the filters shelf and make it > 0 then pull Media Type dimension onto the filter shelf as well.

             

            You should upload a Tableau Packaged workbook so we can help you further.

             

            Tom