Pivot Ranks enable you to rank a pivoted dimension by a measure. The reason this is needed is because as default behavior, pivoted dimensions are sorted alphabetically and not by selected measure.
To create a widget with pivot ranks:
1. Select a Pivot Ranked Dimension and Pivot Ranked Measure from the Pivot Ranks category. They will appear in the Filters section. Select which dimension you want to rank (in the example below it is Application), the measure you want to rank the dimension by (in this case # Events), and the time frame you want to rank over.
2. Add Pivot Rank Limit as a filter to limit results.
3. Add the dimension you chose to rank as a pivot.
4. Add the measure you selected.
5. Add a second dimension, a dimension you want to rank the dimension by. This is often the date. For example, here is an Application ranked by # of Events over each day.
6. When finished, click Run.
Here is an example of Application ranked by # of Events over each Application Category.
Note the row and column limits. Column limit can be set to 5 so we get only the top 5 Applications ranked over all the Application Categories.