Parameters in Tableau

Parameters in Tableau How to Create and Use Parameters in Tableau Back Home Categories Online Courses Mock Interviews Webinars NEW Community Write for Us Categories Artificial Intelligence AI vs Machine Learning vs Deep LearningMachine Learning AlgorithmsArtificial Intelligence TutorialWhat is Deep LearningDeep Learning TutorialInstall TensorFlowDeep Learning with PythonBackpropagationTensorFlow TutorialConvolutional Neural Network TutorialVIEW ALL BI and Visualization What is TableauTableau TutorialTableau Interview QuestionsWhat is InformaticaInformatica Interview QuestionsPower BI TutorialPower BI Interview QuestionsOLTP vs OLAPQlikView TutorialAdvanced Excel Formulas TutorialVIEW ALL Big Data What is HadoopHadoop ArchitectureHadoop TutorialHadoop Interview QuestionsHadoop EcosystemData Science vs Big Data vs Data AnalyticsWhat is Big DataMapReduce TutorialPig TutorialSpark TutorialSpark Interview QuestionsBig Data TutorialHive TutorialVIEW ALL Blockchain Blockchain TutorialWhat is BlockchainHyperledger FabricWhat Is EthereumEthereum TutorialB lockchain ApplicationsSolidity TutorialBlockchain ProgrammingHow Blockchain WorksVIEW ALL Cloud Computing What is AWSAWS TutorialAWS CertificationAzure Interview QuestionsAzure TutorialWhat Is Cloud ComputingWhat Is SalesforceIoT TutorialSalesforce TutorialSalesforce Interview QuestionsVIEW ALL Cyber Security Cloud SecurityWhat is CryptographyNmap TutorialSQL Injection AttacksHow To Install Kali LinuxHow to become an Ethical Hacker?Footprinting in Ethical HackingNetwork Scanning for Ethical HackingARP SpoofingApplication SecurityVIEW ALL Data Science Python Pandas TutorialWhat is Machine LearningMachine Learning TutorialMachine Learning ProjectsMachine Learning Interview QuestionsWhat Is Data ScienceSAS TutorialR TutorialData Science ProjectsHow to become a data scientistData Science Interview QuestionsData Scientist SalaryVIEW ALL Data Warehousing and ETL What is Data WarehouseDimension Table in Data WarehousingData Warehousing Interview QuestionsData warehouse architectureTalend T utorialTalend ETL ToolTalend Interview QuestionsFact Table and its TypesInformatica TransformationsInformatica TutorialVIEW ALL Databases What is MySQLMySQL Data TypesSQL JoinsSQL Data TypesWhat is MongoDBMongoDB Interview QuestionsMySQL TutorialSQL Interview QuestionsSQL CommandsMySQL Interview QuestionsVIEW ALL DevOps What is DevOpsDevOps vs AgileDevOps ToolsDevOps TutorialHow To Become A DevOps EngineerDevOps Interview QuestionsWhat Is DockerDocker TutorialDocker Interview QuestionsWhat Is ChefWhat Is KubernetesKubernetes TutorialVIEW ALL Front End Web Development What is JavaScript â€" All You Need To Know About JavaScriptJavaScript TutorialJavaScript Interview QuestionsJavaScript FrameworksAngular TutorialAngular Interview QuestionsWhat is REST API?React TutorialReact vs AngularjQuery TutorialNode TutorialReact Interview QuestionsVIEW ALL Mobile Development Android TutorialAndroid Interview QuestionsAndroid ArchitectureAndroid SQLite DatabaseProgramming Data Science... Researc h Analyst, Tech Enthusiast, Currently working on Azure IoT Data Science with previous experience in Data Analytics Business Intelligence. Bookmark 7 / 9 Blog from Understanding Data Visualization with Tableau Become a Certified Professional Think about it like this, what if you need a component for your visualization that is not exactly in your dataset. Parameters in Tableau will allow you to provide that value to pass into Tableau.Tableau is emerging as one of the hottest trends in business intelligence in 2019. Looking at google trends, it seems there can be no better time than now toget certified in Tableau.This article covers the following topics:What are Parameters in Tableau?Getting StartedCreating Parameters in TableauUsing the Tableau Parameters in CalculationsParameter ControlUsing Tableau Parameters in your VisualizationWhat are Parameters in Tableau?Parameters in Tableau allow you to use aggregated values that arent available in your data and incorporate these values into your dashboard reports. After creation, end users can control the input to see the results of the effect of the parameter.So, what exactly is a Parameter in Tableau?Any value passed to a program in order to customize the program for a particular purpose is called a Parameter. It could be anything: A string of text, a range of values, or an amount just to name a few.Parameters help you experiment with some what-if scenarios. Suppose you are unsure which fields to include in your view or which layout would work best for your viewers. You can incorporate parameters into your view, your charts and graphs to let viewers choose how they want to look at the data.When you use parameters, you need to tie them to the view in some way:In calculations and calculated fields that are used in the view.To display the parameter control in the view for users to select parameters.To reference parameters in parameter actions.Just theoretically knowing about this concept wouldnt do you any good. S o, in the next few segments, I shall guide you through the process of creating and using Parameters in Tableau.Step 1: Getting StartedYou can start out by opening Tableau and connecting to the Superstore Sample DataSet.1. Drag Order Date to the Columns Shelf and Sales to the Rows Shelf.2. Right-Click the Year Pill on the Column Shelf.3. Go to More Custom.4.When the Custom Date dialogue box appears, click on the Month/Year option from the dropdown menu.You shall end up with a graph along the lines of the following:Step 2: Creating Parameters in TableauSo, the scenario Im trying to create is a what-if scenario. For example. what if Sales were 3% more.To create a parameter, do the following;Go to Analysis Menu and select Create Calculated Field. Alternatively, you could right-click within the Measures pane and select Create Calculated Field from there as well.Now, before creating the calculated field that is going to use our parameter, we have to create the parameter. So on the lower half of the window, there is a section titled Parameter and a link next to it that says Create. Click on Create.Fill in the fields exactly as shown.Click on OK. Your Parameter now shows up in the Parameter box.Step 3: Using the Tableau Parameters in CalculationsNow, for this scenario, we now want to use our parameter and some Tableau functions to create a calculated field to add to our graph to see its effect on our data. While still in the Calculated Field dialogue window, create your calculated field:1. Name your Calculated Field IF_Sales(Calc)2. Formula: [Sales] * (([IF_Sales Param]/100)+1)3. Click on OK. Notice that in the calculation the parameter we created is going to interact with the Sales Measure.Step 4: Parameter ControlComing back to the Tableau main view, you will see your Calculated field in the Measures pane, and the parameter in the Parameters pane of your Data Window. 1. Click on the Parameter IF_Sales Param2. Select Show Parameter Control3. At the top right of your view, your Parameter Control Filter will be displayed.Step 5: Using Tableau Parameters in your Visualization1. Drag the Calculated Field IF_Sales(Calc) and drop it on top of your Sales Axis. As you hover over it, you will notice a transparent equal sign.2. After dropping you will notice Measure Names has now been added to your Colour Shelf, and a Colour Legend is showing both Sales and IF_Sales.3. Because your Parameter control is at 0, your lines are on top of each other.4. Click on your Parameter control, and you will see the two lines appear.These lines represent the running values ofSales from your dataset and yourCalculated Sales simultaneously. And youve successfully incorporated your parameter in your visualization!Parameters are dynamic and useful elements for you to add interactivity and flexibility to a report. It is a versatile tool and can be used in calculations and sets, equally well!Want to know more about Parameters in Tableau? Or maybe other concepts? Edurekas Tableau 10 Certification training is the one for you. It aligned with the Tableau Qualified Associate Level Examination. It is specially curated to help analytics and data professionals create insightful visuals, dashboards, perform scripting, and create Network Diagrams on Tableau to present the data in a much better and insightful manner. The live and interactive course is co-created by industry practitioners and covers critical aspects of data visualization with Tableau, such as conditional formatting, scripting, linking charts, dashboard integration and Tableau integration with R.Recommended videos for you Introduction to Pentaho BI Watch Now Visual Analytics with Tableau Watch Now Data Visualization-How to Make Sense of Data Watch Now QlikView â€" Whats Your Business Question? Watch NowRecommended blogs for you Power BI Developer Salary: Insights and Trends you Need to Know Read Article Tableau vs QlikView Which Data Visualization Tool To Choose? Read Article What are Sets in Tableau And How To Create Them Read Article 3 Ways To Use Dual Axes Charts in Tableau Read Article Quick guide for Tableau Certification: Tableau Desktop 9 Qualified Associate Exam Read Article Power BI Tutorial: Visualizing Data Like Never Before With Power BI Desktop Read Article All You Need To Pick The Right Tableau Product! Read Article How to Build an Impressive Tableau Developer Resume? Read Article What are Excel Pivot Tables and how to create them? Read Article Why Should You Blend When You Can Already Join In Tableau? Read Article Showdown of BI Tools : Pentaho vs Others Read Article 5 Reasons to Learn Tableau A Deep Dive into Tableau Career Opportunities! Read Article Excel Charts: Advanced Data Visualization using MS Excel Read Article What is the Tableau Server and its components? Read Article Power BI Reports : A Beginners Guide to BI Reporting Read Article Introduction to Pentaho Metadata Editor Read Article MSBI vs Power BI: All you need to Know Read Article How to create a Pareto Chart in Tableau? Read Article Uses and Benefits of Pentaho Read Article How do LOD Expressions work in Tableau? Read Article Comments 0 Comments Trending Courses in BI and Visualization Tableau Training and Certification26k Enrolled LearnersWeekend/WeekdayLive Class Reviews 5 (10300)