1 Reply Latest reply on Jul 31, 2018 10:13 AM by Michel Caissie

    Complex Filter Data (Exclude all related by secondary dim) question

    Jamie Stooke

      Hi,

       

      My problem is virtually identical to Complex Filter data (exclude) question .

      That works fine when Id is a used discrete dimension but i need the countd(id).

       

      Using the example from the linked post:

      Id    Type

      1     a

      1     b

      2     a

      2     c

      3     e

      3     f

      3     g

       

      I need:

      Exclude Type 'a'

      Countd(id)

      1

       

      Exclude Type 'b'

      Countd(id)

      2

       

      Exclude none

      Countd(id)

      3

       

      I'd normally do something in SQL but the dataset in question is pretty beefy so a tableau solution would be awesome.

      Thanks