How to reduce the gap between the grouped bars in Domo card?

art_in_sky
art_in_sky Contributor
in Cards, Dashboards, Stories

I am currently building a grouped bar chart by year. I find the chart inappropriate with a lot of space between grouped bars making it look visually unappealing. How do I decrease the space between the grouped bars and make it look presentable?

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    It looks like you have a distinct set of categories for each cluster. The gap is a result of showing the null values for each category that a cluster does not contain. I count at least 15 different colors in your series, so the first cluster shows the values for all your "blues", and then 0s/nulls for all your greens and oranges. Your second cluster shows the values for all your greens and 0s/nulls for all your blues and oranges, and so on.

    If you want tighter fit between your clusters, you need to standardize the series in some way so that it's the same (or same-ish) for each cluster. Like, the first bar in each cluster is "A", the second is "B", and so on. If that doesn't seem viable for your dataset, rather than a clustered bar, you might try a standard bar with a trellis using the category that is splitting up your clusters right now.

    It's a little hard to talk in the abstract, but if you gave a sense of your dataset and what you're trying to show, you could get some more specific advice.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited November 26

    Chart properties > Bar settings > Width Percentage = 100

    Screenshot 2024-11-26 at 11.44.45 AM.png

    If I solved your problem, please select "yes" above

  • art_in_sky
    art_in_sky Contributor

    @ColemenWilson This one I tried, however it adjusts the width of the bar but not the space between the grouped bars.

  • ColemenWilson
    ColemenWilson Coach

    Could you share a screenshot? I am playing around with adjusting the percentage and it is impacting the space between the individual bars in the group AND the space between groupings.

    If I solved your problem, please select "yes" above

  • art_in_sky
    art_in_sky Contributor

    @ColemenWilson Here you go , I have set the bar width as 100 and this is how it looks

    image.png

    s

  • ColemenWilson
    ColemenWilson Coach

    Could you screenshot more of analyzer view so I can see what else is going on in the card?

    If I solved your problem, please select "yes" above

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    It looks like you have a distinct set of categories for each cluster. The gap is a result of showing the null values for each category that a cluster does not contain. I count at least 15 different colors in your series, so the first cluster shows the values for all your "blues", and then 0s/nulls for all your greens and oranges. Your second cluster shows the values for all your greens and 0s/nulls for all your blues and oranges, and so on.

    If you want tighter fit between your clusters, you need to standardize the series in some way so that it's the same (or same-ish) for each cluster. Like, the first bar in each cluster is "A", the second is "B", and so on. If that doesn't seem viable for your dataset, rather than a clustered bar, you might try a standard bar with a trellis using the category that is splitting up your clusters right now.

    It's a little hard to talk in the abstract, but if you gave a sense of your dataset and what you're trying to show, you could get some more specific advice.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Categories