# Connectors activities reporting

**URL:** <https://discuss.elastic.co/t/connectors-activities-reporting/95187>\
**Category:** Kibana\
**Created:** [July 31, 2017, 12:45pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187 "2017-07-31T12:45:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mricacib](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@Mricacib](https://discuss.elastic.co/u/Mricacib)\
**Post date:** [July 31, 2017, 12:45pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187/1 "2017-07-31T12:45:41Z")

</div>

Hello everyone,

I have some hard time on Kibana, this is my problem :

I have 24 connectors on my server. I parse the logs with logstash and for each entry with connector activity I stock a number in the elastic search entry =\> "-1" if my connector is "INUSE", "1" if he go back to "AVAILABLE"

Log sample:  
[server] 2017-07-26 09:06:43,251 DEBUG [thread] classname | Status is changing: INUSE -\> AVAILABLE

Produce this variable in ES :  
"value\_status" = 1

I want to make a curve with timestamp on X-Axis, which tell me exactly how much free connectors I have.  
This curve have for limits min 0 (if all connectors are used) and max 24 (if all connectors are free)

I already try to make 24 + (SUM of "value\_status") like that

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/2/e/2ec110b2b08908e79dd29164add36b701efdbc41.JPG)

But it doesn't work;  
An idea what's wrong in this curve ?

Thank you

---

<div class="post-metadata">

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\
**Post date:** [July 31, 2017, 1:35pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187/2 "2017-07-31T13:35:42Z")

</div>

Hi @Mricacib,

looking at the way you store the events, I think you want to use a `cumulative sum` aggregation on the `value_status` field. I would recommend to use the new Time Series Visual Builder visualization type, because it allows for easy use of scripts. I was able to create such a graph using these settings:

![image](https://us1.discourse-cdn.com/elastic/original/3X/e/0/e070f4ded67bb818a7cf60a7728389b7a7235508.png)

---

<div class="post-metadata">

**Author:** ![Mricacib](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@Mricacib](https://discuss.elastic.co/u/Mricacib)\
**Post date:** [July 31, 2017, 2:30pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187/3 "2017-07-31T14:30:48Z")

</div>

Hi @weltenwort ,

I just load a little part of my logs, and I obtain this graph

 ![CaptureResult](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f44bee06e3ba05f728dfebf0c9467cf66d6b0fb9.JPG)

The total free connectors stay under the threshold and match with the server activity  
Thank you very much, it seem to work perfectly !

---

<div class="post-metadata">

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\
**Post date:** [July 31, 2017, 3:07pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187/4 "2017-07-31T15:07:47Z")

</div>

That is a pretty graph, thanks for sharing 👍

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 28, 2017, 3:08pm UTC](https://discuss.elastic.co/t/connectors-activities-reporting/95187/5 "2017-08-28T15:08:18Z")

</div>

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