Skip to content
Evgeny Smyshlyaev edited this page Aug 6, 2019 · 13 revisions

Installation

Installation described here

Tutorials

It's possible to use plugin in two mode: when you have only key section and when you have pair (key, value). It first case you can use only total aggregate function. See two examples below.

Violations Rating

Dataset

Let's make a subset based on https://catalog.data.gov/dataset/traffic-violations-56dda. Here we are interested in timestamp and violation type:

date violationType
2017-06-10T13:49:30.570Z Warning
2017-06-10T13:49:31.766Z Citation
... ...

Query

There is only one field to select: violationType.

Options

In this case we have data in format (time, violationType) . There is no associated value to the timestamp.

Mapping

  • Stat = current - only total aggregation function is available for such case (keys without values)
  • Progress type = shared means that progress of each item would be equal to myTotal / allTotal

Sorting

  • Type = decreasing because biggest value to the top

Value Labels

  • Type = absolute to show absolute value on the right of progress item

Coloring

  • Type = key mapping to determine how each key should look like

Result

Phones Battery charge example

Dataset

Suppose you have dataset if format:

date name charge
2017-06-10T13:49:30.570Z HTC U11 48.77417982668406
2017-06-10T13:49:31.766Z iPhone 7 67.97330090041439
2017-06-10T13:49:33.344Z Honor 9 77.34158163607665
2017-06-10T13:49:35.023Z OnePlus 5 12.135238055164521
2017-06-10T13:49:36.949Z Honor 9 77.36015413279071
2017-06-10T13:49:38.743Z Samsung Galaxy S8 20.12525352504455
2017-06-10T13:49:40.517Z iPhone 7 67.91366914595524
2017-06-10T13:49:42.192Z Honor 9 77.3848857242402
2017-06-10T13:49:43.704Z Samsung Galaxy S8 20.05863769968002
... ... ...

Here you can make pairs (name, charge) and show current battery charge, selecting max value equals to 100. The data is auto-generated.

If you visualise this data with standard Grafana Graph panel, you would get something like this

Query

Now you can create a new Progress List Panel with query like this

Pay attention to fields section where name and charge are selected.

Options

Where

Mapping

  • Stat = current - to show current charge of each phone
  • Progress Type = max value and Max Value = 100 - each value is percentage to maximum value: 100

Value Labels

  • Type = percentage - we are showing how many percent the value is from Max Value.
  • Postfix = % - percentage sign in the end

Coloring

  • Type = thresholds - to show red when charge is low , etc..
  • Thresholds and colours is the standard way to make colour thresholds.

Result

Clone this wiki locally
You can’t perform that action at this time.