# Create visualize -\> Success rate based on time

**URL:** <https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203>\
**Category:** Kibana\
**Created:** [August 2, 2022, 10:43am UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203 "2022-08-02T10:43:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\
**Post date:** [August 2, 2022, 10:43am UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203/1 "2022-08-02T10:43:16Z")

</div>

Hi,

I'm using 7.16.2, here are the fields I've in my index... it holding data on builds in Jenkins.. build number, status: pass or fail...

I need to create a graph of success rate based on time.. for example: % of the tests Passed per week.  
e.g.: Week1 - 90%, week 2-85%, week 3- 70%, week 4- 100%...

Can you help me understand how to build this kind of graph?

```auto
"hits" : [
      {
        "_index" : "buildsfailures",
        "_type" : "_doc",
        "_id" : "AvAe330BtYsQZh-CKKj7",
        "_score" : null,
        "_source" : {
          "buildNumber" : 10948,
          "buildStatus" : "FAILURE",
          "displayName" : "#10948",
          "duration" : "00:0:10",
          "timestamp" : "2021-12-20T00:08:06.818Z",
          "url" : "https://jenkins.com/job/fireglass/job/dev/10948/"
        },
        "sort" : [
          1639958886818
        ]
      }

```

Thanks in advance,  
Shay

---

<div class="post-metadata">

**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\
**Post date:** [August 8, 2022, 7:50pm UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203/2 "2022-08-08T19:50:54Z")

</div>

I will ask a simple question... Can I group a fields by time? For example by week?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [August 9, 2022, 7:58am UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203/3 "2022-08-09T07:58:32Z")

</div>

You can do this in Lens - drag timestamp field the horizontal axis, then customize the interval and set it to weekly. After this, configure the vertical axis via lens formula: `count(kql="buildStatus: SUCCESS")/count()`. This should give you the chart you want to see

---

<div class="post-metadata">

**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\
**Post date:** [August 12, 2022, 1:10am UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203/4 "2022-08-12T01:10:25Z")

</div>

Thanks!!

---

<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:** [September 9, 2022, 1:10am UTC](https://discuss.elastic.co/t/create-visualize-success-rate-based-on-time/311203/5 "2022-09-09T01:10:49Z")

</div>

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