I'm looking for suggestions on how to handle this in Kibana.
I've got one index that contains sales goals. Each record has a state, a month and a slaes goal for that month. Say, In WA, in August, we want to sell 600 items.
Then I've got another aggregate index that contains actual sales by state and month. Say, In WA, in August, we sold 450 items.
What I want to do is to produce a couple of visualizations in Kiabana (don't care which technology), that clearly show how we're progressing against our sales goals.
- Percentage of goal sales in WA that we achieved in August (75% in the above example)
- Shown as a metric or gauge?
- Percentage of goal sales achieved in year to date? (totalled by state)
- A heat map showing sales short fall or over achievement (goal - actual)
- A graph showing all states, with actual sales as a stacked bar and goal sales as stacked lines?
Can I use a transform on a complex index_pattern (sales_goals*,sales_actual*) to combine data from different indexes into a single one? (group by state and month, aggregate goal and actual?) To say produce a tracking index that has both the actual and goal sales for each state and month in it? That would at least let me used scripted fields to calculate the delta and percentage values.
Any other ideas on how to do this - that are, perhaps, a little more performance friendly.