Hi,   @Albert0 I think using the point and click tools in data builder you can only calculate average not median, however you can unlock the code so may well be able to manually calculate - https://communities.sas.com/t5/SAS-Visual-Analytics/Tip-Unlocking-code-in-SAS-Visual-Data-Builder/td-p/289234   If you don't have Data Integration Studio then Enterprise Guide will allow you to do what you need.   @LinusH- I agree with your sentiment but unfortunately VA lacks the power of its main competitors to calculate aggregations of aggregations, this forces report designers to pre-aggregate data in order to meet the needs of end users. Not ideal but doesn't seem likely to change in the short/medium term, Its a shame as VA is a decent tool otherwise. http://blogs.sas.com/content/sgf/2016/06/21/need-an-aggregation-of-an-aggregation-use-visual-data-builder-to-pre-aggregate-your-data/   ... View more

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)     ... View more

Hi,   What goes on the Y axis? ClientID?   I have done a really quick exampe based on the formula I described above, mine looks like   ... View more

Can you post some sample data? ... View more

Assuming you dont have the Office Addin I'd try to do everything natively in Excel, you may be able to skip VBA altogether if you have access to a version of Excel with PowerPivot?   You can get SAS ODBC drivers from here - https://support.sas.com/software/products/odbc/   You could then use powerquery to set up an automated import into Excel and use Powerpivot to present the data from the data model  ... View more

I'd created a couple of calculated items to show open and closed calls   something like   IF ( 'close_date'n Missing ) RETURN 0 ELSE 1 then an aggregated measure    Sum [_ByGroup_] ('closed'n) to aggregate   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 ... View more

We have the same issue and I think the answer to both quetions is no.   As you point out you can use the custom graph tool to create overlapping bar charts to mimic the functionality but it adds extra complextity especially if you want to have 100% stacked bars and falls down altogether if you want more than two segments. ... View more

Hi,   Can you provide more details on the type of query and how you were thinking about approaching it with VA?   I'm not sure VA itself would be the right tool for any heavy duty data processing although Data Integration Studio may be.   As an aside, 2 hours seems a long time unless your working with tens of millions of records? ... View more

I'd be intersted in seeing if this is possible as well.   The % of total function seems to be baked into the crosstab object and doesn't create a calculated item so it doesn't provide flexibility needed in this situation ... View more

7.3 may actually be better than 8.1 for doing this,   do the following links help?   http://bi-notes.com/2015/12/adding-stored-process-sas-visual-analytics/   https://support.sas.com/resources/papers/proceedings15/3433-2015.pdf   ... View more