I need to store more than 500.000 events in an event index and apply aggregation logic that produces metrics to display on a dashboard. I want to use ametrics index to store these metrics so I can improve the performance of the dashboard. The dashboard will have some filters that could generate n! different combinations(one combination per set of filter values).
My concern is that in order to be able to guarantee acceptable response times I will need to generate a metric for every possible combination of the filters, and that just seems excessive.
Is this the only way to achieve what I am looking for?