How use DataTable or any component of Visualization to build below report

Hi all,

I have below data:

	"hits" : [
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "DONE",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "PROCESSING",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.05",
    "_source" : {
      "@version" : "1",
      "status" : "WAITING",
      "level" : "ERROR"
    }
  },
  {
    "_index" : "test-2020.06",
    "_source" : {
      "@version" : "1",
      "status" : "WAITING",
      "level" : "ERROR"
    }
  }
]

Now I want to build a report like below:
| Processing | Done | Waiting|
| 1                  | 1         | 2           |

 The numbers are displayed in report is count of status

Anyone tell me know how to use DataTable or any component of Visualization to build above report. I'm a new one, I don't have much experience in Visualization.
Thank you for any responses.

If you split by rows for the field status in data Table.
| Processing |1 |
| Done | 1|
| Waiting | 2 |.
But it can be achieved by using a plugin called kibana-enhanced-table .

thank you for your response.
so there is no way to use Visualization?

Try using 'Split chart' by status as the buckets in some of the visualizations . Use Count as the other axis. Might need to search a bit to get one you like.

Thanks, I tried, it works

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