Using Crosstabs: Highlight Tables

Question 1

What are the downsides of using crosstabs to share data? What is a way to modify a crosstab to fix this?

Answer 1

They make it difficult to find outliers or compare between multiple categories. Use a highlight table to do this.

Question 2

In a highlight table, what does your Marks card look like?

Answer 2

There is a measure on Color and Text, and the marks are set to Square

Question 3

How to set the same measure to Color and Text in Marks?

Answer 3

Either drag it in again from Measures pane or Ctrl+Drag from within the Marks shelf

Question 4

Highlight tables are also a good way to help transition an end user from…

Answer 4

Crosstabs with text data to viewing data with color