Create a transactions report using a discount code

I am running an affiliate program where creators put out a discount code and then I want to make reports for how much commission should they get every month (both one time and subscription) based on sales coming through from that discount code. But right now there is no way to generate any report on discount code usage for me.