Splitting visualization by value not field

I can the JSON structure whatever way I like but I need to split tables by string value and get a count of another value for example:

{
"car.BMW":20,
"car.Toyota":10
}
or something like
{
car: {"name":"BMW", "value":20}
car: {"name":"Toyota", "value":10}
}

and my table would look like this:

| CAR | COUNT |
| BMW | 20 |
|Totaota| 10 |

But I cant get the table to look like that! Any ideas?

The Discover app is one way of looking at a table which contains values from individual documents. The Visualize Table is aggregated, which it sounds like you don't want.

So I would suggest you select the path to the fields from Discover, such as car.name and car.value, and then Save the search. Once the search is saved you can embed it in a dashboard.

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