[Lens] Additional normalize by unit counter rate interval options

[ghudgins]

Describe the feature:
Include additional Normalize by unit intervals in Lens Counter Rate options (week, month, quarter, year)

Describe a specific use case for the feature:

Thanks counter rate helped but the aggregation goes to a day max. What I'd like to do is build a dashboard over the last year (for instance) and get a bar graph where each bar represents a month and shows the number of created issues that month (one bar) and the number of closed issues that month (another bar next to it).

from discuss forum - https://discuss.elastic.co/t/display-aggregated-counter-value-per-interval/272333/8

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[wylieconlon]

@ghudgins @snicoll I think there has been a misunderstanding here, the "normalize by time unit" feature would not be able to solve the problem that @snicoll described as "a math operation between the first and the last value in the bucket". The main use of normalize by time unit is to do basic division, so for example:

• I have an aggregation with daily buckets
• I want to display the hourly rate, but I can't because this is a slow query
• Normalizing by time unit will divide my value by 24 and then append a /h suffix.

So to specifically point out why I don't think this issue is the right one: adding a monthly interval to the normalizing function would multiply the value. So if I have daily buckets but want to display monthly values, it actually multiplies by the number of days in the month to display the value. This is almost never what users want, and therefore I am closing this issue.

I think we should open a new issue to discuss whether we want a "First value" function.

[wylieconlon]

I think this new issue covers the use case: #101500