Quick Guide: Build Custom Metrics from Google Sheets
It is easy to create and add a metric to an existing or a new Databoard from a Spreadsheet. In this article, we will connect a new Google Sheets data source and Add a Metric on a Databoard directly from a Designer in a few easy steps.
Let’s try it out!
Login to your Google account when the popup window appears. Choose the appropriate Google Sheets account and File which you want to connect and then click on "Activate". Selected Spreadsheet with all tabs will be connected.
Read a step by step guide about connecting Google Sheets here.
IMPORTANT: After this step, a Query Builder for Google Sheets will open in a Popup window. Please check this article to learn how to create a new metric using Google Sheets Query Builder.
Visualization type selected in a Preview in Query Builder will be assigned and selected as default for this Metric - You can change it by clicking on the icon before Metric Name
The Metric can be used with other visualisation types and is also visible in a "Metric" drop-down under "Custom" from the right sidepanel (Properties).