topic How could I show data using bubble chart? in Dashboards & Visualizations

How could I show data using bubble chart?

Questioner — Tue, 23 Jul 2024 11:07:02 GMT

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.

Re: How could I show data using bubble chart?

ITWhisperer — Tue, 23 Jul 2024 12:03:36 GMT

Try using numeric values for your x and y axis

| eval start_time_bucket = 5 * floor(start_time/5)

| bin start_time as start_time_bucket span=5

Re: How could I show data using bubble chart?

Questioner — Wed, 24 Jul 2024 01:26:56 GMT

The upper one (|eval ~) work!

But when I refresh the page, the start_time and bubble_size work wrong.

For Example, This is origin data,

But when I refresh the page, It show like this.

The code is this.

| eval start_time = starttime_data/1000 | eval duration = floor(duration_data/ 1000) | eval start_time_bucket = 5 * floor(start_time/5) | stats count by start_time_bucket, duration | eval bubble_size = count | table start_time_bucket, duration, bubble_size | rename start_time_bucket as "Start time" duration as "Duration"

Is this just server problem? or my Code problem?

Re: How could I show data using bubble chart?

ITWhisperer — Wed, 24 Jul 2024 06:18:06 GMT

Your code looks fine