textSQL icon indicating copy to clipboard operation
textSQL copied to clipboard

Feature: Plot barcharts using plotly

Open asaprahul opened this issue 1 year ago • 1 comments

FYI - I have disabled Mapbox rendering for now to allow easy testing of the plotted bar charts. Will reenable + clean up some code before merging.

Won't work on mobile

Changes: figuring out how to pick the X and Y axis. few different options:

Approach A: Select column 0 as X axis, column 1 as Y axis. This works when you have multiple rows (and only 2 columns). Doesn't work when you have > 2 columns.

image

Approach B: Select columns as X axis, row 0 as Y axis. This works when you have multiple columns (but only 1 row). Doesn't work when you have > 1 rows.

Screenshot 2023-03-11 at 6 32 33 PM

Approach C: Do a stacked bar chart. Select column 0 as the X axis, column 1 to N as the Y axis. This works with >2 columns and >2 rows, but doesn't work when the datatype is not consistent between columns 1 to N (say some column are numbers, some columns are strings)

Screenshot 2023-03-11 at 7 29 57 PM

asaprahul avatar Mar 12 '23 06:03 asaprahul

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated
text-sql ✅ Ready (Inspect) Visit Preview 💬 Add your feedback Mar 14, 2023 at 0:36AM (UTC)

vercel[bot] avatar Mar 12 '23 06:03 vercel[bot]