leonardo streit Posted June 6, 2019 Share Posted June 6, 2019 Hi guys, ill 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. Im 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 dont want to use the zoom in tool. 2- Another thing is that I dont 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. Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted June 7, 2019 Share Posted June 7, 2019 To only show bars with a count over 100 go to Properties>>Show/Hide Items. Add a Rule with 'Rule type' set to "Greater than" and 'Value' set to 100, and make sure that "When this rule is matched" is set to "Show items". To get the percentages, go to Properties>>Value Axis, right click on Columns and select 'Custom Expression'. Enter the expression: count() / Count() OVER (Intersect(All([Axis.X]),All([Axis.Color]))) as [Percentage] to get a percentage for your bars. Link to comment Share on other sites More sharing options...
leonardo streit Posted June 8, 2019 Author Share Posted June 8, 2019 Thank you very much Kirsten, I will give a try next Monday! Have a good weekend! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now