Creating a KPI text table
Key performance indicators, or KPIs, are metrics that indicate how well an organization is performing against its objectives. KPIs are typically represented as easily understandable color-coded symbols in a dashboard. For example, a red circle could mean that area is not meeting objectives, while a green circle does.
In this recipe, we will show the top 10 New York restaurant cuisines based on their average inspection scores from 2012-2016 in a text table with KPIs.
Getting ready
To follow this recipe, open B05527_02 – STARTER.twbx. Use the worksheet called KPI Text Table, and connect to the DOHMH New York City Restaurant data source.
How to do it...
The following are the steps to create a KPI table:
From Dimensions, drag Inspection Date to the Filters shelf.
When prompted on what to filter, choose Years.
In the next window, under the General tab, select all years except 1900.
From Dimensions, drag Inspection Date to the Columns shelf.
From Dimensions, drag Cuisine Description...
