Hello,

I would like to create a line chart of the used bandwidth. I have the data accumulated so far for every minute. How can I create a chart from it?

# Bandwidth by accumulated data?

**skydiablo**#1

**Bargs**(Matt Bargar) #2

**skydiablo**#3

Okay, first of all, all the details:

I have about 30 access points and their already transmitted data since start in one value (individually for each AP). This data is collected every minute. so I have an absolute value that grows almost every minute. Now I would like to show a bandwidth usage in a chart over all APs (later also for certain groups).

Currently I have this result: (

**Bargs**(Matt Bargar) #4

So is that the field you expect to be growing? If you look at that field in the individual docs in Discover, does that seem to be the case?

**Bargs**(Matt Bargar) #6

It looks like the size of the values may be washing out the relatively small changes from one doc to the next in your line chart. You could try enabling `Scale to Data Bounds`

in the "Metrics & Axes" tab of the visualization editor:

**skydiablo**#7

ok, now the formatting is a bit more chic, but that doesn't solve my real problem. As you can see now, the value just keeps increasing. And now I want to have the resulting bandwidth as a chart.

**skydiablo**#8

My current expression:

.es(index="ruckus_ap_info", metric="max:ruckusSZAPTXBytes", split="ruckusSZAPMac:10", kibana=true).derivative().divide(1024).scale_interval(1s).if(operator="lt", if=0, then=0).trim(start=2,end=1).label(regex="^.* ruckusSZAPMac:(.+) > .*$", label="$1").lines(width=1).yaxis(label="KB / sec", min=0)

this ends in this chart:

Now I have three questions to ask:

- are these numbers in the chart correct?
- how can I connect this jump with each other without the chart always returning to zero?
- the label is very unattractive, here I would like to point to another field (ruckusSZAPName), is that possible?

**system**(system) #9

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.