If you're not seeing any data when previewing custom metrics from Google Sheets, the issue might be related to date formatting.
Ensure your dates are in the correct format. For comprehensive guidelines on formatting your Google Sheets data for Databox, you can refer to the official documentation at Databox Help Documentation. Proper formatting is crucial for accurate data integration and visibility.
Ensure your dates are formatted as "Date"
In Databox, every value must be linked to a specific date and time. If the date doesn't include time information, it defaults to midnight for that particular day.
We strongly recommend you ensure all dates within your spreadsheet are formatted as date:
For simplicity, we recommend adopting popular formats such as:
YYYY-MM-DD
MM/DD/YYYY
DD/MM/YYYY
December 4, 2023
4 December, 2023
Ensure your document locale is properly configured
Google Sheets:
Go to File > Settings and find the Locale dropdown menu.
Scroll through the list and select the language or region that matches your preferences. This selection will adjust the date, time, currency, and number formats to align with that specific locale.
Click the Save and reload.
Excel:
Select the entire workbook.
Right-click within the selected range and click Format Cells (on Mac go to Home > Format > Cells).
In the Format Cells dialog box, select the Date category.
Select the desired format and click on OK to apply the changes.
How to validate if a cell is formatted correctly?
If the date is aligned to the right, it means that Google recognized the input as a date:
Alternatively, you can use a function to validate the format:
On a Google Sheet, ISDATE() will return TRUE if the cell contains a valid date.
On an Excel file, ISNUMBER() will return TRUE if the cell contains a valid date.
