Grafana is an incredibly useful open-source visualization and analytics software. It allows you to query, visualize, alert on, and explore your metrics no matter where they are stored.
PowerQueries provide a rich set of commands for transforming and manipulating data. You can filter, perform computations, extract new fields from your logs on the fly, and create groupings and statistical summaries. You can freely mix and match commands, to create sophisticated analyses and find the answers you need.
In the official Scalyr integration for Grafana, you can build tables within Grafana using PowerQueries easily. Below is a quick tutorial on how to do so.
- Create a dashboard - Start in Grafana by clicking the "+" and selecting "Dashboard"
- Create a new Viz - Select "Add Query" to start
- Setup a new Scalyr Query - Select "Powerquery" as the query type.
- Create PowerQuery - Enter your PowerQuery in the "Query" field. It may be a good idea to test it in Scalyr to get it to display the way you want first
- Setup Table - In the "Virtualization" tab change visualization to "Table"
- View table - Your table will display in as it would in Scalyr.
View Graph - You can also visualize your results with a “graph” visualization by setting the x-axis mode to “series”. This works best with (but is not limited to) queries that return 2 columns: 1 string and 1 integer.