What new visualizations would you like to see in Redash?

Heatmap draw option for the existing map visualization type.
Alternatively (or as well), clustering of points.

This would let you create readable maps with far more points in an area than currently where you’ll get a mass of circles or markers, e.g. http://imgur.com/75KlfVT

4 Likes

Hello, I think it would be interesting to have:
meter (Gauge Chart)
cloud
Trendlines

Thank you

2 Likes

Heatmaps :grinning:
http://ngmap.github.io/#/!layer-heatmap.html

3 Likes



3 Likes

Bullet charts would be great.

5 Likes

A possibility to add trend lines and moving averages to a (line) chart would be really great to easily make more sense out of pretty noisy data

2 Likes

table with filtering could be possible by:

1 Like

I’d be a fan of adding the C3 chart renderers in the PivotTable option :slight_smile:

Polygon support in maps.

Ideally this would support WKT so that any type (or collection) of geo data could be returned from a DB in a single column and all mapped automatically.
We have used wellknown.js (https://github.com/mapbox/wellknown) to perform the bridge between WKT from the DB and GeoJSON (for leaflet) in other projects and it’s licensing would allow for it to be used here.

2 Likes

From a quick look, it looks like it should be definitely feasible to integrate this with reasonable effort.

What kind of “systems” give output in wkt?

Awesome :slight_smile:

The proposed use of WKT as the format is simply because we store geographical data in databases (SQL Server & MySQL) in their native spatial types. Both have built in functions to convert these to WKT for output (STAsText, ST_AsText). Other alternate formats (e.g. GeoJSON) don’t have built in functions for export.

I suppose if you wanted to make the maps work with GeoJSON as well (if other databases can output that, or maybe if someone just stored it as a string in their DB) then there could be a drop-down to select from the different supported spatial formats. That way, more formats could be added later if required?

1 Like

Dear, we have the same problems need from a geospatial query that return a geojson draw a maps with the result.

+1 for Trendlines, would love to have that.

A Horizontal Bar graph would be extremely useful.

2 Likes

+1 for bullet charts

Sorry, out of topic.
@arikfr, I would strongly recommend for “Auto refresh on Public dashboard” or Dashboard level group segregation and dashboard should be in view only state.

+1 for ng-maps with heatmaps as @wesleybatista suggested

I understand the use case of geojson, that makes you autonomous while making maps. But it gets slow as your data grows.
The mapping standard has a web service draw the map and return the resulting image - wms.
It also allows for requesting user-defined symbology by using an sld_body paramater.

Another mapping web service option is a rest api reference from esri (the largest gis seller). This allows for a rest-ish approach and also allows for requesting a map imagem with a user-defined symbology.

But best of all is that by using a good javascript mapping library you can use any of these… like openlayers.

This will give you serious location analytics capabilties in redash.

1 Like

Is this discussion still open? I’d love to see what @matbott proposed:

  • Tree Map
  • Pictorial
  • Size comparison
  • Pictorial Bar

In addition, I’d like to see Gauge and Dot Plots. Immediate visual feedback has great importance for end users of dashboards, IMHO. My boss always asks me for improved counters (with colors, links, multiple columns, icons…), for instance.

Thanks,

Arnaldo