Issue with visualizing dataframe from a job

cristianc — Wed, 01 Feb 2023 10:14:30 GMT

Greetings,

I have the following data set:

```sql

SELECT * FROM (

VALUES

('2023-02',113.81::decimal(27,2),'A','X'),

('2023-02',112.66::decimal(27,2),'A','Y'),

('2023-02',1223.8::decimal(27,2),'B','X'),

('2023-02',1234.56::decimal(27,2),'B','Y'),

('2023-01',12232.67::decimal(27,2),'B','X'),

('2023-01',1321.77::decimal(27,2),'A','X'),

('2023-01',12312.24::decimal(27,2),'A','Y'),

('2023-01',22221.66::decimal(27,2),'B','Y'),

('2022-12',121.89::decimal(27,2),'B','X'),

('2022-12',21231231.17::decimal(27,2),'A','X'),

('2022-12',12312.46::decimal(27,2),'A','Y'),

('2022-12',12312312.68::decimal(27,2),'B','Y'),

('2022-11',12122.88::decimal(27,2),'A','Y'),

('2022-11',122212.42::decimal(27,2),'B','Y'),

('2022-11',23123.68::decimal(27,2),'A','X'),

('2022-11',12312.26::decimal(27,2),'B','X'),

('2022-10',121.42::decimal(27,2),'B','Y'),

('2022-10',1231.9::decimal(27,2),'B','X'),

('2022-10',1231.98::decimal(27,2),'A','Y')

) test_table (test_date, test_value, test_type, test_cat)

```

The data set is actually coming from one our real life queries, but has values replaced with dummies.

The issue seems to be when trying to create a bar chart that has "test_date" on the X axis and "test_value" with SUM on the Y axis.

In the vizualization editor, in "interactive mode", the values don't show up, but they do in the cell once it is saved, however when running the notebook as a job the bar chart is also wrong, as it was in the editor before saving.

The expected behavior is that the bar chart shows up in job mode as it does in interactive mode.

This can be fixed by casting the "test_value" column type to float.

Thanks for letting me know if other information is required.

Regards,

Cristian

Re: Issue with visualizing dataframe from a job

cristianc — Wed, 01 Feb 2023 12:45:22 GMT

Greetings,

This is interesting actually when I export to HTML the issue is not happening.

Sorry but this was a bit confusing, in the previous message the notebooks will not illustrate the problem because of this, therefore I have deleted that message to avoid confusion.

It is only when looking at the results in the job run view as shown in the screenshot from attachment.

Regards,

Cristian

Re: Issue with visualizing dataframe from a job

cristianc — Thu, 02 Feb 2023 09:15:40 GMT

Attaching some more screenshots to add more details.

This seems to be a bug in the bar chart visualization widget when displaying from job run.

topic Re: Issue with visualizing dataframe from a job in Data Engineering

Issue with visualizing dataframe from a job

Re: Issue with visualizing dataframe from a job

Re: Issue with visualizing dataframe from a job