Show as specifies how jKQL query results are displayed in a viewlet. Show as goes at the end of the query, followed by the desired chart type. The default is: Show as Table
Viewlet types
All show as viewlet chart type options are as follows:
- column chart (“colchart”)
- bar chart (“barchart”)
- line chart (“linechart”)
- pie chart (“piechart”)
- stack chart (“stackchart”)
- geo map (“geomap”)
- scorecard (“scorecard”)
- area chart (“areachart”)
- summary (“summary”)
- topology (“topology”)
- anomaly chart (“anomalychart”)
- compare table (“comparetable”)
- histogram (“histogram”)
- table (“table”)
Examples
jKQL> Get activities fields Apdex(ElapsedTime, 3sec,4.5sec) group by ActivityName, location order by ActivityName show as scorecard
jKQL> Get relatives show as areachart
