08-15-2017 05:53 AM
I have a dataset like this:
client_ID| open_date | close_date
abc123 | yyyy-mm-dd | yyyy-mm-dd
I wonder how I can plot in SAS VA a chart of number of opened and minus number of closed clients by years?
08-15-2017 06:57 AM
I'd created a couple of calculated items to show open and closed calls
IF ( 'close_date'n Missing ) RETURN 0 ELSE 1
then an aggregated measure
Sum [_ByGroup_] ('closed'n)
If you want open - closed would be something like
Sum [_ByGroup_] ('open'n) - Sum [_ByGroup_] ('closed'n)
Then use the aggregated measures in your chart object
08-15-2017 09:50 AM
Sorry, but I can't send you data. All I can tell is just that datatable consists of 3 columns: client_ID, open_date, close_date. Everyone has open-date but only someone has close date.
I need to show how many clients has opened and closed by year. It's very simple to do in Excel. But I'm creating a dashboard in SAS VA for web-site. I've tried to use barchart and count clients grouping by date, but such approach doesn't allow to put datasets on the same plot. I'm puzzled.
08-15-2017 10:26 AM
Have a look at how I set up the roles in my example, should give you that (unless I've missunderstood)
If year is a measure, duplicate it (right click on it) and set the new version as a category (another right click) to allow you to select it as the category (x-axis)