topic Re: Set Analysis - Penetration in App Development

Set Analysis - Penetration

Tue, 03 May 2016 21:15:15 GMT

Hi Community,

I am attempting a product penetration calculation to accompany a map. What I would like to happen is when I select a particular state, to have the industry penetration for just that state populate. Long story short, is there a way to add a modifier to the below expression to only calculate based on the state selected. Its currently dividing industry within the state by total industry across the country.

count(distinct {<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])/count(distinct {1<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])

Hopefully that makes sense.

Thanks

Re: Set Analysis - Penetration

swuehl — Tue, 03 May 2016 21:41:14 GMT

Maybe like

count(distinct {<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])

/count(distinct {1<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}, Industry = p()>}[ClientNumber])

Re: Set Analysis - Penetration

sunny_talwar — Tue, 03 May 2016 21:50:01 GMT

Stefan -

I might be wrong, but shouldn't it be this:

Re: Set Analysis - Penetration

swuehl — Tue, 03 May 2016 21:54:10 GMT

I am not 100% sure, as I've read above statement, it's the Industry that needs to be modified.

But p() function should / could be the way to go here.

Re: Set Analysis - Penetration

Tue, 03 May 2016 22:36:07 GMT

I was trying to keep the base state static. This function worked perfectly...

count(distinct {<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'}>}[ClientNumber])/

count(distinct {1<Lost={'N'},TotalActiveEmployeesClient=-{'=Len(Trim(TotalActiveEmployeesClient))=0'},State = p()>}[ClientNumber])

Thank you to both of you!