0 Replies Latest reply on Nov 22, 2013 7:40 AM by Nambi Sridharan

    DB or data related question more than a Tableau one

    Nambi Sridharan


      Hello folks

      Am a realtive newbie and I am working with a DB that is structured like this:

      Dimensions:

            serials  - contains about 1000 unique serials

            Field    - Has about 14 unique "fields" under this dimension. Each serial has this set of multiple fields each with a unique value per day.

            Date    - running date. One per day.

       

      Measures:

          Measured_Value - This has the entries for "measured_value" for each field, one per day. So each of the 14 fields has a unique value measured per day and we have about a year worth of data.

       

      The visual built for display is great. Just plotted the fields using "line" marks day-over-day for all serials. Simple and effective. The end user can eye-ball very effectively outliers on each field.(outliers are not seen in the twbx attached as it contains only a snippet of data)

       

      Now the request:

      The end-user wants to filter a set of serials if they meet certain criteria:

      example: Filter just the serials where Probe1(day2) > Probe2(day1) AND CHT > 50

      or

      Filter just the serials where MP>=15 OR PHAP > .23

       

      My hope is to create a set of serials that meet these criteria that can then be called up by writing a set of these conditions.

       

      I am not sure how to do this as I am unable to narrow down to each field and its measure for creating calculations.

      Can someone point me to a method that this can be done. A packaged workbook is attached.

      much regards