[Aggbased][Heatmap] Standard deviation metric is not rendered correctly in the EC implementation

[stratoula]

Kibana version:
When we added the heatmap EC implementation

Describe the bug:
Create a heatmap with standard deviation. Only the Lower bound is visible and not the upper

With EC

With vislib

[elasticmachine]

Pinging @elastic/kibana-visualizations @elastic/kibana-visualizations-external (Team:Visualizations)

[stratoula]

But I am not sure how this should work on a heatmap. On vislib is like you have 2 heatmaps one with lower deviation as value and the other as the upper. Possibly with small multiples?

cc @markov00

[markov00]

the vislib data implementation is exposing 2 series, one for the low bounds and one for the upper bounds, but lens only return 1 value (I'm looking at the Inspect -> table). Both aggregations are the same but the resulting table is different.
We don't need to have a small multiple, but just 2 series to render

[stratoula]

@markov00 the data exist for the upper bounds too we just dont expose them (on agg based heatmap

Can I have 2 valueAccessors on a heatmap in EC?

[markov00]

@stratoula actually no, your data should be formatted as the following:

X	Y	VALUE
timestamp	UpperSeries	Value
timestamp	LowerSeries	Value

With a data transformation like the following:

const data = table.map(d => [d.x, "upper", d.upper]).concat(table.map(d => [d.x, "lower", d.lower]))

[stratoula]

Got it Marco! Thanx!

[stratoula]

Thank you for contributing to this issue, however, we are closing this issue due to inactivity as part of a backlog grooming effort. If you believe this feature/bug should still be considered, please reopen with a comment.