In Databox, you can visualize data from your Google Spreadsheet (or Excel). Some companies want to merge text from several columns and visualize this in one row on their Dashboards. For example:
Use CONCATENATE in Google Sheets to properly format the data
Add a new column using the CONCATENATE function in Google Sheets to combine multiple columns in that column.
=CONCATENATE(TEXT(A2,"M/D/YY")," | ",B2," | ",C2)
Create the Custom Metric in Databox
Navigate to Metric Builder and select the correct columns to visualize the new concatenated column you created in the previous step:
Value: Set it to the column that contains your values (in our case column D).
Date: Set it to the column that contains the dates (in our case column A).
Dimension: Set it to the new column you created (in our case column E).
Add the Custom Metric to a Databoard
Lastly, add the Custom Metric onto a Databoard, or select it in an existing Databoard.
