As far as I am aware nobody has used modern photographic techniques to investigate what happens to cannister. I have seen the Royal Armouries programme upon Hail Shot of the C15th.
There are no recorded distribution of the sand shot contained within the cannister. There is no record of what happened to the cannister made of 1/4in to 3/8in tin. This is heavy gauge material. These are the questions that I have been exploring wondering whether I had missed the data. I have looked at a considerable number of artillery manuals of the period that I own.
Gassendi (1809), Piobert (1852), Adye (1801, 1806, 1813), Straith (1833, 1850), Boxer (1852), Muller (1757, 1780), Scharnhorst (1806), Griffiths (1839), Aide Memoire (1850) etc....
I have plenty of data of number of strikes upon a target but that is a result.