BookmarkSubscribeRSS Feed
hiteshbhatt
Calcite | Level 5

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?

5 REPLIES 5
Reeza
Super User
Is that value in your data as well?
hiteshbhatt
Calcite | Level 5

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 

Reeza
Super User
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.
hiteshbhatt
Calcite | Level 5

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

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 865 views
  • 0 likes
  • 2 in conversation