How can I use the chart to show top 100 of a json list?

[LMN007]

I have a json list like this:

package: [{duration: 100, name: a}, {duration: 90, name: b} ...]

and I want to show the top 100 durations of the package list in the chart. What is the search command? Would you help me, please? 

[ITWhisperer · Accepted solution]

| spath path=package{} output=package
| mvexpand package
| spath input=package
| sort 100 -duration
| table name duration

[LMN007]

Thank you!