microsoft / sanddance Goto Github PK

Some datasets in JSON format are a root object, with the array being slightly nested. Would be nice to find the array in these cases.

See https://github.com/jdorfman/awesome-json-datasets

Vega -> v5
Deck.gl -> v7

Whenever I try to open a folder in Azure Data Studio (File -> Open Folder), the application restarts.
As soon as I disable the plugin, I can open a folder just fine.

I am using Azure Data Studio version 1.7.0 and SandDance for Azure Data Studio version 1.0.0

Edgars

Hi all,

I'm trying out SandDanceReact for a project I'm working on, and am running into some difficulty figuring out how to use the component. Is it possible to pass in a Vega spec to the component, or am I limited to the predefined charts? If so, in what prop do I pass it in? I know that one of the examples did this, but it's unclear if the SandDanceReact component exposes vega-deck.gl.

Also, what props can modify or disable the default legend/sidebar?

Thanks for open sourcing this btw, it's a really cool project.

The legend in the tree map pictured below looks messy because it doesn't reflect the measure's format (in this case, % with 1 decimal):

The same lack of formatting can be seen in the Data Browser:

As well as in tooltips:

Currently, pinch zoom goes somewhat wild.

Heya,

Tried installing sunddance-react, this issue should bug you to publish it before the name is taken by a troll :)

➜  sd git:(master) code .
➜  sd git:(master) npm install
npm ERR! code E404
npm ERR! 404 Not Found - GET https://registry.npmjs.org/sanddance-react - Not found
npm ERR! 404
npm ERR! 404  'sanddance-react@*' is not in the npm registry.
npm ERR! 404 You should bug the author to publish it (or use the name yourself!)

On another topic, it would be great to see the new WebGPU api implemented for Sanddance once its finalized.

not facet, but multiple charts in the same page, like a bar chart, at left and a scatter-plot at right

with cross filtering please as it is natively supported by vega

Area: Azure Data Studio extension. Also likely VSCode extension.
Issue:
Clicking on the “Sandance” button breaks the UI – it all goes white. Possibly a content permissions issue or redirecting to a page that doesn’t exist?

Similar to https://altair-viz.github.io/gallery/simple_bar_chart.html or Observable.

Right now Columnstats only has distinctValueCount, min, and max.
It would be useful to have mean there.

Your tool is very helpful to quickly filter out special points of .csv files, however there is no option to do something with the filtered values outside of SandDance. It would be nice if fitlered values could be saved as a new .csv file. Or at least just open the filtered subset in a new tab as csv, than the user can do whatever he wants with it.

Area: Azure Data Studio extension
Issue:
Sandance doesn’t react well to lack of horizontal space.
Just use split view to see issues

It's not clear that the color by area is driven by the "Color by" choice. I tried to change by clicking on the paint brush icon (which seems clickable) but this didn't work. That would've been my immediate solution to switching it up.

Released:

• VsCode extension
• Azure Data Studio + Extension

Coming soon:

• Power BI custom visual

The usage appears limited to

Right-click on a .csv or .tsv file and choose View in SandDance.

I work primarily with databases, and I'm sure I'm not alone. It takes time to query data from a database and save the data in local files. It'd be useful if SandDance did this work for me.

Are there any plans to address this use case?

Are there any alternatives you can suggest? Maybe this can be accomplished with another, existing VS Code extension and I just don't know where to look?

Hi,

I would like to have the ability to directly view query results in SandDance without having to save them to a CSV file first.

Thank you,

Edgars

We have a hierarchical prefs file, but there's no way of setting top-level defaults via the interface.

Besides a lot of RAM available this error happens when I try to open a large CSV file (803MB).

Console shows:

