0 Replies Latest reply: Aug 14, 2016 5:56 PM by Fikri Shihab RSS

    Bubble chart

    Fikri Shihab

      I have a Table that contains a few columns like this:

       

      Column A : Date

      Column B: Time

      Column C: Network ID

      Column D: Customer ID

      Column E: Customer status

      Column F: Time (in sec)

      Column G: Region (Region A, B, C....etc.)

      Column H:

       

      Column E indicates the status of the customer, whether it is in network or out of network and column F  tells how long it has been in or out of network.

       

      Another table loaded also simply has columns

       

      Column A: range

      Column B: label

       

       

      I was able to create a chart showing range that shows how many times customer in  network for certain period (e.g. 10 minutes). This is by using range as dimension and expression as follows:

       

      =sum(if(aggr(sum(if(([Time in sec]<60*10 and Customer_status='IN_NETWORK'), 1,0)),Customer_ID, Network_ID, Region, range)<=range and aggr(sum(if(([Time in sec]<60*10 and Customer_status='IN_NETWORK'), 1,0)),Customer_ID, Network_ID, Region, range)>range-1,1,0))

       

      with a chart that I got like below:

      range.png

       

      Now I'd like to draw a bubble chart showing the quantity of in/out network experienced by each customer over period of time. I tried to use some combination available parameters but it seemed not working as I expected. No proper bubble chart is showing up with scatter plots.

       

      Any suggestions how this should be done?