Displaying a bar chart of individual numeric values | XM Community
Skip to main content
Michael_Cooksey
Administrator
16 days ago
Question

Displaying a bar chart of individual numeric values

N
Forum|alt.badge.img+1

Hello,

 

I have a field of numeric values that I would like to display in vertical bar chart form. I’ve found that only after I map the data as a text or number set am I able to do this. That would be fine, but neither one consistently orders the values on the x-axis numerically low to high. It seems to be a text-based ordering either way. I’ve tried using both label and value as display options for the x-axis.

I could custome order the values numerically, but was hoping there was a simpler and more robust way of achieving that. I’m also trying to set it up as data continues to come in, so new values need to be worked into the ordering appropriately.

I appreciate anyone’s insights on this!

Thanks, Neil

    4 replies

    J
    Level 4 ●●●●
    • jbk
    • Level 4 ●●●●
    • 204 replies
    • March 12, 2025

    map the dataset as numeric fields. Once you set up the x-axis, you can sort based on the values. It will automatically does the same when new data comes in.

    N
    Forum|alt.badge.img+1

    Thanks, jbk. If I do what I think you’re suggesting, the ordering by value ends up ordering the bars by the number of responses for each x-axis value rather than the values themselves. So the bars arrange low to high. If I order by label, I run into the same problem of it being a text rather than numeric ordering.

    J
    Level 4 ●●●●
    • jbk
    • Level 4 ●●●●
    • 204 replies
    • March 14, 2025

    Okay, can you please let me once again what are you trying?

     

    C
    Level 4 ●●●●
    Forum|alt.badge.img+16

    Hi ​@Neil Hurwitz ,

    I would suggest giving an example or provide screenshot to illustrate what you are trying to achieve for future enquiries.

     

    I think you are trying to do is get the x-axis to be sorted in this order without custom sorting:

    [numeric values (number of responses)]

    For example, 0 (1), 1 (7), 5 (30), 7 (10), 11 (2).

     

    When you tried sorting the x-axis by value, the order goes by responses from lowest to highest.

     For example, 0 (1), 11 (2), 1 (7), 7 (10), 5 (30).

     

    You also tried sorting the x-axis by label, the order goes by text sorting A-Z.

    For example, 0 (1), 1 (7), 11 (2), 5 (30), 7 (10).

     

    Is it possible to change the labels name to have the same consistent format?

    For example, 00, 01, 05, 07, 11.

    Then, when you sort by label, you should get 00 (1), 01 (7), 05 (30), 07 (10), 11 (2)

     

     

    Leave a Reply


    Terms & Conditions