How to filter data based on two conditions in rows in Tableau

user3186707

I have a simple dataset from which I need to filter and show number of users in the form of bar graph, however since the data is structured in such a way and it is a live connection I cannot make changes to the data source.

What I need is, I need to display the numbers users who is part of 1) Worldwide Global access & 2) Worldwide Region access and when it comes to Worldwide Region access, the following columns i.e. Region and Sub region should be "ALL" and if any one of the columns are not ALL then the 2nd condition is not met. I tired adding a filter and when the 1st filter is added then by default 2nd filter will be False and I cannot use the 2nd filter and vice versa.

I have tried it and I couldn't find a solution to this problem.

The result should be only the following user "AAAA" meets the 2 conditions as user has "Worldwide Global access and Worldwide Region access and also Region and Sub Region is "ALL".

Can someone please let me know how to achieve the desired results.

AnilGoyal

Leave the dimension filter as it is, and use the following calculated field (will return boolean values) as your filter.

calculated field 1 say desired filter (set it to TRUE in filters card)

(If [Access level] = 'Worldwide Region access' then [Region] END) = 'ALL'
AND
(If [Access level] = 'Worldwide Region access' then [Sub Region] END) = 'ALL'
AND
{Fixed [User] : SUM(
If [Access level] = 'Worldwide Global access' then 1 else 0 END) } >0

It should work.

Or if you want these as two separate filters, use these by breaking the conditions in two say filter 2

(If [Access level] = 'Worldwide Region access' then [Region] END) = 'ALL'
AND
(If [Access level] = 'Worldwide Region access' then [Sub Region] END) = 'ALL'

AND first one say filter 1

{Fixed [User] : SUM(
If [Access level] = 'Worldwide Global access' then 1 else 0 END) } >0

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-20

Comments

0 comments

TOP Ranking

Article

How to filter data based on two conditions in rows in Tableau

How to filter data based on two conditions in rows in Tableau

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

pump.io port in URL

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

How to import an asset in swift using Bundle.main.path() in a react-native native module

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

3D Touch Peek Swipe Like Mail

BigQuery - concatenate ignoring NULL

How to how increase/decrease compared to adjacent cell

Make a B+ Tree concurrent thread safe

Emulator wrong screen resolution in Android Studio 1.3

Can a 32-bit antivirus program protect you from 64-bit threats

Svchost high CPU from Microsoft.BingWeather app errors

Double spacing in rmarkdown pdf

Unable to use switch toggle for dark mode in material-ui

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

Google Chrome Translate Page Does Not Work

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

Using Response.Redirect with Friendly URLS in ASP.NET

Bootstrap 5 Static Modal Still Closes when I Click Outside

SSIS setting column with data in Script Component