In order to ensure your Google Sheet is formatted correctly, ask yourself the following questions. We want to create a report that shows the number of calls for each individual Agent, and also shows the distribution of calls amongst each Agent in a Pie Chart.
#GOOGLE SHEET REPORT BUILDER UPDATE#
Update Method: Add new row/column to reflect up-to-date Daily Valueįor our example, let's say three agents (Mark, Anna, and John) are updating cells in a Google Sheet throughout the day to track their calls for the current day. Update Method: Add new row/column to reflect up-to-date Total Valueĭate/Time: Date/time information is included on the Google Sheet Update Method: Replacing cell Value with up-to-date Total Value
Update Method: Replacing cell Value with up-to-date Daily Valueĭate/Time: No date/time information is included on the Google Sheet Use Case #1 goes into the most detail, so it's recommended that you start with this before moving on to any other examples.
#GOOGLE SHEET REPORT BUILDER HOW TO#
Most of the common use-cases for using these Data Types will be covered in this document.įor each example, we'll walk through how to prepare the Google Sheet, how to create the Custom Metric, and how to visualize the Custom Metric in Databox. In this article, we'll outline how to create Custom Metrics using the Total Value and Daily Value Data Types through multiple examples. How to report on Daily and Total Values using the Query Builder for Google Sheets
0 kommentar(er)
