Static viz multi-series shows two Y-axis

[flamber]

Describe the bug
Static viz multi-series shows two Y-axis.
Kinda a regression in 0.42.0, since 0.41.6 would just show a table, but at least there wasn't a correctness issue with that.

To Reproduce

1. Question > Sample > Products
2. Summarize Sum of Price, grouped by CreatedAt:Year and Category
   
3. Visualize and save question
   
4. Not going to spend time on subscription, go to /api/pulse/preview_card_png/:question_id
   

Expected behavior
Follow Y-axis choices from normal visualization settings.

Information about your Metabase Installation:
Tested 0.41.6 and 0.42.0

⬇️ Please click the 👍 reaction instead of leaving a +1 or update? comment

[losrebellos]

@flamber @howonlee

• After checking the png render it seems that the Doohickey category is using the left side axis and all the other categories are using the right side axis.
• Based on the original viz, the correct axis should be the right side one

[losrebellos]

@howonlee

After some more debugging, the example is using a combo-chart/LineAreaBarChart.
The options.series needs to specify which axis the serie belong to using yAxisPosition with left or right:

"series": [
  {
    "name": "bar series 1",
    "color": "#88bf4d",
    "yAxisPosition": "left",
    "type": "bar",
    "data": [
      ...
    ],
  },
  ...
}

In the GH issue example, it seems that the series all have "yAxisPosition": "right" except for the first one, hence the legend being divided, the 2 axises and the incorrect position of the first serie (Doohickey).
In that case, they should all have "yAxisPosition": "left".

[Tony-metabase]

Tested this on 1.46.1 and master and there are some paths that still doesn't work ... the issue in this case seems to be related to the Join between orders and product (in this case explicit)

So Step 1 ,create the following question -> Orders -> Count -> Group by Created_at:Month and Product -> Category:

Step 2, set visualization as a Line and make sure the split is disabled

Step 3, Add it to dashboard and send it to an email

Reopening issues

[luizarakaki]

@Tony-metabase can you help me reproduce it? I couldn't on 46.1

[Tony-metabase]

Any specific step you are getting stuck? Since same replication steps apply as the one flamber created ...

So Step 1 ,create the following question:

Step 2, set visualization as a Line and make sure the split is disabled

Step 3, Add it to dashboard and send it to an email

You get split Y-axis which are not there in the question and are also disabled form the settings ... Anything not clear let me know

Happens both on 1.46.1 and master

[ylq5126]

@Tony-metabase Can Chromium or Firefox be used to replace the existing solution?