I would like to graph a ratio between two counts on the same index.
For example, if we take the books dataset, count the ratio of American book out of all the expensive books (more than 10$)
count(books where country=US and price > 10$) / count ( books where price > 10$)
I want to be able to graph the evolution of this ratio aggregated per day of publication or any kind of bucketing (per country, per geohash, ...).
Do you have any idea on how to do that ? Considering that I can afford changing the data structure.