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.