Unique count and limit minimum range in barchart

Hi guys, i´ll apreciate if anybody can help me.

 

A have a barchart like the index where Value axis is customers IDs and the category axis is multiple kinds of products.

 

I´m strugling with two issues:

 

1- The unique count on value is a ID, and i need to unique count only the IDs that has minimum 100 ocurrences of products (just to clean the chart of ocurrences that is too low), and i don´t want to use the zoom in tool.

 

2- Another thing is that I don´t know how to convert unique count ocurrence of the ID in percentage of total ocurrences.

 

thanks in advance!

 

Ps. my englysh is a work in progress, please be nice.

 

 

Attachments

AttachmentSize
Image icon barchart.jpg105.09 KB

(1) Answer

Login