FATAL ERROR: CALL_AND_RETRY_LAST Allocation failed - JavaScript heap out of memory
 1: 0x562d86afdd15  [/usr/share/code/code]
 2: 0x562d86afde8a  [/usr/share/code/code]
 3: 0x562d837914f1  [/usr/share/code/code]
 4: 0x562d8383e6f2  [/usr/share/code/code] 
 5: 0x562d83846d04  [/usr/share/code/code]
 6: 0x562d83406f4c v8::internal::Factory::NewRawOneByteString(int, v8::internal::PretenureFlag) [/usr/share/code/code]
 7: 0x562d83866c64  [/usr/share/code/code]
 8: 0x562d837afe89 v8::String::Utf8Length(v8::Isolate*) const [/usr/share/code/code]
 9: 0x562d86b283ee  [/usr/share/code/code]
10: 0x562d83155781  [/usr/share/code/code]
11: 0x562d839ffd0e  [/usr/share/code/code]

It can't display Chinese, Japanese etc

Select a column with lots of different text entries. Will get a ton of black bars from the overlapping text. Need to handle this more sensibly.

A data column may contain actual hex color codes. Adding a feature to use that instead of a Vega color scheme.

• Select a column with all the same number
• Note that it's shown for every value, instead of having just 1 entry for numbers inside that range.

I have a simple query result with two columns: one is a string (names) and the other a numeric value. Is my assumption that Sanddance should be able to generate a bar chart whereby the height of the bar is determined by the numeric value incorrect?

Shift would 'or' the expression while cntrl would 'and'.

Hello PowerBI SandDancers!
This issue is here to outline our detailed plans to re-implement the PowerBI custom visual using the latest SandDance code.

Important notes

This new version of SandDance requires a WebGL2-enabled browser. At the time of this writing, these are Chrome and Firefox and the Microsoft Edge Insider.

Q: What if I don't have WebGL2?
A: SandDance may still render, but you may lose animated transition effects.

https://sanddance.js.org/app/#{%22description%22:%22https://raw.githubusercontent.com/vega/vega-datasets/master/data/cars.json%20barchartV%22,%22insight%22:{%22colorBin%22:%22quantile%22,%22columns%22:{%22x%22:%22Origin%22,%22sort%22:%22Cylinders%22,%22color%22:%22Cylinders%22,%22z%22:%22Horsepower%22},%22directColor%22:false,%22facets%22:null,%22filter%22:null,%22hideAxes%22:false,%22hideLegend%22:false,%22scheme%22:%22redyellowgreen%22,%22signalValues%22:{%22RoleZ_ProportionSignal%22:0.6,%22Text_ScaleSignal%22:2,%22Text_AngleXSignal%22:30,%22Text_AngleYSignal%22:0,%22RoleColor_BinCountSignal%22:7,%22RoleColor_ReverseSignal%22:false},%22size%22:{%22height%22:918,%22width%22:853},%22chart%22:%22barchartV%22,%22view%22:%223d%22},%22dataSource%22:{%22dataSourceType%22:%22url%22,%22displayName%22:%22https://raw.githubusercontent.com/vega/vega-datasets/master/data/cars.json%22,%22id%22:%22https://raw.githubusercontent.com/vega/vega-datasets/master/data/cars.json%22,%22dataUrl%22:%22https://raw.githubusercontent.com/vega/vega-datasets/master/data/cars.json%22,%22type%22:%22json%22}}

Filters and chart configuration, should be exportable to a json file, in order to be saved and reused.

Would be nice to have a history feature with undo / redo

Cubes should "fall" to the domain line. Need to add a Vega production rule for Y when cube is not selected.

• Select a column representing dates (or, possibly, times / datetimes)
• Expect to see time series representation
• Instead, get weird number I can't correlate to actual date values. is this the int value from the epoch?

While visualizing in SandDance, I might also refresh my CSV with new rows and/or columns.
Currently, I need to close SandDance and reopen it, to be able to work on the fresh data.
Since SandDance doesn't save its state, I have to remake all the visualizations.

It would be good to be able to refresh the dataset without closing SandDance.

NB: I use it in VSCode.

The visual, in Power BI, seams not to remember Point Size (as set in a previous session)