In bars chart display all numeric categories in x-axis without creating a new dataset

We have a dataset with a numeric category that ranges from 1 to 10, and we’re trying to build a bars chart with that category on the x-axis and a count of elements in the y-axis. Sometimes not all of the categories have values to display. Is there a way to maintain all numbers shown in the axis even if the count of their elements is zero (without having to create a new dataset or modify the one that we’re using)?

 

We have a workaround for this by creating a new dataset that left joins numbers from 1 to 10 with the original, but it just seems too much overhead.


Any advice would be appreciated.

 

Thanks!

Comments

  • Hi all,

    Can anybody help out @osmararv?

    Thanks!

  • Hello osmararv,

     

    Cards are designed to display data that exists in the dataset they are built on (after filters are applied). If values do not exist in that data, they cannot be included on the card. The only current exception to this is the Time Scale that creates a scale for date and datetime values.

     

    Requests have been made to include a "Value Scale", similar to the time scale, but for numerical values. Our development team is considering the requests, but I do not have information yet on whether that option will be included in the future.

     

    The workaround you are using, to inject the extra values into your data, is the current best method for achieving your goal.

     

    Please let me know if you have any further questions on this topic.

     

    Thanks!

    Steve Cook

    Domo Technical Support

  • Thanks Steven!

     

    I agree with you that a Value Scale would be a great addition to the card builder. Do you know if there is a related Idea in the community that I can vote for?

  • Hello osmararv,

     

    I am not aware of this idea already being posted in the Ideas Exchange. Please feel free to add it if you would like, so that others can vote on it as well.

     

    Thanks!

    Steve Cook

    Domo Technical Support

  • @osmararv,

     

    Please have a look at the ideas exchange here. It doesn't look like this idea has been suggested yet so please post it so others can vote it up and so that you will get credit for it.

     

    I did a quick search on all ideas relates to "x-axis" and these are the results.

     

    Thanks and Happy New Year!

     

This discussion has been closed.