# Automation test stability trend over time **URL:** \ **Category:** Kibana\ **Tags:** vega\ **Created:** [January 25, 2022, 7:30pm UTC](https://discuss.elastic.co/t/automation-test-stability-trend-over-time/295391 "2022-01-25T19:30:10Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Ahsun\_Qureshi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahsun_qureshi/32/98491_2.png) [@Ahsun\_Qureshi](https://discuss.elastic.co/u/Ahsun_Qureshi)\ **Post date:** [January 25, 2022, 7:30pm UTC](https://discuss.elastic.co/t/automation-test-stability-trend-over-time/295391/1 "2022-01-25T19:30:10Z")
Disclaimer: Fairly new to Kibana I am trying to analyse test automation results over time to understand test failures for individual tests. The relevant fields include: test.name (string) test.result (string) As an output I am working towards a line chart that shows the percentage failure rate (rolling average of the percentage over the time window selected) for each test. What I am struggling with is: > An appropriate way to calculate the percentage. I can show the percentage in a bar graph with lens, but not use the percentage in any meaningful beyond it. Is there a way to create a variable to track this for each test? > And then possibly use that calculated value to arrive at a rolling average for the time interval. Would this be another variable of some sort? This is a TSVB question however I am not sure if that is doable with that panel. Is this something that Vega would help with? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 22, 2022, 7:30pm UTC](https://discuss.elastic.co/t/automation-test-stability-trend-over-time/295391/2 "2022-02-22T19:30:48Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.