All the pill options are available by right-clicking on a pill. There are some differences between Continuous and Discrete pill options. The following screenshot shows the options available for a Continuous pill:
Among the most important options, you'll find the following:
- Filter...: A shortcut to the pill in the Filters shelf that opens the Edit Filter window
- Show Filter: Automatically puts the pill in the Filters shelf and displays the quick filter
- Show Highlighter (only for Discrete pills): Opens the Highlighter card, which allows you to highlight a specific value, as shown in the following screenshot:
- Sort (only for Discrete pills): Opens the Sort window where you can change the sort order of the values. Here's an example of an ascending Sort based on sales:
You can also transform the pill into a Dimension, an Attribute, or a Measure and, if the pill returns a number, you can choose between Discrete and Continuous. If the pill is a Measure, you can also create Table Calculations, but that's for another chapter.
Next, we'll see the options available in the Worksheet menu.