Percentage Calculation - SpotFire
<p>I am new to Spotfire. </p>

<p>I have a dataset as shown below. I need to count the percentage of "late" events year wise. For instance for the year 2016 "late" event percentage is (3/14)*100.</p>

<p>Could anyone please say the custom expression for this calculation in spotfire?</p>

<pre><code>2018     OTC
2017     InProgress
2017     InProgress
2017     OTC
2016     Late
2016     OTC
2016     OTC
2016     OTC
2016     OTC
2016     Late
2016     Late
2016     OTC
2016     OTC
2016     InProgress
2016     InProgress
2016     OTC
2016     InProgress
2016     InProgress
2015     OTC
2015     OTC
2015     Late
2015     Late
2015     OTC
2015     OTC
</code></pre>