Tableau

Table of Contents

Overview

brew cask install tableau-public

There is a hard limit:

How-to

Use Level of Detail Expressions

{FIXED [Department] : AVG([Sales])}
the average Sales per Department
{INCLUDE [Item] : AVG([Sales])}
the average Sales at the level of detail defined in the view but includes the dimension Item
{EXCLUDE [Category] : AVG([Sales])}
the average Sales at the level of detail defined in the view but does not include the dimension Category

Consider a dataset like:

{"Developer": "foo", "Language": "Python"}
{"Developer": "foo", "Language": "R"}
{"Developer": "bar", "Language": "Go"}

Use LOD Expressions to answer How many users use how many languages?

Create a dimension of Top N and Others

First off, it's better to create a parameter for adjusting N:

You can test whether or not to do correctly by putting the set and the field on Row Shelf:

Resize pie charts

There appears no obvious way to adjust the pie chart size. Instead, we can adjust the view size as follows: