Group By Count | MapLarge

.groupby(columnName.count)

The groupby count method takes a numeric column, sorts it, and groups into equal ranges sized to have equal numbers of values. For example, to segment all American households by income, groupby on the column income with a count of 10. This will return the top 10,20,30,40,50,60,70,80,90% etc.

Groupby count is a helpful method for creating an even distribution of colors in chloropleth map color scales.

Syntax .groupby(columnName.count: string) Example

var q = ml.query().from('maplarge/Donors');
    q.select('Amount.count','Amount.min','Amount.max', 'Amount.key');
             q.groupby('Amount.count.10');
q.run(function (data, query);
    console.log(data);
});

Demo

This demo shows a way to group political contributions into groups of 10. The groupby method, the Amount.count.10 will return 10 groups of Amount data. If there are 1,000 values in the database it will return 10 groups of 100 values aggregated. This is also a way to get the top and bottom X percent of data.

<html>
   <head>
      <script type="text/javascript" src="/JS"></script>
      <script type="text/javascript">
         ml.onload(function () {
 
             var q = ml.query().from('maplarge/Donors');
             q.select('Amount.count','Amount.min','Amount.max', 'Amount.key');
             q.groupby('Amount.count.10');
             q.orderby('Amount');
 
             q.run(function (data, query) {
                 var dataDiv = document.getElementById("dataDiv");        
                 dataDiv.innerHTML = ml.util.JsonHighlight(data);
             });
 
         });
      </script>
   </head>
   <body>
      <div id="dataDiv">
      </div>
   </body>
</html>

Special Groupbys

.groupby(columnName.count)

MAPPING PLATFORM FOR BIG DATA VISUALIZATION, ANALYTICS & PUBLISHING