How to set up Metrics Index for dashboard?

[Federico92]

Hi all!

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 a metrics 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?

[richgalloway]

What problem are you trying to solve?  Once that is understood then we can offer suggestions.

[Federico92]

I need to calculate some metrics for dashboarding (es count of records), but the calculation should be responsive to some dashboard filters

For example, I had stored in metrics index the record count that have value=100
If I change the value of one filter in the dashboard, this value should be 10

I need some suggestion on how make this requirement with metrics index