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 ?