Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Aug 26, 2015, 4:25 PM

unable to drag calculated field to filters shelf

Hi,

 

I have a calculated field,

 

{Exclude [Subject]:Count({ INCLUDE [Subject_visi] : COUNTD(SV_IIP_ID) })}

 

I am unable to drag this field onto filters shelf.how to make this as a filter

 

Thanks,

Aditya

1 answer
  1. Rody Zakovich
    Aug 26, 2015, 4:43 PM

    Hello Aditya,

     

    In order to add this onto the Filter Shelf, it needs to be aggregated

     

    Depending on your situation, you could wrap an ATTR around it

     

    ATTR({Exclude [Subject]:Count({ INCLUDE [Subject_visi] : COUNTD(SV_IIP_ID) })})

     

    Or some other regular aggregate. But it needs to be aggregated in order for you to filter.

     

    Regards,

    Rody

Write an answer...
0/9000