dott chart

[spisiakmi]

Hi, can anybody help to create dott chart?

x-axis: _time

y-axis: points of values of fields: tmp, min_w, max_w

Here is the input table:

Here is the wished chart:

[PickleRick]

You can cheat a bit using normal line chart by selecting to not fill gaps and possibly generating empty rows with no value between valid data points.

But there should be better ways to do it.

[ITWhisperer · Accepted solution]

| eval row=mvrange(0,2)
| mvexpand row
| eval tmp=if(row==0,tmp,null())
| eval min_w=if(row==0,min_w,null())
| eval max_w=if(row==0,max_w,null())
| fields - row

Use line chart with no joining for nulls

[spisiakmi]

Hi ITWhisperer, thank you very much. It is working exactly, as I wish. Thank you.