Hopefully, I've understood the requirements correctly!!...if not let me know.
So to get the count of 'On Time' I created the following calculation
[Count of On Time]
IIF([Timeliness] = 'Decided within the statutory timeframe (20 days plus any extensions)',
and then I can get the %age, by using this and the total count
[%age on Time]
zn(SUM([Count of On Time]))/SUM([Count])
I can then plot this and SUM([Count]) onto the scatter plot.
Hope that makes sense?
TimelinessScatter - SR.twbx 107.2 KB
fabulous simon, thanks.