Hello Airtable community,
Wondering if it's possible to make a pareto chart in Airtable. I'd appreciate your help!
+6Yes! I found this post when Googling how to reply and have just figured it out. All AirTable plans can add the Vega-Lite extension, and the page https://vega.github.io/vega-lite/docs/sort.html#specifying-custom-sort-order is a good start.
In my case I have a table called "Issues", with a field called "Problem".
The default definition after adding that exentsion and choosing the correct table is:
{
"title": "Issues",
"width": "container",
"height": "container",
"mark": "bar",
"encoding": {
"x": {
"field": "Problem",
"type": "nominal"
},
"y": {
"aggregate": "count",
"type": "quantitative"
}
}
}
And that gives a normal bar chart:
Adding a sort definition to x, like:
"sort": {"op": "count", "order": "descending"}
so that the code is now:
{
"title": "Issues",
"width": "container",
"height": "container",
"mark": "bar",
"encoding": {
"x": {
"field": "Problem",
"type": "nominal"
"sort": {"op": "count", "order": "descending"}
},
"y": {
"aggregate": "count",
"type": "quantitative"
}
}
}
This gives a Pareto chart:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.