How to get the sum in time of values in Lens

I have made a step forward.
The single minimal configuration file you created worked.

Current Status. I am able to reproduce the same situation as you.

# curl -X GET "210.148.155.195:9200/_cat/indices/file*?v"
health status index                                   uuid                   pri rep docs.count docs.deleted store.size pri.store.size
yellow open   filebeat-7.12.0                         GHo0AkwMR_metNn97AF00A   1   1          2            0     35.7kb         35.7kb
yellow open   filebeat-7.12.0-nginx-access-2022.08.03 jjrmhSTsQh6RmGiBcUwnSA   1   1          2            0     47.1kb         47.1kb

Here are a few questions.

  • Why is the index filebeat-7.12.0 being created?

    • I am intentionally creating the index input.index." filebeat-%{[agent.version]}-nginx-access-%{+yyyy.MM.dd}"!
    • Duplicate indexes are undesirable because they cut in half the number of indexes (number of shards) that can be maintained.
  • Why is the index.number_of_replica setting not enabled?

    • I intentionally choose not to create replicas (index.number_of_replica: 0).
    • This is undesirable because creating a replica halves the number of indexes (number of shards) that can be kept
# curl -X GET "210.148.155.195:9200/_cat/shards/file*?v"
index                                   shard prirep state      docs  store ip              node
filebeat-7.12.0-nginx-access-2022.08.03 0     p      STARTED       2 47.1kb XXX.XXX.XXX.XXX ELSTEST-01
filebeat-7.12.0-nginx-access-2022.08.03 0     r      UNASSIGNED
filebeat-7.12.0                         0     p      STARTED       2 35.7kb XXX.XXX.XXX.XXX ELSTEST-01
filebeat-7.12.0                         0     r      UNASSIGNED