Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?
To change a measure so that it automatically aggregates as an average instead of a sum, you should right-click the field in the Data pane and select Default Properties. In the Default Properties menu, you can set the default aggregation for the measure, such as setting it to calculate an average by default when added to a view.
Which of the following are valid ways to export a dashboard with multiple visualisations as an image?
Only 1 option is correct -
Click on Dashboard in the Menu bar followed by Copy Image
Right click on the dashboard, and choose Copy, then image -Try doing this, you will end up copying just one of the worksheets not the entire dashboard
Click on Worksheet in the Menu bar followed by Export, then choose Image -Again, try doing this. You will end up copying just one of the worksheets not the entire dashboard
Using the floating export worksheet option on the Dashboard -No such option exists
_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.
TWBX is all in one. It contains viz, info needed to build the viz, and a copy of the data source. It doesn't contain extracts of the data but can contain both live and data extracts. Best if want to eliminate the barrier of data access.
Create a .twbx with file-based data sources
1) Select File > Save As.
2) Specify a file name for the packaged workbook in the Save As dialog box.
3)Select Tableau Packaged Workbooks on the Save as type drop-down list.
4) Click Save.
5) The default location is the Workbooks folder of the Tableau repository. However, you can save packaged workbooks to any directory you choose.
The following files are included in packaged workbooks:
--> Background images
--> Custom geocoding
--> Custom shapes
--> Local cube files
--> Microsoft Access files
--> Microsoft Excel files
--> Tableau extract files (.hyper or .tde)
--> Text files (.csv, .txt, etc.)
True or False: It is possible to change the Geographic Role of a dimension
A geographic role associates each value in a field with a latitude and longitude value.
Assigning a geographic role based on the type of location (such as state versus postcode) helps ensure that your data is plotted correctly on your map view. For example, you can assign the City geographic role to a field that contains a list of city names.
To assign a geographic role to a field:
In the Data pane, click the data type icon next to the field, select Geographic Role, and then select the geographic role you want to assign to the field.
When you assign a geographic role to a field, Tableau adds two fields to the Measures area of the Data pane: Latitude (generated) and Longitude (generated).
These fields contain latitude and longitude values and are assigned the Latitude and Longitude geographic roles. If you double-click each of these fields, Tableau adds them to the Columns and Rows shelves and creates a map view using the Tableau background map.