Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Bar Chart categories with no data

Occasional Contributor
Posts: 5

Bar Chart categories with no data

In VA, my bar chart only displays categories that have data. Is there a way to show all categories, even if they do not have any data?

Regular Contributor
Posts: 173

Re: Bar Chart categories with no data

Hi Ingrid,

I can not find a way to do this in SAS VA itself.

Please consider creating zero records for all occurrences in your database.

Several times I had to solve this issue just by adding 0 value records for all selectable instances that had no value.

greetings and good luck,  Peter

Trusted Advisor
Posts: 1,248

Re: Bar Chart categories with no data

[ Edited ]

If you're creating a chart over time then you may want to consider using a Time Series Bar Chart and the tips that @TriciaAanderud suggests at http://bi-notes.com/2015/12/sas-va-insert-your-own-months/


Alternatively you can create a "helper table" as in the blog post to create 0 records which @PeterWijers suggested.




Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation