topic Re: Bar Chart categories with no data in SAS Visual Analytics

Bar Chart categories with no data

Ingrid88 — Fri, 18 Dec 2015 20:37:20 GMT

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?

PeterWijers — Sat, 19 Dec 2015 10:53:59 GMT

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

MichelleHomes — Sun, 20 Dec 2015 22:11:54 GMT

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