attachedparameters

FreeTrainingTranscript:Parameters2WelcometothisParametersvideo.
YoucandownloadtheExerciseworkbooktofollowalonginyourowncopyofTableau.
WhatisaParameterParametersaddinteractivityandflexibilitytoaworkbook.
Wecanthinkofaparameterasavariableinanequationwhosevaluecanbecontrolledbytheenduser.
Parametercontrols,likeShippingCostCutoffhere,aresometimesconfusedwithFilters,likeShipMode.
However,Filterstrimdownthedataintheview,showingdataonlyforthespecificShipModes.
Parameterssimplyprovideasingleoutputtoanotherelement,suchasprovidingthereferencevalueforthecalculatedfieldonColor.
UsingParametersBecauseparameterssimplycontrolavariable'svalue,theyareonlyusefuloncethatvalueisincorporatedintosomethingelsesuchasafilter,set,referenceline,orcalculatedfield.
Changingthisorphanparameterhasnoimpact,becausethatparameterisnottiedtoanything,it'slikeadjustingadialwithnowiresattached.
ParameterswithFiltersParametersaren'tthesameasfilters,buttheycanbeusedinfilters.
Herewe'relookingatthetop10CustomersbySales.
However,wecouldlettheenduserdecidewhattopnumberofCustomerstheywanttolookatbyusingaparameter.
RightclickonCustomerIDandselectEditFilter–thisbringsusbacktotheFiltersetup.
ClicktotheToptab–weseethisfilterwasoriginallysetastop10,butwecanclickonthedropdown,here,whereitsays10,andchangethatto"Createanewparameter".
Notethatourpre-existingparameterShippingCostCutoffappearsaswell–parametersareworkbook-wideandcanbeusedinmultipleplaces.
We'llcreateanewone,andnamethisTopN,settheMaximumto10,andclickok.
Theparametercontrolautomaticallycomesoutintotheview,andnowwecanadjusthowmanycustomerstoshowintheview.
ParameterswithSetsParameterscanalsobeusedinthedefinitionofaset.
Herewe'relookingatadifferentdatasetalltogether.
InsteadoffilteringtothetopN,wecancreateasetforthetopN.
RightclickonProductandselectCreate>Set,we'llnameitTopProducts.
ClickontheToptab.
Justlikebefore,we'llchoosebyfield,clickonthedropdownbeside10,andwe'llselectourTopNparameter.
Nowwe'llbringTopProductstoColor.
Inthiscase,theparametercontroldidn'tautomaticallyappearintheview,sowecanrightclickontheTopNparameterandsay"ShowParameterControl".
3ParameterswithCalculatedFieldsOuroriginalview,lookingattheshippingcutoff,weusedtheparameterinacalculatedfield.
IfwerightclickonShippingCostColor,wecaneditthecalculationandseehowitwasconstructed.
WehaveasimpleIFstatement–ifouraverageshippingcostisgreaterthanourcutoff,thenwe'llcallthoseorders"high".
Otherwise,callthem"low".
That'sallittakestotietheparametertotheview.
Weusethiscalculationonsomethinglikecolor,andnowtheparametercontrolimpactstheview.
ParameterswithReferenceLinesNotethatthereferencelineautomaticallyadjustswiththecolorastheparameterischanged.
Let'srecreatethatreferencelinetoseehowwecanleveragetheparameter.
ClicktotheAnalyticstab.
DragoutareferencelinetoShippingCost.
ForValue,clickingonthedropdownoffersustherelevantparameters–we'llpickShippingCostCutoff.
AndchangethelabeltoValue.
Nowthatreferencelineissettodisplaywhatevertheparameterissetto.
ParameterTypesAlloftheseexampleshaveusednumericparameters.
However,parameterssupportavarietyofdatatypes.
Backonthedatapane,rightclickandselect"createParameter".
Datatypeoptionsincludefloat(decimal),integer,string(text),Boolean(true/false),date,anddate&time.
Whichdatatypeisselectedimpactswheretheparametercanbeusedandthedisplayformatsavailable.
Our"orphanparameter"isadate,whichiswhythatparameterdidnotshowupindropdownsthatonlysupportednumericalvalues.
ConclusionThankyouforwatchingthisparameterstrainingvideo.
WeinviteyoutocontinuewiththeFreeTrainingvideostolearnmoreaboutusingTableau.