Forum Discussion

tabuzahra's avatar
tabuzahra
Helper II
7 years ago
Solved

Bubble Matrix

Hello, I'm trying to do a matrix like the one shown below in the image. Where the buble size depends on number of projects Vs Project Status for each client.   I haven't seen any ready made visual...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    tabuzahra i'm sure this can be done using svg which will allow to create own image and size can be done using data. Can you share sample data? What are those background color? What that represents?

  • parry2k's avatar
    parry2k
    7 years ago

    tabuzahra here is the 1st attempt at it. Didn't follow the logic for background color since there is nothing as project in your dataset.

     

    But you can look at bubbles and make the changes as per your need.

tabuzahra's avatar
tabuzahra
Helper II
7 years ago

The background color can be represented by the Circle color 

parry2k's avatar
parry2k
Super User
7 years ago

tabuzahra here is the 1st attempt at it. Didn't follow the logic for background color since there is nothing as project in your dataset.

 

But you can look at bubbles and make the changes as per your need.

  • tabuzahra's avatar
    tabuzahra
    Helper II
    6 years ago

    Hi Parry,

    I have tried using it but I have got circle wasn't shown in the matrix table as it's showing

     

    data&colon;image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' height='200' width='200' ><circle cx='100' cy='100' r='4100' stroke='#00BFFF' stroke-width='1' fill='#00BFFF' /> <text x='50%' y='50%' text-anchor='middle' stroke='White' stroke-width='2px' dy='.3em'>41</text></svg>

     

    instead of the image, what would go wrong?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello, 

       

      I have the same issue. 

      Did you solve this problem? 

       

      Thank, 

      Anett 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous

         

        Change the data category of the measure you created to Image URL. you will see images instead of text

         

        Regards,

        Rohan

  • tabuzahra's avatar
    tabuzahra
    Helper II
    7 years ago

    Thanks a lot Parry much appreciated. Yes this is what I needed, though I don't have any background in regards of SVG.

     

    How can I change the background color depends on the project status? 

    Example:

    1. If the project status is Ongoing - Delayed or On-Hold for all clients then it should be Red
    2. If the project status is Completed - Delayed for all clients other than (Other Clients & Internal) then it should be Red
    3. If the project status is Completed - Delayed for clients (Other Clients & Internal) then it should be Yellow
    4. If the project status is Cancelled for all clients then it should be Yellow
    5. If the project status is Ongoing - On Track or Completed - On Time then it should be Green

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How do you do the bubble chart in a matrix?

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous the solution posted here (attached file in previous thread) is showing bubble in matrix, not sure if you had chance to look at it or not. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        My guy, this has been an absolute lifesaver.

         

        I've modified it to do some conditional formatting in the KPI for different colours on the circle. 

         

        Can you help me on how to make the text inside the circles bigger and easier to read?