BookmarkSubscribeRSS Feed
harshpatel
Quartz | Level 8

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.

 

harshpatel_0-1587714794662.png

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

harshpatel_1-1587714875733.png

Please help me out in this.

 

Regards,

 

 

 

2 REPLIES 2
Sam_SAS
SAS Employee

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-...

 

Thanks,

Sam

FredrikE
Rhodochrosite | Level 12
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

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 2 replies
  • 983 views
  • 0 likes
  • 3 in conversation