Summarising Collection Data by Counts

ATTENTION: THIS IS OUR OLD SITE. TO SEE OUR NEW WEBSITE, CLICK HERE.

This code example shows how to count items of a certain type in a collection and present it as a summary of counts in a table.

The screenshot below shows the code results in a table: counting each time a keyword was searched for by users of a website.

The data being summarised is shown in the collection screenshot below. The collection is called SearchHist (note: this example code does not show you how to capture the search results into a collection). The table is given the id of #aggTable and is defined in the code. No datasets are required in this example as the collection will be directly referenced.

The code is shown below. First, #aggTable is defined. Then the data in the SearchHist collection is extracted to an array called dataArray. Thereafter, the search terms are extracted from dataArray into a new array called termsArray. Duplicate search terms may exist in termsArray as more than one user can search for the same keyword. Then unique search terms are extracted from termsArray into a new array called uniqueTermsArray. Each item of termsArray is looped through each item of uniqueTermsArray, counting each instance of termsArray for every uniqueTermsArray. The result is a count of search terms for each unique search term. This is saved in countArray. The combineArray function is defined and used to combine uniqueTermsArray and countArray. The result of which is saved into a new array called tableArray which is used to populate the table.

import wixData from 'wix-data';

$w.onReady(function () {

  // define the table
  $w("#aggTable").columns = [
    {
      "id": "col1",
      "dataPath": "term",
      "label": "Keyword",
      "visible": true,
      "type": "string"
    },
    {
      "id": "col2",
      "dataPath": "total",
      "label": "Total Searches",
      "visible": true,
      "type": "number"
    }
  ];	

  
  wixData.query("SearchHist")
    .ascending("keywords")
    .limit(1000) // include a limit if you have more than 50 items
    .find()
    .then( (result) => {

      // extract collection data as an array 
      const dataArray = result.items; 
      console.log(dataArray);

      // extract search term array from collection array
      let termsArray = dataArray.map(a => a.keywords); 
      console.log(termsArray);

      // get unique search terms list
      const uniqueTermsArray = result.items.map(x => x.keywords)
        .filter((obj, index, self) => index === self.indexOf(obj));
      console.log(uniqueTermsArray);

      // loop through termsArray, counting each instance from uniqueTermsArray
      var count = 0;
      var countArray = [];
      for(var j = 0; j < uniqueTermsArray.length; ++j){
        for(var i = 0; i < termsArray.length; ++i){
            if(termsArray[i] === uniqueTermsArray[j])
                count++;
        }
        countArray.push(count);
        count = 0;
      }
      console.log(countArray);

      // this function combines two arrays into one
      function combineArray( keys, values)
      {
          var array = [];
          if ( keys.length !== values.length)
            return null;
          for (var index in keys)
              array[index] = {
                term: keys[index],
                total: values[index]
              }
          return array;
      }

      var tableArray = combineArray( uniqueTermsArray, countArray);

      console.log(tableArray);

      $w("#aggTable").rows = tableArray;

      } );

});

The datapath variable in the table definition needs to match the variables fed it in tableArray.

Unlock

Please login or sign-up (it's free!) to view our code. Refresh the page if already logged in.

Disclaimer: To the best of our knowledge, this code works for its stipulated purpose. If you find an error in our code, or know of a better way to achieve the same result - please contact us! We will help where we can, however please be aware that the code is provided 'as is' and without a promise of support in using or implementing it.

Browse More Code

VeloCodeBank

take your Wix website to the next level

<Welcome>

Summarising Collection Data by Counts

ATTENTION: THIS IS OUR OLD SITE. TO SEE OUR NEW WEBSITE, CLICK HERE.

This code example shows how to count items of a certain type in a collection and present it as a summary of counts in a table.

The screenshot below shows the code results in a table: counting each time a keyword was searched for by users of a website.

The datapath variable in the table definition needs to match the variables fed it in tableArray.

Please login or sign-up (it's free!) to view our code. Refresh the page if already logged in.

Contact Us

© VeloCodeBank

Summarising Collection Data by Counts

ATTENTION: THIS IS OUR OLD SITE. TO SEE OUR NEW WEBSITE, CLICK HERE.

This code example shows how to count items of a certain type in a collection and present it as a summary of counts in a table.

The screenshot below shows the code results in a table: counting each time a keyword was searched for by users of a website.

The datapath variable in the table definition needs to match the variables fed it in tableArray.

​

Please login or sign-up (it's free!) to view our code. Refresh the page if already logged in.