Ok, this gets you MOST of the way there. Couple of things though:

1. Numbers don't have commas. It's 0.1 not 0,1 (which is a comma separated list of numbers 0 and...

Is the task actually working though (did it create the PDF? The reason for SSIS reporting the error is as it says "The process exit code was "255" while the...

I'm surprised you've said that string like '18th February 2015' are being returned with the LIKE statement (as they wouldn't).

I don't think '15 Mar 2017' Is the problem. For example SELECT CONVERT(date, '17 Mar 2017'); works fine.

In your sample data, as I'm going to mention...

SQL Server 2008 Luis/Chris. 😉

Steve has the right answer here. If you want to use SUM or AVG you need to normalise your data. Instead, consider a table such as:
USE Sandbox;
GO

OK, think I have it. Note that the "second" group 2 isn't returned, as all PEOPLE in that group have the value NULL:
WITH CTE AS (
    SELECT...

A NULL has the lowest value when ordering.

At a guess, your two charts don't have the same positioning. Are the top and height measurements on charts are identical? If one is in cm and the other inches,...