Bubble chart

Anonymous — Sun, 14 Aug 2016 21:56:14 GMT

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

Column A : Date

Column B: Time

Column C: Network ID

Column 😧 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:

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?

topic Bubble chart in QlikView

Bubble chart