I Need To Convert Aggregated Measure to Category Value.

[PavanKumar2]

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.

[FalkoSchulz]

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]

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]

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]

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]

sorry Falko ,I couldn't understand Exactly what your saying.
can you Please explain me visually.


Regards,
Pavan