In tableau, I want to create a calculated field which is based on a filter and outputs an answer also based on a filter
Rica
I created a calculated field based on a parameter with [param1, param2, param3], and I want it to output the number of entries based on another filter [fil1, fil2, fil3].
Should look like something like this...I'm not sure if tableau can do it and if it can, how?
IF [parameter] = 'param1'
THEN [#Entries] WHERE [filter] = 'fil1', 'fil2', and 'fil3' //total entries
ELSEIF [parameter] = 'param2'
THEN [#Entries] WHERE [filter] = 'fil2' //entries based on fil2
ELSEif [parameter] = 'param3'
THEN [#Entries] WHERE [filter] = 'fil3' //entries based on fil3
Obviously that doesn't work, but should work like that????
EDIT: It's actually COVID19 data.
My parameters: Total Cases, Recoveries, and Deaths.
My filter is based on Health Status: Active, Recovered, and Died.
Based on a button, I want to choose 'Total Cases' and my graph of # of cases vs date will show all active, recovered, dead cases. If I choose 'Recoveries', the graph will only show recovered, and if I choose 'Deaths'. it will show deaths data.
AnilGoyal
Given your situation I feel that you need to create only one parameter and one related calculated field.
Create parameter1 for taking inputs say 1, 2, and 3.
create calculated field like this
CASE [parameter1]
WHEN 1 then SUM([field1 related with value 1 in parameter])
when 2 then SUM([field2 related with value 2 in parameter])
when 3 then SUM([field3 related with value 3 in parameter])
END
Just add this calculated field in view and control your results from 'show parameter option.
I have done it sample world indicators data in tableau.. Still if you are having problems, do tell me.
Screenshot of parameter created for your help.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Naming excel files using column values + aliases for those values in python
- Next: Unpacking Comprehensed list without " ' " in f strings
Related
TOP Ranking
- 1
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 2
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 3
pump.io port in URL
- 4
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 5
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 6
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 7
3D Touch Peek Swipe Like Mail
- 8
BigQuery - concatenate ignoring NULL
- 9
How to how increase/decrease compared to adjacent cell
- 10
Make a B+ Tree concurrent thread safe
- 11
Emulator wrong screen resolution in Android Studio 1.3
- 12
Can a 32-bit antivirus program protect you from 64-bit threats
- 13
Svchost high CPU from Microsoft.BingWeather app errors
- 14
Double spacing in rmarkdown pdf
- 15
Unable to use switch toggle for dark mode in material-ui
- 16
java.lang.NullPointerException: Cannot read the array length because "<local3>" is null
- 17
Google Chrome Translate Page Does Not Work
- 18
How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?
- 19
Using Response.Redirect with Friendly URLS in ASP.NET
- 20
Bootstrap 5 Static Modal Still Closes when I Click Outside
- 21
SSIS setting column with data in Script Component
Comments