topic Re: Bar graph with SHOWING zero frequencY in SAS Visual Analytics

Bar graph with SHOWING zero frequencY

hiteshbhatt — Tue, 09 Jul 2019 17:50:59 GMT

Hi,

I am creating simple bar graph for some categories (Officers & Completed tasks) using SAS VIYA 8.3.1. When the officer has "Zero" completed tasks then entire category of "completed tasks" disappears from the graph.

I want to pop-up all categories on graph even they have "Zero" values. Please show me how to enable showing "Zero" Frequencies on the bar graph?

Re: Bar graph with SHOWING zero frequencY

Reeza — Tue, 09 Jul 2019 18:11:51 GMT

Is that value in your data as well?

Re: Bar graph with SHOWING zero frequencY

hiteshbhatt — Tue, 09 Jul 2019 20:52:43 GMT

No not in data, it's the frequency calculated only like;

------------------------------------------------

Task Officer status

------------------------------------------------

1 Officer1 completed

2 Officer2 memo

3 Officer1 Started

4 Officer1 transferred

5 Officer2 completed

6 Officer2 completed

7 Officer3 started

---------------------------------------------------

I am doing graph of Status, controlled (Drop-down) by Officer when I pick Officer3 it should display zero completed..

Thanks

Hitesh

Re: Bar graph with SHOWING zero frequencY

Reeza — Tue, 09 Jul 2019 21:02:30 GMT

I think you'll need to build an intermediate table for this then, that has the summary statistics you want to present where you deal with the missing levels at that stage and then feed that into the graph. If the data doesn't exist, SAS can't know to display it.

Re: Bar graph with SHOWING zero frequencY

hiteshbhatt — Fri, 12 Jul 2019 14:16:25 GMT

Does this intermediate table updates automatically if original table is updated/replaced?

Re: Bar graph with SHOWING zero frequencY

Reeza — Fri, 12 Jul 2019 14:56:00 GMT

Depends on where you add it, but if it's part of the design plan it should.