Scorecards are often used as a grouping method to view the status of a specific application or activity.
Generating scorecard viewlets
See Create a viewlet for more information on generating viewlets. To create a scorecard viewlet, Group by must be used.
The example below can be found in the Sample-OrderTracking repository. A scorecard is being used in this example to display details about activities that have an important severity (ones that need attention). The scorecard layout groups activity names in the first column and their details in the subsequent columns. Each row shows an additional instance of activities with the same name. Activity names are not unique; they are differentiated by their activity ID.
jKQL> Get the number of Activities for the latest week where the severity > ‘INFO’ group by ActivityName, location, elapsedtime, severity order by ActivityName, severity desc show as scorecard
The line, severity desc show as scorecard, within the jKQL query, sorts the results in descending order.