topic Re: Percent of column calculation in App Development

Percent of column calculation

Fri, 30 Oct 2015 15:46:33 GMT

I'm trying to do a win/loss analysis and want to figure out the best way to determine wins, loss, DQ.

The data looks like:

Competitor Name Status Distinct (Opp ID) Win/Loss rates

Comp A Won 673 %

Comp A Lost 221 %

Comp A DQ 425 %

I assume the best way is to create an if/then expression that returns won, lost or dq but I don't know how to have it show as a percentage vs. a #.

Any ideas?

ogster1974 — Fri, 30 Oct 2015 16:18:35 GMT

Do a pie chart on status counting the distinct number of opportunities which a filter on competitor name should give you a nice start.

a KPI on count(<Status={'Won'}> [Opp Id]) / count([Opp Id]) should give you the win rate with formatting as a percentage applied.

JonnyPoole — Fri, 30 Oct 2015 16:35:15 GMT

a few ways but the TOTAL method is pretty easy:

count( Distinct [OppID])

count( TOTAL Distinct [OppID])