Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Assigned To/ Status chart

Liam Simpson
Liam Simpson ✭
edited 12/09/19 in Archived 2015 Posts

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

 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Joseph Miller
    Joseph Miller Employee

    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.

    · Share on FacebookShare on Twitter
  • Liam Simpson
    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

    · Share on FacebookShare on Twitter
  • Joseph Miller
    Joseph Miller Employee

    Hi Liam,

     

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

     

    Thanks,

    Joseph

    · Share on FacebookShare on Twitter
  • Joseph Miller
    Joseph Miller Employee

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories