Jedi Tricks - Marc not Luke

This list will need further formatting, you might get the idea from this as it stands.

1. Mark Type leverage

Map with simple dot, mark type of bar not on maps, gantt bar will work on Map, conversion of the gantt bars to appear on the map.

Create groups to single out single data points with Other, drop the group on the colour shelf .

Small space visual filter.

Bar's with no axis, just use size only rows. Tableau works it out. nice.Use as filters tab on the dashboard to effect cross sheet filters.

2. Constant Reference Line - avoid the edit on the reference line

Create a parameter, show parameter control. Add parameter to the sheet, no calculation, add the parameter to the level of detail shelf.

Edit reference line on axis, use parameter.Anything in the level of details can be used to create reference line.

Synchronise axis - WINDOW_AVG() can be used against the means calculated

3. hide first item, first item of what from edit table calculation

index() -1

You can also filter table calculations

4. When did the view get updated, or data get extracted? <Data Update Time>

Using the title, insert tag to show when the extract was first made.or updated. Best information shown.

5. Migrate dashboard built against excel to a database without re-building the dashboard.

Export new data connection to a data file, replace connection required. Rename data source to match the one exported.

'Select Saved Connections'

Replace data source with new data source.

6.