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

Bar Chart categories with no data

Reply
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: 172

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

Super User
Posts: 1,209

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.

 

Cheers,

Michelle

Post a Question
Discussion Stats
  • 2 replies
  • 225 views
  • 0 likes
  • 3 in conversation