topic Re: Dynamic add multiple measures in x axis in SAS Visual Analytics

Dynamic add multiple measures in x axis

harshpatel — Fri, 24 Apr 2020 07:55:06 GMT

Hello Folks,

Actually i want to add multiple measures in bar chart dynamically by clicking values which was placed in List objects.

For that i have created custom category and based on custom category i have made one calculated measure but here i am able to use only one measure which i have calculated as below.

IF ( 'Report'p = 'Fixed Capital' )
RETURN 'Fixed Capital (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Depriciation Provided' )
RETURN 'Depreciation Provided (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Interest Paid' )
RETURN 'Interest Paid (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Interest Received' )
RETURN 'Interest Received (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Rent Paid' )
RETURN 'Rent Paid (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Rent Received' )
RETURN 'Rent Received (In Lacs)'n
ELSE (
IF ( 'Report'p = 'Net Fixed Capital Formation' )
RETURN 'Net Fixed Capital Formation (In Lacs)'n
ELSE 0 ) ) ) ) ) )

And this measure i putted in bar chart.

Below are my trial.

But i want multiple selection which i will tick any measures and bar chart will chart accordingly as below

Please help me out in this.

Regards,

Re: Dynamic add multiple measures in x axis

Sam_SAS — Mon, 27 Apr 2020 19:56:37 GMT

Hello,

Your approach using calculated measures is a good one when a single measure is selected.

Unfortunately, I don't think it is possible to enable multiple selections. In my opinion, the inability to easily select data items in prompts is a shortcoming in our product.

In VA 8.4 and later, you can enable your report consumers to change the data assignments for your report objects. This is very powerful for users who want to deep dive into the data, but it is less suitable to more casual users and when it is undesirable to enable this (when there are data privacy concerns, for example.)

There is a Ballot Idea for what you want to do, and you may want to add some comments to it:

https://communities.sas.com/t5/SASware-Ballot-Ideas/Using-prompts-to-change-the-measure-s-displayed-in-tables-and/idi-p/220413

Thanks,

Sam

Re: Dynamic add multiple measures in x axis

FredrikE — Tue, 12 May 2020 13:51:13 GMT

Hi!
What you can do is to transform your data (befre loading it into VA) and create a new dimension containing the name of the measure and a new measure containing the value. You then group your chart by the new dimension and filter it with a list object containing the new dimension.
As value in the bar chart you use the new measure.
//Fredrik