Assigned To/ Status chart

Liam Simpson

Hi Everyone,

 

I am trying to create a chart using the app in Smartsheet labs which displays the number of projects per handler and split into the status. I can create a Bar Chart showing the count of projects per handler but when I try and make a similar chart which splits the count by status it says that I can't.

 

The issue is that in order to make the handler count chart I have to select 'Calculate my data before charting'  which only allows me to select one 'Group By' catagory. When I try to use the 'Chart my data' option it says 'Data column(s) for axis #0 cannot be type of string'.

 

What should I do to reslove this?

 

Thanks in advance

 

 

Joseph Miller

Hi Liam,

 

That error is caused when some of the data being imported is non numeric data, or a "string" rather than a "number". 

 

There are certain graphs that cannot create a graph out of non-numeric characters and will throw out this error. I've found this more common when you have multiple text columns selected. If you deselect the text columns when importing the data you should not see this error. 

 

If you still have issues, shoot an email to api@smartsheet.com and we'll continue troubleshooting.