Dear Zoho Analytics Community,

For a marketing report I'm working on we're tracking downloads of the content on our website. People that download will enter our CRM as Leads which will be nurtured at a later stage.

We host over +50 downloads and of course people are able to download multiple pieces of content. This is what I would like to figure out.

Let's say there are 5 people A, B, C, D and E.

Person A: downloaded 5 items

Person B: downloaded 3 items

Person C: downloaded 5 items

Person D: downloaded 2 items

Person E: downloaded 2 items

By creating a pivot table or bar chart I can easily see how many times a person downloaded something, but for the report I'm building I need to group these occurrences. So what I'm after is How many times a lead downloaded something X amount of times.

Using the example mentioned above it would be something like this:

5 items downloaded: 2 (leads)

3 items downloaded: 1 (lead)

2 items downloaded: 2 (leads)

Would like to see this data in Bar Chart.

I've been trying a lot of things, but I can't seem to get further than just seeing how often Person A or B downloaded something.

Any help or input would be much appreciated.

Cheers