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.




Image icon barchart.jpg105.09 KB

(1) Answer