[Lens] Add more number format options

[wylieconlon]

Lens has a limited set of number formatters, but Kibana already supports a larger set that we should enable in Lens.

Format name	Example input	Example output	Comment
Short number	2000	2k	Already has numeral pattern
Duration (must specify input unit, optional output units)	2000, input unit: seconds, output unit: auto	00:33:33	This is converting to hours, minutes, seconds using the numeral formatter
Duration	2000, input unit: milliseconds, output unit: auto	2,000ms (this formatter just applies a ms suffix)
Duration	2000, input unit: seconds, output unit: days		This kind of straight conversion without the "human-readable" part is not one of the default duration formatters, but should be
Bytes (SI)	2000	1.95KiB	Using the 0.[00]bb (bytes binary) numeral format
Bytes (1000)	2000	2.00kB	Using the 0.[00]bd (bytes decimal) numeral format
Bits (1000)	2000	1.95Kibit	Using the 0.[00]bitb numeral format
Bits (1024)	2000	2.00kbit	Using the 0.[00]bitd numeral format

The main reason to add these new "duration" and "bytes" options is to make Lens support the most common formats for metrics data, which are not handled well in Kibana overall.

The duration formatter is particularly problematic in Kibana, so Lens has an opportunity to simplify. Most duration units should get displayed with a simple suffix based on the input unit.

[wylieconlon]

Anyone interested in tackling this issue for Lens should consider improving the duration formatter for all users.

[ghudgins]

This is becoming more important because formula does not allow us to use data view formatting options

[ojdo]

Just a user's perspective: this issue is what separates Lens from being able to "natively" convert from accumulated Netflow byte counts to bit-oriented (Mbit/s) transfer rates. Right now it goes 80% of the way to (Megabyte/s):

• Scale to time unit (/s) ✔️
• Byte formatting (MB) ✔️
• Bit formatting (Mbit) ❌

Thanks to #94605, I will probably be able to accomplish this myself soon with a formula, but as these formatters are already in Kibana, this looks frustratingly close.

In case you do not want to introduce additional UI, Lens could simply start honoring Kibana's preferences w.r.t. to format:bytes:defaultPattern. This wouldn't help with the "Duration" use case, though.

[ninoslavmiskovic]

@ojdo - We are going to add bit format capabilities in Lens for 8.8: #153389

@lalit-satapathy - Does this help you with migration?

[lalit-satapathy]

Thanks for the update @ninoslavmiskovic. We will check how to use this for phase2.

[stratoula]

Closing this as everything has been addressed in the latest kibana versions