Plotly figure always generating with y = [0...n]

[lz039]

Hi folks,

the generated SQL and the table / df output is correct, but for plotly generation the y-axis is always only counting upwards:
for x = 0, y = 0,
for x = 1, y = 1
... and so on

I use this default route

@app.route('/api/v0/generate_plotly_figure', methods=['GET'])
@requires_cache(['df', 'question', 'sql'])
def generate_plotly_figure(id: str, df, question, sql):
    try:
        code = vn.generate_plotly_code(question=question, sql=sql, df_metadata=f"Running df.dtypes gives:\n {df.dtypes}")
        fig = vn.get_plotly_figure(plotly_code=code, df=df, dark_mode=False)
        fig_json = fig.to_json()

        cache.set(id=id, field='fig_json', value=fig_json)

        return jsonify(
            {
                "type": "plotly_figure", 
                "id": id,
                "fig": fig_json,
            })
    except Exception as e:
        # Print the stack trace
        import traceback
        traceback.print_exc()

        return jsonify({"type": "error", "error": str(e)})

Can anyone help?

[lz039]

Probably I need to update my code as to #733 the vanna-flask repo is outdated.

[lz039]

I did the update but still not working.

Even generate_plotly_figure returns the correct plotly configuration, it's not rendered correctly.
If I use the data returned in generate_plotly_figure in a python notebook it looks great, but on the vanna webserver ui the plot is empty, without any error messages.

[SkyCandy567]

I am running into the same issue. Any resolution yet?

[SkyCandy567]

It looks like the newer version of plotly may have broken it? I went down to plotly==5.22.0 and now its working. I suspect maybe something to do with fig_json = fig.to_json()

[zainhoda]

@SkyCandy567 could you try with the even newer version of Plotly (6.0)?

[stefan22mar]

Hey did you manage to fix this issue? I'm struggling with this as well and I thought at first it was because of a weird binary encoding the fig.to_json() function does.

It looks something like this:

'y': {'bdata': ('PIw5PL8O7j9nHrgAgw3zP0aQ6rSh3/' ... '8K5gRAB0hi8sLhBUDZtkLgDdIGQA=='),
'dtype': 'f8'},