topic Re: I Need To Convert Aggregated Measure to Category Value. in SAS Visual Analytics

I Need To Convert Aggregated Measure to Category Value.

PavanKumar2 — Tue, 20 Nov 2018 05:31:43 GMT

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.

Re: I Need To Convert Aggregated Measure to Category Value.

FalkoSchulz — Tue, 20 Nov 2018 06:01:03 GMT

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=n11d8xohg1cc49n1d3ovjmgvdeu3.htm&locale=en#n01rndm867dbebn1lornh7r8me8m

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

Re: I Need To Convert Aggregated Measure to Category Value.

FalkoSchulz — Tue, 20 Nov 2018 06:04:31 GMT

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

Re: I Need To Convert Aggregated Measure to Category Value.

PavanKumar2 — Tue, 20 Nov 2018 06:31:10 GMT

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.

Re: I Need To Convert Aggregated Measure to Category Value.

FalkoSchulz — Tue, 20 Nov 2018 08:28:13 GMT

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:

Create a distinct count aggregated measure
Add a button bar to the canvas and assign a category value
Right click on the button bar and create a parameter
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

Re: I Need To Convert Aggregated Measure to Category Value.

PavanKumar2 — Mon, 26 Nov 2018 04:28:10 GMT

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

Regards,
Pavan