Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bubble chart

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:

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?

0 Replies