How to calculate percentage for a single column

shubha_da — Tue, 21 Mar 2023 06:00:10 GMT

Hello all,

I am working with Viya 3.4 and stuck with a calculated item.

I need to create a calculated item which will be use in a "key value" object to show the results for overall and selected branch/city wise churn %. Data and expected results is like below. I need to show the result in "key value" object only, not in list or tabular object. Please guide how to create that required calculated item to get the result.

Branch	City	Churn flag
Mumbai	abc	0
Mumbai	xy	1
Mumbai	abb	1
Mumbai	wer	0
Delhi	fg	0
Delhi	sd	1
Chennai	er	0
Chennai	ty	0

Churn flag 1 = Exited Churn Flag 0= Active

Expected Result in SAS VA in "Key value" object
Total churn %	37.50%
If select Mumbai from Filter then Churn %	50%

Thanks in advance.

Re: How to calculate percentage for a single column

acordes — Tue, 21 Mar 2023 09:52:52 GMT

It depends on the context, if you want to have both aggregations in the same object like a cross table, then use base expression and intersection.

Re: How to calculate percentage for a single column

shubha_da — Tue, 21 Mar 2023 11:54:29 GMT

Thank you so much. Great help!!

topic Re: How to calculate percentage for a single column in SAS Visual Analytics

How to calculate percentage for a single column

Re: How to calculate percentage for a single column

Re: How to calculate percentage for a single column