Creating a Multi-line Graph from Google Analytics to a Dashboard Chart.
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?
Best Answer
-
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.
Answers
-
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.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 390 Global Discussions
- 212 Industry Talk
- 446 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives