How can I manage data aggregation settings in Databox for data from spreadsheets?

To manage data aggregation and updating settings in Databox for Google Spreadsheet data, you can follow these steps:

1. Prevent Data Aggregation When Updating Cells

If you want to prevent Databox from adding new values to previous values when updating spreadsheet data, uncheck the checkbox "Handling multiple values stored for identical Date/Time" when editing the custom metric in Metric Buider. This will overwrite previously stored values instead of summing them together, ensuring that only one value per dimension is shown.

2. Apply Data Aggregation When Updating Cells

If you need to aggregate values for the same metric from multiple rows in a Google Spreadsheet, you need to check the checkbox "Handling multiple values stored for identical Date/Time" when editing the custom metric in Metric Builder. This will ensure that all data available in the spreadsheet for the same date and/or dimension will be aggregated in Databox.