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.

Liam Simpson

Hi Josef,

 

Thanks so much for your reply.

 

The issue is that it is the 'count' of non-numeric text which I need to chart, status and handler. If I just want to chart one of these then I can use the count function when creating a chart but when both are selected I cannot. Does this mean that I will need to count them manually (or using a formula) on a seperate sheet and make the graph from that?

 

Many Thanks,

Liam

Joseph Miller

Hi Liam,

 

I got your email to api@smartsheet.com and I'll respond to your question via that channel.

 

Thanks,

Joseph

Joseph Miller

As of right now tallying off of multiple columns is not currently available.

 

The work around would be to add up the columns manually or use a formula to count the columns, then use a single column as your data point.

 

-Joseph