Skip to main content

Hello Airtable community,

Wondering if it's possible to make a pareto chart in Airtable. I'd appreciate your help!

Yes!  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:

 

 


Reply