New tooltip in 4.1.0+ is inappropriately combines series on mixed chart with two y-axes

[sfirke]

Bug description

I am trying out the new tooltip introduced in #27950 and loving it! However I notice nonsensical results on mixed charts that have two y-axes. For instance:

This chart shows volume of workorders and the % that meet some criteria. Those things are getting combined, leading to a confusing tooltip as N = 163 and 46% cannot be summed to get 16,346%.

For charts with two axes, the old tooltip behavior should be retained -- this from 4.0.2:

How to reproduce the bug

Create a mixed chart
Set up two different y-axes
Mouse over a value

Screenshots/recordings

No response

Superset version

master / latest-dev

Python version

I don't know

Node version

I don't know

Browser

Firefox

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.