I tried to make "bubble chart", and information about this chart is this. - x axis : test start time - y axis : test duration time - bubble size : count depend on "x axis" & "y axis" And this is my code. | eval start_time_bucket = case(
start_time >= 0 AND start_time < 5, "0~5",
start_time >= 5 AND start_time < 10, "5~10",
start_time >= 10 AND start_time < 15, "10~15",
start_time >= 15 AND start_time < 20, "15~20",
true(), "20~")
| eval duration_bucket=case(
duration>=0 AND duration < 0.5, "0~0.5",
duration>=0.5 AND duration < 1, "0.5 ~ 1",
duration>=1 AND duration < 1.5, "1 ~ 1.5",
duration>=1.5 AND duration < 2, "1.5 ~ 2",
duration>=2 AND duration < 2.5, "2 ~ 2.5",
true(), "2.5 ~"
)
| stats count by start_time_bucket, duration_bucket
| eval bubble_size = count
| table start_time_bucket, duration_bucket, bubble_size
| rename start_time_bucket as "Test Start time" duration_bucket as "duration" bubble_size as "Count" So when the start_time is 12, and duration is 2, this data counted on bubble size at start_time_bucket = "10~15" and duration_bucket ="2~2.5". I have a lot of data on each x & y axis, but It only show the bubble when the start_time_bucket = "0~5" and duration_bucket="0~0.5" like under the picture. How could I solve this problem? when I show this data on table, it shows very well.
... View more