How to visualize non-numeric data from Google Sheets?

Metrics in Databox require a numerical value to visualize, however, there's a workaround you can use with Google Sheets to count non numerical rows.

  1. Create a new column/row next to your non-numerical data and fill each cell with the value "1" if you want it to be counted, or "0" if you want to skip it.

  2. If tracking form submissions, add a column with "1"'s to count submissions for each form.

  3. Open Metric Builder and select your Google Spreadsheet as the Data Source.

  4. Create a custom metric using the new column for counting (e.g. to count total submissions).

  5. Set the Aggregation to SUM.

  6. Name the custom metric and save it.


PRO TIP: A powerful method to fill cells in an entire column in a Google Sheet while ensuring all new rows are included is by utilizing the ARRAYFORMULA() function. Find out more in the official documentation.