Filter records with ranges

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
OpenSearch 2.11

Describe the issue:

I am trying to develop a structure for data in the format mentioned in the picture attached, any recommendations for achieving this?

Configuration:

Relevant Logs or Screenshots: