[mixed time-series] collection of related issues

[rumbin]

This is a issue collection which bundles the various open issues that the Mixed Time-Series chart is currenlty exhibiting.

I am hoping that this compilation helps bundling the development efforts for this otherwise great chart type.
Presumably, some of these issues can be fixed in a single PR.
Thus, I'll try to categorize these issues a bit...

Note:
Some of the issues are also related to "Time-series Bar Chart v2"

Two queries

These issues arise from the fact that this chart type is building on two distict queries, Query A and Query B.
It seems that other Superset components are not handlich this circumstance gracefully:

• [mixed time series chart] should show query A and query B on result table #16816
• exported csv file from Mixed Time-Series chart only contains one series #17960
• [chart][mixed time series chart] Mixed time series chart only show dashboard filter from query A  #15858

Axes

X-Axis

• Mixed Time Series Chart: X-Axis scaling is odd, when adjusting Time Filterbox #17128
• [mixed time-series] extra x-axis labels #15674
• [mixed time-series; time-series bar chart v2] Bar chart jumps to very narrow bars in larger time ranges #18232

Values formatting

• [mixed time-series] Separate Y-axis bounds, Label values and Tooltip formatting #15672
• [mixed time-series; time-series bar chart v2] D3 format of saved metric is ignored; bar values ignore D3 format of the chart #18234

Second Y-Axis

• [mixed time-series] Separate Y-axis bounds, Label values and Tooltip formatting #15672
• [mixed time-series] Secondary y-axis title is disguised/misplaced #18235

Environment

• browser type and version: Chrome 96.0.4664.93
• superset version: 1.4.0
• all other versions: as defined in Superset's Docker image
• Feature flags:

# stable:
      "THUMBNAILS": True,
      "SQLLAB_BACKEND_PERSISTENCE": True,
      "ENABLE_TEMPLATE_PROCESSING": True,
      "DASHBOARD_CROSS_FILTERS": True,

      # experimental:
      "ALERT_REPORTS": True,
      "ALERTS_ATTACH_REPORTS": True,
      "DASHBOARD_NATIVE_FILTERS": True,

      # unclassified:
      "ENABLE_EXPLORE_DRAG_AND_DROP": True,
      "ENABLE_DND_WITH_CLICK_UX": True,

      # development:
      "DASHBOARD_NATIVE_FILTERS_SET": True

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rumbin]

This issue should not be closed by the stale bot, in my eyes.

[huyhandes]

1 upvote, still not fixed I think

[rusackas]

Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering any of these issues, can we file separate issues for each item that needs to be addressed? That'll help make sure items get tackled and closed more expediently.