Creating a Multi-line Graph from Google Analytics to a Dashboard Chart.

Ethan Kohl

Hello Everyone,

I am attempting to chart some data from Google analytics to a dashboard. So far I have imported the data to DataTable then used connections to make a sheet out of it that as far as I understand should auto update. Then I created a Report of that same data so that I can create an auto updating dashboard chart that shows the analytics as they go up and down over time. The problem I am running into is when I select the info to chart. I get a "smartsheet selected data cannot be charted. please select a new range dates" error. As you can see below the first column is the date the data was taken from, and the next 4 columns are data to be graphed. Also maybe unrelated, despite formatting the CTR column to percentage it has not changed the columns formatting.

What am I doing wrong in attempting to graph this data?

Paul Newcome

It looks like the data is being brought in as text strings. Try inserting some extra columns and using a VALUE function to convert each into a number then chart these new columns.

Paul Newcome

It looks like the data is being brought in as text strings. Try inserting some extra columns and using a VALUE function to convert each into a number then chart these new columns.

Ethan Kohl

Thanks, that did it. Weird that Smartsheet is importing it from the DataTable to the Sheet is doing it via string even though the columns are designated as numberic values on the DataTable.

Paul Newcome

It is possible it is being stored as a string even in the Data Table. It could be that it is storing as strings as soon as it is imported.