BookmarkSubscribeRSS Feed
PavanKumar2
Fluorite | Level 6

I have a Aggregated Measure where I need  to display in button bar. But Button bar accepts  only  Categorical Value to display.

so I need to convert aggregated Measure to category value. Or Else Is there any other way to Display.

5 REPLIES 5
FalkoSchulz
SAS Employee

Most of the report controls (including button bar) - rely on categorical values given the nature of controls listing a distinct item list. You have however the option to assign an additional measure which is then aggregated given the categorical item (and displayed in brackets). More information about controls is in the VA user guide: https://go.documentation.sas.com/?cdcId=vacdc&cdcVersion=8.3&docsetId=vaobj&docsetTarget=n11d8xohg1c...

 

I'm not aware of a way to convert an aggregated measure to category. An aggregated measure would always need to be aggregated and as such can't be registered as stand-alone category value.

 

 

Hope this helps. Falko

 

FalkoSchulz
SAS Employee

I should have added - that typically you will use aggregated measures in visualizations with category value (e.g. list table, bar chart, etc.). Even a simple KPI or KeyValue would work - as long as there is a group-by/category role assigned.

 

Regards, Falko

PavanKumar2
Fluorite | Level 6
Hi Falko,

I have a Distinct count value of Categorical value in Aggregated Measure as
count(Numeric). Now I need to display that value in another section by
using a section Link. Button Bar is accepting only categorical value to
display. there comes the problem.so I have a thought of converting
Aggregated Measure to Categorical value where we can convert Measure to
Categorical by using Format Function . Like wise is there any option of
converting Aggregated Measure in Same manner. Otherwise is there any option
to display the unique count value in another section.
FalkoSchulz
SAS Employee

You can't convert an aggregated measure into a category due to the reason mentioned before (it needs a group-by variable so it can be aggregated). This also applies to distinct count - which gives the number of distinct items given another category.

 

What you could try:

  1. Create a distinct count aggregated measure
  2. Add a button bar to the canvas and assign a category value
  3. Right click on the button bar and create a parameter
  4. In your other section - add a new visualization which utilises the aggregated measure (e.g. bar chart or kpi) and use the parameter in an advanced filter to include data for the selected category value only (the value will automatically change if the user selects another button)

I'm not sure it's exactly what you need - but it should allow you to pass on the selected category in your button bar.

 

Regards, Falko

PavanKumar2
Fluorite | Level 6
sorry Falko ,I couldn't understand Exactly what your saying.
can you Please explain me visually.


Regards,
Pavan

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 2765 views
  • 0 likes
  • 2 in conversation