I want to know that if we can make buckets in Kibana on basis of field names' prefix?
I have a database in elasticsearch which has data for different shops and restaurants. documents contain a field name which has shop-abc or shop-xyz for shops and restaurant-abc or restaurant-xyz for restaurants.
I can visualize the income from each separate shop and restaurant in Kibana.
I want to visualize the earning from all the shops and all the restaurants collectively in Kibana, I will have to first make a bucket for all the shops and all the restaurants and then I can sum up their income.
I want to know if I can make buckets on basis of prefix e.g shop-* and restaurant-* in Kibana manually as the GUI does not support this. What Kibana supports is that it will make a separate bucket for each shop and each restaurant.
Any help would be highly appreciated.