# Visualization for Automation Test Reporting **URL:** \ **Category:** Kibana\ **Created:** [May 14, 2019, 9:41pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074 "2019-05-14T21:41:55Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![drunningen](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@drunningen](https://discuss.elastic.co/u/drunningen)\ **Post date:** [May 14, 2019, 9:41pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/1 "2019-05-14T21:41:56Z")
Hello, My team and I are very new to Kibana and elasticsearch, but we started using them for error reporting as well as automated test reporting. What I'm having trouble with is getting a chart that accurately represents the last known status for our test cases. I have data that is being sent in from the automation software, which get serialized into strings (despite whatever data-type they start as). The important values are the names of the scenarios (Scenario A, Scenario B, Scenario C, etc.) and their last reported status (pass, fail, error, and so on). I only want each scenario to be represented once in my chart and I want them to be sorted into buckets by their last statuses. The closest I've gotten is something like this: ![Capture1](https://us1.discourse-cdn.com/elastic/original/3X/c/4/c4f401e32dd4fc0c2a545a7ca256d4b28f315a22.png) This is supposed to represent 80 scenarios, but the data is counting 81 because of one scenario which errored the first time it was run and then failed (correctly) the second time (and every time after). How do I get this graph to only recognize the last record for each scenario? Current Configuration: - Metric: - Aggregation = Unique Count - Field = scenario name "keyword" - Bucket: - Aggregation = Terms - Field = scenario status "keyword" - Order By = metric: scenario name - Order = Descend - Size = 4 (number of possible statuses) **EDIT:** Looks like this post is trying to do exactly the same thing. > [@Viz of latest results of unique item: Not possible with Pie? Works for table, metric & bar chart](https://discuss.elastic.co/t/viz-of-latest-results-of-unique-item-not-possible-with-pie-works-for-table-metric-bar-chart/106427): > > I'm looking to represent in a Pie chart only the most recent result per test of my data set. I've managed to do this with Data Table visualizations, Metrics, and Bar charts, but Pie Charts seem to lack this ability today. Kibana&ES 5.6.3 For my working Data Table viz, I have a count metric and a Top Hit metric that aggregates on my result field sorted by @timestamp with a limit of 1 result, and then two sub buckets for my display needs. Inexplicably, the Pie chart doesn't come close to havi… **EDIT 2:** I think what I want is to use the "Top Hit" aggregation in the metric, but regardless of which field I target, I don't get any options in the "Aggregate with" drop-down, which is a required field. This seems like a bug to me but if there are any other suggestions for this, that would be great as well. ---
**Author:** ![CristianoFerreira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristianoferreira/32/47529_2.png) [@CristianoFerreira](https://discuss.elastic.co/u/CristianoFerreira)\ **Post date:** [May 15, 2019, 9:38am UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/2 "2019-05-15T09:38:22Z")
Hi, If you want something like this (one for each scenario): ![capture1](https://us1.discourse-cdn.com/elastic/original/3X/a/1/a15c5772957776f14e400871bb623e748995b100.png) Then use the following configuration: ``` Metric: Aggregation = Count Bucket: Split Chart Aggregation = Terms Field = scenario name "keyword" Order By = metric: scenario name Size = 80 (number of scenarios) Split Slices Aggregation = Terms Field = scenario status"keyword" Order By = metric: scenario status Size = 4 (number of status) ``` Best Regards ---
**Author:** ![drunningen](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@drunningen](https://discuss.elastic.co/u/drunningen)\ **Post date:** [May 15, 2019, 2:06pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/3 "2019-05-15T14:06:50Z")
Hi @CristianoFerreira, Unfortunately this is not what I want... I want one chart where each scenario is represented one time, and there could be any number of scenarios, but I only care about the last time each scenario was run. Maybe another example might help? If Scenario A was run 3 times and errors the first time, fails the second time, and passes the third time, the most up-to-date graph would only count Scenario A once as "passed". I should not have any idea that Scenario A ever errored or failed since that information does not matter anymore. ---
**Author:** ![CristianoFerreira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristianoferreira/32/47529_2.png) [@CristianoFerreira](https://discuss.elastic.co/u/CristianoFerreira)\ **Post date:** [May 15, 2019, 4:11pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/4 "2019-05-15T16:11:24Z")
Hi, Ok so if the documents are ingested from time to time (imagine from 5 to 5 minutes ) then you could use a Filter Aggregation and use the time from now-5min. Other way is to add a time filter to the Dashboard itself similar to this. If the documents are ingested in a not regular way, then i would suggest you to build two index, one to show in kibana (that would have only one document per Scenario) and another to store the data. When ingesting one document, this document would be added to the "store the data" index and at the same time would update the document in the "kibana to show" index. With this each scenario would only have one document with the most recent event in it, in the "kibana to show" index. Best Regards ---
**Author:** ![drunningen](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@drunningen](https://discuss.elastic.co/u/drunningen)\ **Post date:** [May 15, 2019, 6:00pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/5 "2019-05-15T18:00:01Z")
@CristianoFerreira - How would I go about overriding the documents? As far as I'm aware, any data that comes into an index just gets added to the group. ---
**Author:** ![CristianoFerreira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristianoferreira/32/47529_2.png) [@CristianoFerreira](https://discuss.elastic.co/u/CristianoFerreira)\ **Post date:** [May 16, 2019, 9:02am UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/6 "2019-05-16T09:02:11Z")
Hi, Every document has a `document_id` field (`_id`). A document can be overwritten if you put data on a document and specify the document\_id. Take a look at the API: [https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-index\_.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-index_.html) Best Regards ---
**Author:** ![drunningen](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@drunningen](https://discuss.elastic.co/u/drunningen)\ **Post date:** [May 16, 2019, 8:28pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/7 "2019-05-16T20:28:02Z")
@CristianoFerreira Would you happen to know how to do this through serilog? I looked through the documentation you provided and didn't see a way to set up the `_id` field dynamically based on the document content. Or even better, if you have an example of how to set up a mapping through serilog, that might even be preferable. We create new indexes daily to help us maintain data for if we need to truncate it, so being able to set up these options dynamically is also important. ---
**Author:** ![CristianoFerreira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cristianoferreira/32/47529_2.png) [@CristianoFerreira](https://discuss.elastic.co/u/CristianoFerreira)\ **Post date:** [May 17, 2019, 8:43am UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/8 "2019-05-17T08:43:18Z")
Hi, I dont't know about serilog, although as the documentation says, to set the `_id` field you can set it like in the example: `PUT twitter/_doc/123`. Here the `_id` is `123`. If you use Logstash you can also access the `document_id` filed as you can find here: [https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.html#plugins-outputs-elasticsearch-document\_id](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.html#plugins-outputs-elasticsearch-document_id) Best Regards ---
**Author:** ![drunningen](https://avatars.discourse-cdn.com/v4/letter/d/d78d45/32.png) [@drunningen](https://discuss.elastic.co/u/drunningen)\ **Post date:** [May 17, 2019, 3:09pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/9 "2019-05-17T15:09:51Z")
Thanks @CristianoFerreira, but I will probably have to wait for another solution since that would mean re-working code that already does most of what we want. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 14, 2019, 3:09pm UTC](https://discuss.elastic.co/t/visualization-for-automation-test-reporting/181074/10 "2019-06-14T15:09:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.