simonw/django-sql-dashboard

Bar charts sort labels alphabetically instead of respecting their order

simonw opened this issue · 7 comments

simonw commented

Here's why:

django-sql-dashboard/django_sql_dashboard/templates/django_sql_dashboard/widgets/bar_label-bar_quantity.html

Lines 32 to 40 in d59d01f

encoding: {
x: {
field: "bar_label",
title: "Label",
type: "nominal",
axis: { labelAngle: 90 },
},
y: { field: "bar_quantity", title: "Quantity", type: "quantitative" },
},

It's because of type: "nominal".

simonw commented

I am finding it remarkably difficult to figure out how to get Vega-Lite bar charts to respect the initial order (I remember having this same problem with datasette-vega): https://vega.github.io/vega-lite/docs/bar.html

simonw commented

That's not quite what I'm after here - I want to sort in the order originally provided by the results of the query.

So if the data looked like this:

  {
    "values": [
      {"a": "Dog", "b": 28},
      {"a": "Cat", "b": 55},
      {"a": "Chicken", "b": 43},
      {"a": "Dragon", "b": 91}
    ]
  }

I want the bars on the bar chart to be in Dog, Cat, Chicken, Dragon order.

simonw commented

Aha! It looks like "sort": null does the trick. https://vega.github.io/vega-lite/docs/sort.html#no-sorting

simonw commented

I can fix simonw/datasette-vega#19 with this too.