Line Charts in Dashboards - Need two lines on one chart

dhall
dhall ✭✭✭
edited 10/17/22 in Smartsheet Basics

Hi there! I'm building a dashboard from data I'm collecting from and individual and their respective manager.

The individual rates themselves on a metric each week. The manager rates the individual on the same metric each week. I convert the ratings to numbers and put them in a row their own row - one for the individual and one for the manager. Each column is a week with a number to correlate when they performed the rating.

I want to see how the Manager rates the individual compared to how the individual rates themselves on the same chart as it's the same metric. I figured line chart would be the best so we can see the up and down week to week.

However, when I put these rows into a report for a dashboard, it only charts out the top row.

Am I missing something on how to turn it into two lines on a chart?

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @dhall

    Can you post the formula you're using for this conversion?

    It sounds like perhaps these numbers are being seen as Text instead of Numerical. This can happen if a formula returns the number with quotes around it, like so:

    =IF(Data@row = "Four", "4")

    You'll want to ensure any numerical outputs don't have quotes, like so:

    =IF(Data@row = "Four", 4)

    Let me know if this may be what's causing the error!

    Cheers,

    Genevieve

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @dhall

    If I'm understanding you correctly, you have a source sheet set-up similar to this:

    And you want both rows to appear as two lines in a Chart Widget. If so, then yes! This should be possible. In my test Chart I made sure to map both rows as the Source:

    Note that both full rows are selected in blue. Then I have my Chart Widget settings as follows:

    If you're still unable to map both rows, it would be helpful to see screen captures with Test Data so we can understand set-up and help further!

    Cheers,

    Genevieve

  • dhall
    dhall ✭✭✭

    Hi @Genevieve P. ,

    Thanks for the response! So it turns out for some reason one of my rows "cannot be charted" which makes no sense. Here are some screenshots for reference:

    I've selected these two rows - Case Count and Case Comfortability:

    Right now only doing the first couple weeks and then when I get it working I'll expand to the entire row (16 weeks)


    Here's what is charted:

    So I highlighted just the Case Comfortability row and this is what I get:

    I'm not sure why that is because it's numbers just like the other row.

    I specifically take the "star rating" from another form and convert the number word to the digit number (i.e., "four" to "4") and they are being pulled from that cell to populate this row.


    Any thoughts?

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @dhall

    Can you post the formula you're using for this conversion?

    It sounds like perhaps these numbers are being seen as Text instead of Numerical. This can happen if a formula returns the number with quotes around it, like so:

    =IF(Data@row = "Four", "4")

    You'll want to ensure any numerical outputs don't have quotes, like so:

    =IF(Data@row = "Four", 4)

    Let me know if this may be what's causing the error!

    Cheers,

    Genevieve

  • dhall
    dhall ✭✭✭

    Oh I do have quotes around my numbers in the formula.... let me remove those and see if that's it.

  • dhall
    dhall ✭✭✭

    😑

    That was it:

    @Genevieve P. , you are a rockstar! Now I get to go update formulas and FINALLY get my charts working the way I want them to. Thank you so much!

  • Genevieve P.
    Genevieve P. Employee Admin

    It's so great to see your chart working! Glad I could help, and good luck 🙂