I want to be able to run a report on top ideas and how many votes they have now compared with how many votes they had in the past, i.e. one year ago.
Great news - you can already do this today with a pivot report.
Add the idea votes table to your pivot
Count the ideas vote id in the cells
Filter on the vote created date.
Please reach out to our product success team at firstname.lastname@example.org if you would like any assistance.
Below is an example of how I set up my report: