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 type 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