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
Jul 27, 2018, 9:50 AM

OR Filter

Hi everyone,

 

I have two dimensions (OrderTotal, SubscriptionType) and I need to count the Number of Records after applying Filter.

 

In theory, my filter should be something like this: OrderTotal > 5 OR (OrderTotal = 1 and SubscriptionType = ''month'')

 

Is there any possibility to apply such a filter in Tableau?

 

Thank you in advance!

4 answers
  1. Simon Runc (Atheon Analytics)
    Jul 27, 2018, 11:00 AM

    hi Bruna,

     

    If you create a field like this

     

    ([OrderTotal] = 1 AND [SubscriptionType] = ''month'')

    OR

    [OrderTotal] > 5

     

    and then bring this field onto the Filter Shelf and set to true, the number of records should now reflect this condition. If you want the >5 to be dynamic, you could also parameterise this value.

     

    Hope that heps

Write an answer...
0/9000