9 Replies Latest reply: Aug 24, 2016 4:35 PM by Vishwarath Nagaraju RSS

    Scatter Plot Bubble Size

    Chad Smith

      Background:

      We issue recommendations to our clients and we track how long it takes them to rectify the issue (Months Outstanding) and how many times they change the target date to close out the recommendation (# of times revised).  Based on those two factors (expressions) I have created a scatterplot chart with a dimension of Recommendation ID.  It works perfect, I even define the color of the bubbles based on a formula to express criticality. 

       

      Question:

      The only issue is that I can have multiple recommendation ids that have the same Months outstanding and # of times revised and I want to make the bubble larger based on how many recommendations have the same combinations of Months outstanding and # of times revised.

       

      Any help you could provide would be greatly appreciated,

      Chad