Sorting: sort on axis click the pill use and drag the header in the legend click a discrete pill and select – – – sort option from menu sort different pills different ways. Continuous pills are sorted using axis or toolbar – discrete dimensions pills full sorting option – Grouping: use header (florida, small office supplies), use data pane field -> create -> group” es. “select Subcategories edit group, include other, use marks grouping”. Groups are metadata definitions, – “visual sets are combination of data like filters and can be used in calculations Additional Ways to Group (with or without parameter): calculation to define groups if – sum([profits])>[threshold] then else end. Using bins “a” “b” Creating Sets: Working with Sets: Ways to Filter: filter shelf, quick filter, in the view (keep/exclude) or legend, conditions (top, by field…) – remove filter by removing pill the Filter Shelf: Quick (Interactive) Filters: layout mode, cascading filters, only relevant values, all values Where Tableau Filters: summary level (normale, sulla dimensione della viz es category) record level – (normale, sui dati che costruiscono la dimensione della viz es profits) data source – Additional Filtering Topics. Top, parameters, index(). Apply to worksheet, context filter Parameters Formatting The Formatting Pane Lines Reference Lines Forecasting Clustering Analysis with Cubes and MDX Calculations Getting Started with Calculations: regular calculation vs table calculation Esempi regular calculation (formulas): Costi: es. sum([sales])-Sum([profit]) Logic functions: Sign: IF sum([Profit])>0 then "Positive" else "Negative" END Profitcutoff: if SUM([Profit])>150000 THEN "High" ELSE "Not high" END
Sorting: sort on axis – click the pill – use and drag the header in the legend – click a discrete pill and select sort option from menu – sort different pills different ways. Continuous pills are sorted using axis or toolbar – discrete dimensions pills full sorting option Grouping: use header (florida, small office supplies), use data pane “select field -> create -> group” es. Subcategories – edit group, include other, use marks “visual grouping”. Groups are metadata definitions, sets are combination of data like filters and can be used in calculations Additional Ways to Group (with or without parameter): calculation to define groups – if sum([profits])>[threshold] then “a” else “b” end. Using bins Creating Sets: Working with Sets: Ways to Filter: filter shelf, quick filter, in the view (keep/exclude) or legend, conditions (top, by field…) – remove filter by removing pill the Filter Shelf: Quick (Interactive) Filters: layout mode, cascading filters, only relevant values, all values Where Tableau Filters: summary level (normale, sulla dimensione della viz es category) – record level (normale, sui dati che costruiscono la dimensione della viz es profits) – data source Additional Filtering Topics. Top, parameters, index(). Apply to worksheet, context filter Parameters Formatting The Formatting Pane Lines Reference Lines Forecasting Clustering Analysis with Cubes and MDX Calculations Getting Started with Calculations: regular calculation vs table calculation Esempi regular calculation (formulas): Costi: es. sum([sales])-Sum([profit]) Logic functions: Sign: IF sum([Profit])>0 then "Positive" else "Negative" END Profitcutoff: if SUM([Profit])>150000 THEN "High" ELSE "Not high" END
Tutorial%20tableau.docx