Cpb-us-w2.wpmucdn.com



Calculating age: [Birth Date]>DATEADD('year',-DATEDIFF('year',[Birth Date],TODAY()),TODAY()) THENDATEDIFF('year',[Birth Date],TODAY())-1ELSE DATEDIFF('year',[Birth Date],TODAY())ENDConnect to data source in TableauChange Birth Date data type from string to dateMake crosstab, look at data, calculate a few birthdaysWhy is age not a straight mathematical formula?Where we are in the yearLeap yearsCalculate today (TODAY function, talk a bit about dates)Look at DATEADD functionLook at DATEDIFF functionDATEDIFF('year',[Birth Date],TODAY())Oops, doesn't work for birthdays that haven't occurred yetDATEADD('year',-DATEDIFF('year',[Birth Date],TODAY()),TODAY())Take a look at whole calculationDynamically formatting numbers [Measure Selection]WHEN "Quantity" THEN SUM([Quantity])WHEN "Discount" THEN AVG([Discount])*100WHEN "Sales" THEN SUM([Sales])ENDCASE [Measure Selection]WHEN "Quantity" THEN ""WHEN "Discount" THEN ""WHEN "Sales" THEN "$"ENDNew data source, Sample SuperstoreCreate parameter called Measure SelectionData type: StringList of values: Quantity, Discount, SalesLet's look at those three variables on text label (dollar signs and percentages)Write on whiteboardCreate Measure Selected calc field (above)Put Measure Selected on text and toggle through parameter—lost the dollar signs and %!Create Measure Selected PrefixLet's look at both on rows shelfDuplicate prefix and then tweak it to create Measure Selected SuffixOne label? Add all three to Text card and use "…" button to editEdit number formatting for Measure Selected to number with no decimal placesButton!'s make a dash with our super beautiful new vizzes!Feedback button > new viz, calc field "Email Maggie"Adjust borders, font size, shading as you'd likeEdit tool tip to give user instruction and remove command barGo to dashboard: Dashboard > Actions> Add Actions> URLSelect button viz, run on selectmailto:mckonich@wustl.edu ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download