Hi Joodies,
I'm guessing a and b are values of type
and new, wip, and done are values of status
So you're trying to create a data table with terms across the top and down the side. Unfortunately Kibana can't do that (yet). But I came up with a hack of a work-around.
I create test data using the Dev Tools console like this;
PUT index1/type1/1
{
"type": "a",
"status": "new"
}
PUT index1/type1/2
{
"type": "a",
"status": "wip"
}
PUT index1/type1/3
{
"type": "b",
"status": "new"
}
PUT index1/type1/4
{
"type": "b",
"status": "new"
}
PUT index1/type1/5
{
"type": "a",
"status": "done"
}
Then I created an index pattern in Kibana for index1.
Then I created 3 scripted fields by going on that index pattern so that I would have a field for each of those status values that are either 1 or 0;
Then I created the Data Table visualization as shown below;
Regards,
Lee