I have an elastic search index that has 2 sets of data (and I have templates a variable based on _ type)
Here is the sample doc
_index:bu_compute_summary
_type:letsdoit_compute_summary
_id:xxxx
_source:{
cpu_count:100
}
_index:bu_compute_summary
_type:total_compute_summary
_id:xxxx
_source:{
cpu_count:900
}
I want to write a query to subtract cpu count on _type:total_compute_summary (900) and cpu count on _type:letsdoit_compute_summary (100)! Is this possible? I want to basically plot a pie chart with values of cpu_count of letsdoit_compute_summary vs cpu_count_compute_summary of total__compute_summary minus letsdoit__compute_summary (or a D3 GAUGE is even merrier)
@torkel @daniellee any help ?