Our goal here will be to create a variable which controls the type of buses displayed in the visual, based on the bus’ route.įor simplicity sake, let’s define 4 types of bus routes: M, B, Q, and S. Let’s change that by creating a variable to alter which bus routes we display on the map. While the standard static panel tells us the live location of the buses, there’s not much that we can do to interact and explore the data more, apart from zooming in and out.
Notice that there are 5 colors - one for each bus route M,B,Q and S, as well as one for routes that don’t fall into those categories. Threshold settings to give each bus type a unique color
#Grafana trackmap download
You can download the JSON to replicate the dashboard in this Github repo. Here’s what my panel looks like before we make it interactive.
#Grafana trackmap how to
Ready to learn how to use variables in Grafana dashboards powered by PostgreSQL queries? Try It Yourself: Implementation in Grafana I’ll illustrate the process using the example of monitoring the live locations of buses going on different routes in New York City, but the steps I follow will work for any scenario. In the rest of this post, I will show you how to use Grafana’s variables feature to build your own interactive dashboards. However, enabling features like pickers in the Grafana UI can be tricky.
#Grafana trackmap code
Grafana variables allow you to use a drop down menu to select various options, no code modifications required Here’s an example in Grafana, the open-source visualization tool, where I’ve created “pickers” (filters) that allow me and other stakeholders of the dashboard to choose values from a drop down menu and immediately see our selections appear in the visual, without having to change any of the underlying SQL queries powering the dashboard. It’s a win-win situation: more usability for the stakeholders who rely on your dashboards, and less of your time spent attending to minor customization changes. Or worse, stakeholders try to dig into the code and accidentally break things! Solution: Make Your Dashboards Interactive (and User-Friendly!)įortunately, many visualization tools have features to make your graphs, maps, tables, and other visualizations interactive via the tool's native UI. Those of us that work with data often want to make useful dashboards that make it easier for ourselves and other people within our team and organization, to gain insight and make sense of the data we collect.Ī common problem I’ve run into (both when creating dashboards and using them as a stakeholder) is that many dashboards aren’t interactive enough for non-technical stakeholders to get their questions answered without asking engineers to write new code or change the underlying queries powering the dashboard. The (All Too Common) Problem: Boring, Kind of Useful, Static Dashboards
0 kommentar(er)
